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
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
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
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.