Linked Excel file in dwg

Linked Excel file in dwg

Anonymous
Not applicable
356 Views
1 Reply
Message 1 of 2

Linked Excel file in dwg

Anonymous
Not applicable

Hi friends

I have created a couple of autolisp programmes related to bridge designing.

I want to know how I can make the autolisp to take data from an excel file.

please help.

0 Likes
357 Views
1 Reply
Reply (1)
Message 2 of 2

dbroad
Mentor
Mentor

What do you want to do with the data? (Present a table, change or create geometry,....)

 

To access Excel (setq exl (vlax-get-or-create-object "Excel.application"))

 

If you want to focus on a more specific loaded version, the progid may need to be more specific.

 

If the workbook is loaded, then you need to drill down to the range data you need

 

Each object's properties and methods can be listed by using:

(vlax-dump-object <object, e.g. exl> t)

 

At the top is  the application object, then the workbook (or workbook collection), then the sheet collection, then the sheet, then the range, etc.

 

To present a table, it is much easier to use either OLE or a datalink.

Architect, Registered NC, VA, SC, & GA.
0 Likes