Evelynn Posted January 9, 2014 Share Posted January 9, 2014 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! Quote Link to comment Share on other sites More sharing options...
ReMark Posted January 9, 2014 Share Posted January 9, 2014 You could insert the spreadsheet as an OLE object using the PasteSpec command or you could use a DataLink via the Table command. Quote Link to comment Share on other sites More sharing options...
steven-g Posted January 9, 2014 Share Posted January 9, 2014 It depends on how you want to use/show the info take a look at OLE objects or creating a data link (for excel) Quote Link to comment Share on other sites More sharing options...
Evelynn Posted January 9, 2014 Author Share Posted January 9, 2014 You guys rule. Thanks! Quote Link to comment Share on other sites More sharing options...
Tuns Posted January 9, 2014 Share Posted January 9, 2014 Data link always gives me trouble for some reason. Personally I'd go for the PasteSpec option that ReMark said. Quote Link to comment Share on other sites More sharing options...
ColinPearson Posted January 20, 2014 Share Posted January 20, 2014 I have a lot of trouble with formatting when using datalinks. When they behave, they're great. Quote Link to comment Share on other sites More sharing options...
rkmcswain Posted January 20, 2014 Share Posted January 20, 2014 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. Quote Link to comment Share on other sites More sharing options...
Mike_Taylor Posted January 20, 2014 Share Posted January 20, 2014 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). Quote Link to comment Share on other sites More sharing options...
BIGAL Posted January 22, 2014 Share Posted January 22, 2014 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.