AutoCad read values of a certain cells in Excel

[Anonymous]

I am looking for a way in lisp to have AutoCad read values of a certain cells in Excel.
something along the lines of
(setq cust_name (MI_askstrng "Enter Customer Name.....:"))

but instead of "Enter Customer Name", I would like it to read chosen Excel Doc, Sheet 1, Cell B2.

[dbhunia · Accepted solution]

Check This

[Anonymous]

Thank you for your reply i have one more doubt if i do not want to select a file and want the program to directly open the file from a folder,

(setq fileName(getfiled "Select Excel File" "C:\Support\LISP FILES\data.xlsx" "xlsx" 16))

the above code is not working and it is still asking me to select, thanks in advance

[dbhunia]

use this

To select File Directly - (setq fileName "C:\\Support\\LISP FILES\\data.xlsx")

To select Sheet Directly -(setq sheetName "Sheet Name")

[Anonymous]

Thank you now there is no need to select the file again and again but

whwnever i select the cell it shows-

; error: bad argument type: VLA-OBJECT #<%catch-all-apply-error%>

[dbhunia]

Make sure about "Entered File Path" & "Sheet Name" existence.

[Anonymous]

it seems like the problem is with this line 

;;;--- Get the excel file
(setq fileName "C:\\Support(WL)\data.xls")

 but i am not sure what

[dbhunia · Accepted solution]

---

@Anonymous wrote:

it seems like the problem is with this line 

;;;--- Get the excel file
(setq fileName "C:\\Support(WL)\data.xls")

 but i am not sure what

---

It should be.......

(setq fileName "C:\\Support(WL)\\data.xls")

[Anonymous]

i have a doubt, can you please explain what is the meaning of the code-

cus_name (MI_askstrng "Enter Customer name....:" (nth 0 #TTLE))
#TTLE (LI_RepList #TTLE 1 cus_name)

[dbhunia]

I did not get all the things .......

post the code......

[JBerns]

@dbhunia,

Do you know where else I may search for Jeffery P Sanders AutoLISP collection for reading and searching Excel (XLS/XLSX) files? The link in your message reports the site can't be reached. Perhaps the site is just temporarily down.

Thank you for your time and attention. I look forward to your reply.

Regards,

Jerry