Linking Drawing Data to Spreadsheets
Tips on pulling data from AutoCAD drawings into Excel spreadsheets to compile cabinet ordering information. November 26, 2007
I am in the process of drawing casework for a few hundred apartments. One thing I would like to do is include a MS Word document in the drawing that I can edit with quantities of different base cabs, wall cabs, fillers, etc. Is there a way I can pull the numbers from the drawing and insert them back into a spreadsheet for ordering?
From contributor Y:
I do not know about MS Word, but the latest version, ACAD 08, has a bidirectional link with MS Excel. Depending on the ACAD version, you can find an add-on program that will do this. Check Cadopolis.com for ACAD useful add-ons.
From the original questioner:
Currently running AutoCad 2006.
From contributor J:
Look into using tables. On one project with hundreds of cabinets, I set up various blocks with attributes. One for each type of cabinet, base, upper, tall, sink, etc. The attributes where (name, WxHxD). I created one of each type of unit with the attribute above or below the cabinet along with a dimension. Then when I needed to put a string of cabinets together, it was like drag and drop. Then when I was ready to create a table, just window the area I wanted, and the table was created with the quantity of each block and the attributes. You need to play with the table setup a bit, but it worked out great.
From contributor B:
You should be able to copy an Excel table into your drawing. Once it's there, you can easily edit it. It's been a while since I used 2006, but have been using Excel in AutoCAD since version 2000.
Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?
Have you reviewed the related Knowledge Base areas below?
KnowledgeBase: Knowledge Base
KnowledgeBase: Computerization: CAD Computer Related Design
All rights reserved. No part of this publication may be reproduced in
any manner without permission of the Editor.
Review WOODWEB's Copyright Policy.
The editors, writers, and staff at WOODWEB try to promote safe practices.
What is safe for one woodworker under certain conditions may not be safe
for others in different circumstances. Readers should undertake the use
of materials and methods discussed at WOODWEB after considerate evaluation,
and at their own risk.
335 Bedell Road
Montrose, PA 18801
Copyright © 1996-2019 - WOODWEB ® Inc.