AutoTableX-QXLink can link AcDbTables with Excel spreadsheets and process the AcDbTable update on cells' contents from the linked Excel spreadsheets. AutoTableX-QXLink will only focus on content strings, other cell properties such as Style, Alignment, Rotation, Color are discarded.
To start AutoTableX-QXLink just type QXLINK at AutoCAD "Command:" prompt.
Options in AutoTableX-QXLink dialog:
- Linkage data between AcDbTable and Excel spreadsheet:
Linked AcDbTable and Excel spreadsheet will display together in the list. Each line contain two parts: the 1st is the handler of AcDbTable and the other one is the name of the spreadsheet. When there is no linkage found, the list will be CAD *EXCEL* and some relative buttons will be gray.
- Establish a linkage:
A new linkage can be added by picking a valid AcDbTable. Then a representative table will be created in Excel (if the Excel is not active, AutoTableX-QXLink will start Excel automatically). The spreadsheet name will be changed into linkage mode.
- Zoom to the AcDbTable:
AutoTableX-QXLink supports multiple AcDbTables in the list (but it can only UPDATE and REMOVE them one by one, only the active AcDbTable will be processed). AutoTableX-QXLink can zoom the window to display the active AcDbTable in graphic screen only.
- Data synchronization from Excel to AutoCAD:
The [Update <] button will run the synchronization procedure on active AcDbTable. Whatever is changed in Excel will take effect on linked AcDbTable.
- Processing BlockCell:
If BlockCell is in the AcDbTable, it can overwrite the blocks in cell by content string in Excel or keep the blocks there.
- Remove linkage:
Removing the linkage will not close existing representative table(s) in Excel. The dropped linkages will be alive on next calling of AutoTableX-QXLink. If all linkages are removed, CAD *EXCEL* will appear in list.
- Overwite BlockCell with normal text:
BlockCell will be empty in Excel; if these empty cells were filled in Excel, the update procedure may be able to switch the BlockCell into TextCell and fill the contents from Excel.
- Lock FIELD contents:
Only the field content will be exported into Excel; if it is needed to have these content back into AcDbTable cells, the content may be changed into normal text and lose all fields information.
- Math functions synchronization between AcDbTable and Excel:
In AutoCAD2006+, math functions in AcDbTable or just the results can be passed into Excel directly. Any change (modification/addition) on math functions in Excel will also be transferred back to AutoCAD as same as in Excel.
- Merge cells in Excel:
AutoTableX-QXLink will not process merged cells. Merging certain cells in Excel will help users obtaining a better conception in Excel and changing correct cells.
- Keep the linkage re-connectable or totally erase:
By default, AutoTableX-QXLink will shut down all linked spreadsheets in Excel, but it can still keep these linkages alive by disabling this option.