retreive cell data from excel file

[spykat]

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?

[Anonymous]

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

[Lee_Mac · Accepted solution]

This by Terry Miller may help you.

[spykat]

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

[Anonymous]

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.

[ebpCAD18]

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.

[mttlp]

vlax apply line error