×
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 Files
2

Excel Files

Excel Files

(OP)
How can I convert Excel files into dwg files, so that I can use the drawing rather than it being an un-explodeable block??????

RE: Excel Files

There are several shareware lisp programs available for this purpose, one of which is "ctext". To use this you need to save the excel file as a formatted "prn" file, rename the file as a ".txt" file prior to importing it into autocad using "ctext".

This lisp file lays the text file out in autocad as text in the layout it would print in. You will need to edit the text to realign it into columns if required.

The file can be found at:   www.cadalog.com ;  under the file name: "ctext.zip".


regards
sc

RE: Excel Files

2
Another way to do this is to highlight all of the cells insid the excel file and copy to the clipboard. Next paste the file into autocad,once pasted select the object and then cut. Now select paste special and insert as autocad entity. you will now have your excel file in dwg format with all of the text intact. I tried it out it works great.

RE: Excel Files

It is a good method cadkid, but, I found that it works with small portions of spreadsheets only. I tried an 8 col by 83 row spreadsheet, but it would not work. Any suggestion as to why? is there a limit set by autocad?

sc

RE: Excel Files

I foun this at Autodesk's web site

"When an Excel spreadsheet is pasted, the Picture (metafile) format is used, which can result in the spreadsheet being truncated. This problem can occur when the column width and row height in Excel are set to the default (default width is 8.43, and default height is 12.75), and the pasted object exceeds 18 columns by 70 rows.

Use one or both of these methods to resolve the problem:

Method #1
In Excel, reduce the column width and row height. You can paste more of the spreadsheet if you reduce the column width and row height.

Method #2
Paste the spreadsheet in separate parts. By pasting the spreadsheet in separate parts you can break it down into several smaller OLE objects."

RE: Excel Files

thanks cadkid

sc

RE: Excel Files

I have a xls2dxf.xls file I had dowloaded not know the origing
maybe you can search or I can sent if you give your e-mail.

It is a demo but it works well.

Pardal

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