AutoCAD 2010/2011/2012

Reply
Contributor
ezwingman
Posts: 13
Registered: ‎07-14-2011
Message 1 of 7 (5,111 Views)

Can you link autocad text to a field in an excel sheet

5111 Views, 6 Replies
01-27-2012 08:13 AM

I would like to link a series of text lines in an autocad drawing to there corisponding fields in an excel sheet, I can not use tables in autocad becasuse of the way other software uses the text in autocad. I have attached files of the text leyout in acad and of the sheet in excel. One thing that keeps me from using tables in acad is that every line of text is on a different layer, with tables you can't control the layer of table its always on the current layer. Just letting people know why I'm where I am.

 

Thanks

Ed

Product Support
luconceicao
Posts: 583
Registered: ‎11-07-2007
Message 2 of 7 (5,052 Views)

Re: Can you link autocad text to a field in an excel sheet

01-31-2012 08:11 AM in reply to: ezwingman

Hi Ed,

 

Is the content of the text coming from blocks?

Do you want that each text line in acad text.jpg is in a different layer?

Can't you use the Data Extraction tool because it will create a table with only one layer?

 

I don't know if I understand exactly you are looking for, please give more details.

 

Cheers,

Luciane

 

Luciane Conceição
Product Support Specialist
Autodesk, Inc.

Valued Mentor
TerryDotson
Posts: 482
Registered: ‎06-06-2010
Message 3 of 7 (5,049 Views)

Re: Can you link autocad text to a field in an excel sheet

01-31-2012 09:47 AM in reply to: ezwingman

If you were to consider third party software, take a look at the Annotation Links in XL2CAD Pro, it lets you link random text/mtext to random Excel cells and automatically updates them when the drawing opens.

Contributor
ezwingman
Posts: 13
Registered: ‎07-14-2011
Message 4 of 7 (5,025 Views)

Re: Can you link autocad text to a field in an excel sheet

02-01-2012 12:22 PM in reply to: luconceicao

Yes, each line in the jpg file is on a different layer, the reason is software we use to program cnc routers looks at each line of text and uses the layer name to point it to where it belongs. I have the data preexisting in excel, and the text lines are not blocks, my goal would be to have the text line equal the excel data on a corrisponding table.

Product Support
luconceicao
Posts: 583
Registered: ‎11-07-2007
Message 5 of 7 (5,000 Views)

Re: Can you link autocad text to a field in an excel sheet

02-02-2012 09:08 AM in reply to: ezwingman

Thanks for the explanation.

 

I am only aware of manual ways of doing this, for example, copy the cells in Excel, paste special (as AutoCAD entities), explode the table and apply the layers as desired.

 

Other than this, you could probably do it programatically (see the related forums) or use a third-party application if there is one that does what you need.

 

If you would like to have this feature in AutoCAD (an automated process), I suggest you log a wishlist item with our developers:

http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=1109794

 

Hope this helps,

Luciane

 

Luciane Conceição
Product Support Specialist
Autodesk, Inc.

Contributor
ezwingman
Posts: 13
Registered: ‎07-14-2011
Message 6 of 7 (4,980 Views)

Re: Can you link autocad text to a field in an excel sheet

02-06-2012 09:10 AM in reply to: luconceicao

This goes back to a preivious wish list item I asked for which was to be able to control what layer a table and it content were on, as it is now the tables are on the current layer. If you could control the layer of a table, I could probably make one field tables and link them with excel fields and make it work. It's strange that you can put text on any layer but tables and their content are only on the current layer.

 

Thanks, Ed

Product Support
luconceicao
Posts: 583
Registered: ‎11-07-2007
Message 7 of 7 (4,977 Views)

Re: Can you link autocad text to a field in an excel sheet

02-06-2012 09:19 AM in reply to: ezwingman

Hi Ed,

 

It makes sense.

I think what happens is that a table is a single entity at the moment. Maybe it will change in the future.

 

Let us know if we can help any further.

 

Cheers,

Luciane

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

    Come hangout with Autodesk Support Specialist and AutoCAD guru Volker Cocco, to learn about Precision Drafting: Object Snaps and Object Tracking on July 31 @ 11:00 AM PST.

    Click here for registration information!

Need installation help?

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

Ask the Community


Connect with AutoCAD

Twitter

Facebook

Blogs

Pinterest

Youtube