Ready to watch this entire course?
Become a member and get unlimited access to the entire skills library of over 4,900 courses, including more video2brain and personalized recommendations.Start Your Free Trial Now
- View Offline
- Why data management is important in AutoCAD
- Designing attributes and storing attribute data
- Using fields to display object properties
- Extracting data from AutoCAD send to Microsoft Excel
- Creating tables
- Formatting table cells and styles
- Editing table cells and using formulas
Skill Level Intermediate
In this lesson, you will create a table displaying some of the current drawings attribute data without having to go through the intermediary of Microsoft Excel. Instead, we will begin by creating a table directly in AutoCAD. Open the Office 11 project file. And then, on the Home tab, in the Annotation panel, click the Table tool. (audio playing) Select this third radio button in the Insert options area from object data in the drawing. This will launch the data extraction wizard.
Click OK. (audio playing) And then create a new data extraction. Click Next. (audio playing) You're prompted to save a filename, let's call this (audio playing) furniture 2. Click Save. And then use the default option here which is to use the current drawing or sheet set as the data source. Click Next. (audio playing) Here you have a list of all of the object types in the drawing from which you can extract data.
Right-click and choose Uncheck All (audio playing) and then select armchair, chair, and desk. Click Next. This is a list of all of the properties that could be extracted from the selected objects. Deselect (audio playing) all the categories except for attribute. (audio playing) Here is a list of these tag names of these attributes. Click Next. (audio playing) And this is a preview of the actual table.
Let's sort the list by name, by clicking on the name header. (audio playing) Then click Next. (audio playing) Check the first option, Insert Data Extraction table into drawing and make sure the second option in unchecked. Click next. Here we have an opportunity to configure the table style. Make sure that this option is selected. If it's not (audio playing) you won't have header cells. (audio playing) Click Next (audio playing) and click Finish.
(audio playing) Click a point to insert the table over here somewhere. (audio playing) It's very small by default. Zoom in. (audio playing) Now we need to scale the table up according to the scale at which we intend to depict this drawing. The annotation scale tells us that this drawing is meant to be displayed at half inch scale. That is half inch in the drawing equals 1 foot in the real world. Another way of thinking of this is that 1 inch in the drawing equals 2 feet in the real world.
Or 1 inch in the drawing equals 24 inches in the real world. In other words, we're taking 1 inch here and we're scaling it up 24 times, in the real world. So what we need to do is scale this table up by a factor of 24. Click Scale, (audio playing) select the table, Enter. Select this endpoint up here and type 24, Enter. Then zoom out. And you'll see that the size of the lettering more or less matches the size of the text in these room tags.
It's different than the spreadsheet here that was linked to an Excel spreadsheet. The text type in this table is controlled by the table style. And you can see that here by opening the annotations slide out and clicking the Table Style tool. (audio playing) You can then configure this by going into Modify and Adjusting the text type here and the text style. You could change the text type and text style here for the different sales styles, data, header, (audio playing) and title.
(audio playing) But I'm satisfied with the standard table style so I'm going to cancel out and close. (audio playing) So in this lesson, you learned how to extract attribute data from AutoCAD's drawing database and you fed this data into a table within the same drawing.