CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
Cesky English Deutsch
 Visitors: 5510 
Plex.Earth connects AutoCAD and Google Earth

CAD tip CAD tip # 6304:

Question CAD 
 %  platform  category 
Q - question

How to insert a live-updated XLS table in an AutoCAD drawing?

A - answer You can insert an Excel table, Word document or other OLE object (e.g. from MS Office) into your DWG drawings. Such object will keep the link to the original file and when the original is updated, it updates also the AutoCAD contents.

This function is available in all Windowes versions of AutoCAD. In higher AutoCAD versions, you can also use more advanced functions which link XLS tables directly to native AutoCAD entities.

Insert the OLE object using the INSERTOBJ command (Insert > OLE Object...). In the "Insert object" dialog, choose "From file" and pick your .XLS (.DOC, etc.) file. It is important to check the "Link" option and uncheck the "Display as icon" option. End the dialog by OK. Right-click on the inserted OLE object to move it, scale it and set its properties (scale, display quality, etc.).

Any subsequent changes in the .XLS file will immediately (after save) display also in AutoCAD.

100% *  CAD 
12.9.2008    15011×  
Comments   Tell a friend

See also:
Tip 9363:How to hide the frame of a wipeout, embedded DWF or DGN?
Tip 8543:Setting command line background color from LISP.
Tip 7678:Converting raster image to a matrix of pixels inside the DWG.
Tip 5535:An effective way to bind raster images inside DWG files.
Tip 5026:Raster images disappearing during zoom/pan.

Back   All CAD Tips All CAD tips&tricks

How to lock all viewports in all layouts? « | » How to get XYZ coordinates of a point on an Inventor assembly?

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Link your AutoCAD texts with Excel tables/sheets. Export. Change. Import.
Try DwgText 2015 More info

Please use these tips at your own risk.
CAD Studio (Xanadu) is not responsible for possible problems that may occur as a result of using any of these tips.