Jump to content

Data Tables content linked to Excel?


lasan
 Share

Recommended Posts

Hi,

 

It's my first post in this forum, I hope this is the right place to post my question.

 

Im using Autocad Map 2011 and I have a DWG file with hundreds of data tables (2x2) spread all over a map. All table content is in text, and they have a cell with an ID (manually inserted in autocad - in the first top/left cell)

 

My goal is to link the data table contents to an excel spreadsheet, so that i can update table values from excel.

 

Can someone help me?

Attached its a dwg file to get the idea.

Drawing1.dwg

Link to comment
Share on other sites

I am not 100% sure the difference from regular ACAD to Map, but from what I can see on normal ACAD you would have to set up an individual data link for each table you have inserted (easiest way would be through a named range in you Excel file).

Link to comment
Share on other sites

That is the only way I can think of OOB, there are likely LISP routines/addins that will allow this to be done more efficiently.

 

This may be a solution and Blocks could be used rather than table. I have not used this product myslef, but I have been wanting to take a look at it for some time now.

Link to comment
Share on other sites

Sorry for late reply.

Thanks for the suggestions.

Mike_Taylor, thats exacly what im trying to avoid, to link individually each data table. But Im going to try your suggestion, on the second post. I will give feedback.

 

Im not sure if this makes sense, but here it goes...

If I had the information in excel and the only think i need from cad data tables was the coordinates to use as a key to table id (content from first cell) would it be easier to solve?

Link to comment
Share on other sites

You can link N Excel records (each containing M fields) to N Autocad ID's, but the result won't be a beautiful table like yours.

 

With the command _MAPDEFINELT, you'll get N objects, each containing M "object datas", visible in Properties.

 

 

:)

Link to comment
Share on other sites

Rather than having real time data links you could run a lisp that read the excel and updated the tables like wise add a table - add to excel. It only requires the table ID to be part of excel data.

Link to comment
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.   Restore formatting

  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.

 Share

×
×
  • Create New...