How to Export a Specific Column(s) of a Table to Excel

[Anonymous]

I will first describe my over-arching goal, then go into the details, and lastly will ask explicit questions. Thanks in advance.

Overall goal: Interface AutoCAD drawing with a second AutoCAD drawing that will be the template for a laser engraver.

Details: Essentially, we have drawings with parts tables for our products. One column of the parts table is the "Tag #" for any given part. The goal is to open these drawings with the parts tables and be able to easily export just the parts table column with tag numbers to a second drawing, that will populate certain cells in the second drawing based on the length of the tag number (which will then engrave on different sized tags). 

Questions: How can I export one or more columns of a table to Excel rather than a complete "tableexport"? Is there a better way of doing this whole process?

I have some knowledge of AutoLISP and am currently trying in earnest to gain more. I greatly appreciate your time and hope to hear back. Thank you.

[ara_neresesian]

HI,

which table ,are  you talking about dataextraction or  draw/table ? 

please upload a sample and and mark the table you want to export.

Thank you.

[Anonymous]

Hello,

I've attached an example file below. We just want to export columns 1 and 2 from these tables, so the boxes that increase numerically, vertically. The next step would be to import them into another drawing that has different sized text boxes available. The overall goal is to be able to populate those tables (in the second drawing) based on the length of the tag numbers.

Thank you.

[ara_neresesian]

hi

For Part 1

Select one cell by clicking  inside the cell,hold shift to add another cells.

the yellow  area at picture .

now you can press ctrl +c and paste it  (in the second drawing)

but for  your "next step ,different sized text boxes" ,it think  you need to use a spacial lisp or VBA.

i think if you can use Excel ,you can do what ever you want,and import the final table into the drawing  as a OLE object.

if you want to do all of them in autocad , its a hard and long story.

good luck.