×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel to Autocad

Excel to Autocad

Excel to Autocad

(OP)
We have a drawing file with hundreds of of individual text items. These same text values are in one column of an Excel spreadsheet. Next to that column is another column of text that we would like appended to the Autocad text item. Would there be an automated method of editing the Autocad text by adding the text in the adjacent Excel column?

RE: Excel to Autocad

Using VBA you can access the text items and append the data from Excel. You could write the program in Excel VBA, include the AutoCAD object library and you're on your way. It shouldn't be that complex, but will take a little time to write.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Excel to Autocad

The other thing yopu can do is to copy and paste teh list from Excel into AutoCAD.  

When you paste it, it can be either as AutoCAD Entities or keep as an Excel Spreadsheet.  If you keep is a spreadsheet it will ask for a an equivelent text height.  Once it is in your drawing you can update it at anytime bt doubel clicking on it.  This works especially well for BOMs.

RE: Excel to Autocad

Hi,

There is a program that I use called CADminer which can do this. Basically, it's a CAD information-mining tool and has a relational database where you can link/import info. from a spreadsheet and annotate your drawing near the selected entities. Better, it can do this automatically and dynamically - i.e., constant changes to the drawing as the external file changes. You can download a free trial from www.cadminer.com. Hope that helps.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources