Import excel spreadsheet?

[Evelynn]

Hi,

 

I was wondering if it's possible to import Excel spreadsheets into my drawing, instead of using the tables? (Using AutoCAD LT 2014)

 

I guess technically it would be easiest if I could import LibreOffice Calc spreadsheets, but I can get access to Excel easily enough if it's the only option.

 

Thanks!

[ReMark]

You could insert the spreadsheet as an OLE object using the PasteSpec command or you could use a DataLink via the Table command.

[steven-g]

It depends on how you want to use/show the info take a look at OLE objects or creating a data link (for excel)

[Evelynn]

You guys rule. Thanks!

[Tuns]

Data link always gives me trouble for some reason. Personally I'd go for the PasteSpec option that ReMark said.

[ColinPearson]

I have a lot of trouble with formatting when using datalinks. When they behave, they're great.

[rkmcswain]

If simply having the data in your DWG is the main objective, then read on....

 

I have my Excel file authors print to PDF, then I attach the PDF file.

When an update is needed, the Excel file author simply updates the PDF.

When the DWG file is opened, I have the latest.

This eliminates data loss, formatting issues, etc.

[Mike_Taylor]

We use a program called Autotable (it is a plugin for AutoCAD), it inserts your excel table as a block with all borders as lines/polylines and all shading is brought in as a hatch. The entire table can be updated in a few clicks once the excel sheet is changed. The biggest thing for us is it allows us to bring in shapes (which we occasionally use on our Electrical Load Calculations).

[BIGAL]

Like I guess Autotable you can do any thing you like it really depends on what you want table, blocks, text, lines. You can have dynamic links that change your drawing objects find the example called SHAFT that was distrubuted with autocad a few years ago change the number in excel you dwg part changed.

 

Reading and writing both ways is fairly simple via programs.