Visual LISP, AutoLISP and General Customization

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

retreive cell data from excel file

356 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*
Posts: 1,250
Registered: ‎01-09-2007
Message 2 of 6 (353 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,044
Registered: ‎12-29-2009
Message 3 of 6 (352 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
Posts: 180
Registered: ‎08-13-2003
Message 4 of 6 (347 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*
Posts: 1,250
Registered: ‎01-09-2007
Message 5 of 6 (338 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
Posts: 3
Registered: ‎01-25-2013
Message 6 of 6 (162 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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community