Exporting multiple tables to one excel

[Anonymous]

I have a drawing with multiple tables  that i want to export in a Excel sheet and verify.

Anyone bright minds with ideas?

[parkr4st]

what type of tables

tables associated with FDO data or tables in the dwg? 

dave

[Anonymous]

In the Drawing

[O_Eckmann]

Hi,

You can use MAPEXPORT to export your data to SHP file.

You have to export table by table to separate SHP by checking all field of OD per table. (tab Data, section ObjectData, french terms in my screen capture)

With each export, you obtain a minimum of 3 files (SHP, SHX and DBF). You can open DBF file with Excel (or better LibreOffice Calc), which contains all alphanumeric attributes data.

Olivier

[parkr4st]

or the command

TABLEEXPORT, select the table and it goes to a .csv file which can be opened directly in Excel

[Anonymous]

Table export works with only one table at a time, whereas i need all the tables of my drawing to be exported to a single spreadsheet.

The second option about Mapexport , it works with only object data but i have a simple table in my drawing so this function will not work with this unless i attach object data to table.

[Anonymous]

I have attached a sample file for the reference, all the tables need to be exported to Excel at once.

Thank you

Kavita G

[TerryDotson]

Out of curiosity, would each table become a sheet in the resulting workbook (seems the only logical choice)?  If so (since your headers are the same) the sheet names would have to be randomly named.  Lastly, would you expect a link back to the tables so that if the spreadsheet changed the table could update?

[Anonymous]

Correct, this would be a ideal output for my work, will it be possible to get such a lisp?

[parkr4st]

what is the data in the tables relative to?

[Anonymous]

Its relative to length of the items in FT , counts for some items  , but the unit remains constant only the values will change,

so for multiple tables in a single dwg, the same units may or may not repeat but the values for that particular unit for a particular column will always be unique