Converting Excel data to Acad DXF
Converting Excel data to Acad DXF
(OP)
Doe anyone know of a link that explains how to convert an excel 97/2000 file into autocad dxf file. Any help from all you experts would be greatly appreciated.
Thanks Tim
Thanks Tim
RE: Converting Excel data to Acad DXF
You should specify first of all what kind of data you have in the Excel file (coordinates? data defining entities of different types? graphical objects?) and perhaps also your goal (what kind of drawing from what kind of data/application?).
I think you'll need to write your own program in Visual Basic: at the least it will be a cumbersome task.
prex
http://www.xcalcs.com
Online tools for structural design
RE: Converting Excel data to Acad DXF
contact me at k281969@hotmail.com
Pardal
RE: Converting Excel data to Acad DXF
you can actually cut and paste from excel to autocad.
You will however have to set up a column for "x,y".
eg.
the column you copy and paste into acad would have the
follow formula if X is in column A & Y is in column B:
A1&","&B1
RE: Converting Excel data to Acad DXF
Tim
RE: Converting Excel data to Acad DXF
k281969@hotmail.com
you could use it to learn
Pardal
Pardal
RE: Converting Excel data to Acad DXF
http://www.idealeng.com/xls2dxf3.htm
Pardal
RE: Converting Excel data to Acad DXF
If all what you need is to create curves using precalculated coordinates, you can create a simple script (*.scr file).
You'll find more about it in the ACAD forum or in the ACAD manuals, I learned about it the forum and used it couple times. It also works in ACAD LT.
gearguru
RE: Converting Excel data to Acad DXF
1)Make a sample drawing with a POLYLINE in layer 0(supposing this is the only entity you want to import)
2)Output the corresponding .dxf
3)Load the .dxf in a text only word processor and look at its structure, that you should study, at least the basics, on the manual
4)Discard the SECTION 'HEADER' (unless you want to keep some special settings) and the SECTION 'BLOCKS', thus keeping only the SECTION 'ENTITIES'.
5)Write a program in Excel that reads in your coordinates and reproduces the file structure as you obtained in the previous step. Note that it might be simpler for you to discard Excel and use a plain text file to store your coordinates: a simple program written in any language (I suggest Perl) will do the job.
prex
http://www.xcalcs.com
Online tools for structural design
RE: Converting Excel data to Acad DXF
Thanks for all the great tips.
Tim