Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Exporting Bill of Materials from Autocad to Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]

I'm not an AutoCAD guru either. We did export a table of notes successfully,
but it was a couple of years ago, so I don't remember all the details.

I think we used a lisp called txtexprt.lsp from

It will export a body of text to a .txt file.

It's then not too difficult to import the .txt file into excel, and parse

Here's a warning - if you import a piece of text into Excel that might be
interpreted as a date, or as any other special format (eg fraction), then it
_will_ be, because the default format for the import cells is general. You
can avoid this by setting the offending column as text format as you import
it - but not after...

Peter James

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*   Questions to seaint-ad(--nospam--at) Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: 
******* ****** ****** ****** ******* ****** ****** ********