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 (394 Views)
Accepted Solution

retreive cell data from excel file

394 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 (391 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,270
Registered: ‎12-29-2009
Message 3 of 6 (390 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 (385 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 (376 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 (200 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
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.