KozMos VLXLS Sample: VirtualTableModifier
Modify & synchronize AutoCAD VirtualTable TEXTS via Excel
VirtualTableModifier: Introduction
KozMos provides an example file to demonstrate the power and convenience using VLXLS to make data exchange between Excel and AutoCAD.
The routine will send contents of user selected TEXTS into Excel so that they can be modified within Excel. When the modification is done, the program will read data from Excel and modify the contents of TEXTS in AutoCAD automatically. Thus we can use some Excel features such as sort, number adding to change AutoCAD TEXTS very quickly.
All selected TEXTS will be treated as cell contents of a [Virtual Table] in AutoCAD. The [Virtual Table] will be re-built in Excel so that the contents of TEXTS lying on correct Excel cells.
Name of this example codes is called as Virtual Table Modifier
(VTM). There is only one command "VTM" defined in VTM. Make sure that VLXLS.LSP has been loaded before calling VTM command.
View full source codes of VirtualTableModifier HERE!
VirtualTableModifier: Steps
 |
STEP1:
This is the Virtual Table TEXTS in AutoCAD before calling VTM
command. When invoke VTM and select these texts, Excel will be
automatically started and the contents will be sent into current
active Excel spreadsheet. |
 |
STEP2: Then switch to Excel and this will be seen. The next step is very simple to edit the texts in Excel. Please not only Excel cells containing un-null string will be valid to send data back to AutoCAD. Modify to other cells will be ignored. |
 |
STEP3: After finish the modification in Excel, go switching back to AutoCAD again and press the OK button on alert dialog to make AutoCAD continue with the synchronization procedure and you will get the AutoCAD texts changed as modified in Excel. In this step, Excel will be closed automatically. |
//Koz Jono Yeoh//
Copyright(C) 1994-2009 KozMos Inc
All rights reserved.