Visual LISP, AutoLISP and General Customization

Visual LISP, AutoLISP and General Customization

Reply
Distinguished Contributor
spykat
Posts: 180
Registered: ‎08-13-2003
Message 1 of 6 (385 Views)
Accepted Solution

retreive cell data from excel file

385 Views, 5 Replies
10-07-2011 08:18 AM

I would like to be able to retreive data from a sepcified cell, in a specified worksheet, from an excel file.

I don't have any clue how to connect to an excel file and read the data. I've searched the forum and found nothing that help me understand. Most seems to think you already had an understanding but I'm starting from the beginning.

Can somebody help me?

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 2 of 6 (382 Views)

Re: retreive cell data from excel file

10-07-2011 08:42 AM in reply to: spykat

You need to use the Link to range option from the data link options while trying to create a table.  See attached.

*Expert Elite*
Lee_Mac
Posts: 1,166
Registered: ‎12-29-2009
Message 3 of 6 (381 Views)

Re: retreive cell data from excel file

10-07-2011 08:45 AM in reply to: spykat

This by Terry Miller may help you.

Lee Mac ProgrammingTwitterExchange App StoreDropbox (500MB free)
Expert Elite
With Mathematics there is the possibility of perfect rigour, so why settle for less?
Distinguished Contributor
spykat
Posts: 180
Registered: ‎08-13-2003
Message 4 of 6 (376 Views)

Re: retreive cell data from excel file

10-07-2011 09:08 AM in reply to: azrdgldr

I guess I should have stated that I need to do it from lisp

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 5 of 6 (367 Views)

Re: retreive cell data from excel file

10-07-2011 10:13 AM in reply to: spykat

No problem!  The better information you provide up front, the better help you will get.  As they say in this business "There are several ways to skin a kat".  You just have to find the one that works best for you.

Member
ebpCAD18
Posts: 3
Registered: ‎01-25-2013
Message 6 of 6 (191 Views)

Re: retreive cell data from excel file

02-06-2013 12:19 PM in reply to: spykat

I'm trying to do something similar but just for select cells in excel to show its info in either an Mtext or attribute definition format and not in a table.  I'm not sure if this is possible.  Specifically I would like to do is link information from my information sheet (like project name or location) directly into the title block in the corresponding location.  The idea was that if i was able to use a relative path that I would do this in each job folder and each drawing generated in that folder would reflect that info.  I'm trying to create this in LT, so without a LISP program.

 

Any help would be appreciated.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.