Visual LISP, AutoLISP and General Customization

Visual LISP, AutoLISP and General Customization

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

retreive cell data from excel file

393 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?

This by Terry Miller may help you.

*Expert Elite*
azrdgldr
Posts: 1,250
Registered: ‎01-09-2007
Message 2 of 6 (390 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,261
Registered: ‎12-29-2009
Message 3 of 6 (389 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: 181
Registered: ‎08-13-2003
Message 4 of 6 (384 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 (375 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 (199 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.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!