Visual LISP, AutoLISP and General Customization
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Importing an Excel column into a list

1 REPLY 1
Reply
Message 1 of 2
Dewlevlak
346 Views, 1 Reply

Importing an Excel column into a list

I am trying to import a list of customers from column A in an Excel file into a list for a popup_list for my Drawing Properties DCL.  I am having trouble finding information on how to do this.

 

Basically: Load the file, (workbook through active sheet: vlax-get-property)

(setq xlSheets (vlax-get-property xlBook 'WorkSheets) )

 

Then, how do I get it to put column A properly into a list for the DCL?

 

Thank you,

 

1 REPLY 1
Message 2 of 2
devitg
in reply to: Dewlevlak

Maybe it can be do easy , "saving as" the xls as CSV , then you can open the file for  "R"

 

 

 

And loop while it can read lines, adding it to the list by CONS 

 

 

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost