Jump to content
PKTCISME

Is there a way to field data located in a imported excel file?

Recommended Posts

PKTCISME

The overall goal is to reduce data entry.

 

I have an excel file that has been special pasted into my Autodesk AutoCAD LT.

I want to take information from individual cells and make them into fielded values.

 

If you have follow-up questions, I will be happy to answer.

Share this post


Link to post
Share on other sites
BIGAL

One day Autodesk will put lisp in LT getting and putting is well documented both ways DWG- Excel, my advice buy alternative software that has lisp. The more smarter you want to work the harder it will get.

Share this post


Link to post
Share on other sites
steven-g

BIGAL I'm not sure that I 100% agree about the getting harder bit, it can certainly cause a few headaches, and yes it falls a long way short of the capabilities of full Autocad. That said it is possible to get a table contents into a field, you need to use the formula option within the field names dialogue and then from there you have the choice to pick a cell, which refers to a table cell, and Autocad will prompt you for that. It does keep track of the table if it alters after updating the table, but you do need to regen the drawing.

Share this post


Link to post
Share on other sites
BIGAL

Steven-g you should write a book on how to make LT really work, maybe have a chat to Lee-mac about a web page with all your brilliant suggestions. You may not become a millionaire but it may return beer money. Just a question how many macros do you have ?

Share this post


Link to post
Share on other sites
steven-g

Shhh

I am learning web design at the moment. but it's a slow process, and I have seen too many sites pop up and then disappear because they haven't been thought out, I don't intend to just throw something together. It's getting there slowly.

How many macro's ? probably in the hundreds, if they are usefull is another question altogether 8)

Share this post


Link to post
Share on other sites
PKTCISME

Hello all,

A big thanks to steven-g. I've got my numerical values to work.

 

The next step is to play around with cells within the table that contains letters and numbers.

 

I will continue to play around with the field command.

Share this post


Link to post
Share on other sites
PKTCISME

Hello all,

I still haven't been able to flush out the letters. Any suggestions?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...