Sometimes it can be very useful to have some additional data inside an AutoCAD drawing, so how do I insert an Excel spreadsheet into AutoCAD? It is pretty straightforward to set up and if done correctly, data that is inserted will automatically update when the original spreadsheet is updated within Excel.
Firstly, open the desired spreadsheet then select the data you want and copy it to clipboard.
In AutoCAD go to Edit > Paste Special
In the dialog box, select Paste Link, then as Microsoft Office Excel Worksheet. If the radio bottom is grayed out and un-selectable, as below, then the data currently on the clipboard is unsuitable.
Then click OK. The formatting of the original data should remain, and the data inserted will update inline with any updates made to the external Excel spreadsheet. This means that you won’t need to worry about updating two sets of documents if changes need to be made.
If you found this useful, why not check out some of my other AutoCAD posts?
Our 302 project built upon the work we completed for Design 301. We were tasked with designing a building which both a public and private function. An additional requirement was that the private function should be connected someway to our findings in 301. During my 301 project I developed work based upon violence and unrest on the road, which led me to design a self defence institute, with private accommodation for victims of domestic violence.
The project started with a brief page, some history, and an “interruption”. The interruption was a small change that we would make to the area in response to some of the issues raised.
The scheme includes a large slow staircase/path, connecting Lower Marsh with the higher up Station Approach road. I tried to play with levels and height as much as possible, leading me to split activities and private/public areas across the site.
Quick model making was very helpful in the development of this project, and the design changed many times with rough sketches on detail paper.
As the project was only 7 weeks long, there was not much time available for rendered images. This led me to produce quick collage like images to illustrate the impact on the road, materiality and usage.
If you liked this post, why not look at some of my previous work:
For Mac users Rhino OS X is available for free however, the program is still very much WORK IN PROGRESS. So there are a few major features missing, bugs and fortnightly updates. Save and back up regularly!
This is a great opportunity to gain some experience using these programs, taking advantage of the many tutorials available online, and adding some extra skills to your CV.
When VISRETAIN is set to 0 the changes to xref-dependent layers are valid for the current session ONLY! Turn it to 1 to have the changes save.
Taken from AutoCAD help files:
0 – The layer table, as stored in the reference drawing (xref), takes precedence. Changes made to xref-dependent layers in the current drawing are valid in the current session only and are not saved with the drawing. When the current drawing is reopened, the layer table is reloaded from the reference drawing, and the current drawing reflects all of those layer property settings.
1 – Xref-dependent layer changes made in the current drawing take precedence. Layer settings are saved with the current drawing’s layer table and persist from session to session.