2011
Table Of Contents
- Contents
- Get Information
- The User Interface
- Tools in the Application Window
- Other Tool Locations
- Customize the Drawing Environment
- Start and Save Drawings
- Control the Drawing Views
- Change Views
- Use Viewing Tools
- Display Multiple Views in Model Space
- Organize Drawings and Layouts
- Create Single-View Drawings (Model Space)
- Create Multiple-View Drawing Layouts (Paper Space)
- Work with Sheets in a Sheet Set
- Create and Modify Objects
- Control the Properties of Objects
- Work with Object Properties
- Work with Layers
- Work with Colors
- Work with Linetypes
- Control Lineweights
- Control the Display Properties of Certain Objects
- Use Precision Tools
- Use Coordinates and Coordinate Systems (UCS)
- Use Dynamic Input
- Snap to Locations on Objects (Object Snaps)
- Restrict Cursor Movement
- Combine or Offset Points and Coordinates
- Specify Distances
- Extract Geometric Information from Objects
- Use a Calculator
- Draw Geometric Objects
- Change Existing Objects
- Add Constraints to Geometry
- Control the Properties of Objects
- Define and Reference Blocks
- Work with Blocks
- Create and Modify Blocks
- Add Behaviors to Blocks (Dynamic Blocks)
- Overview of Dynamic Blocks
- Quick Start to Creating Dynamic Blocks
- Create and Edit Dynamic Blocks
- Add Constraints to Dynamic Blocks
- Add Action Parameters to Dynamic Blocks
- Work with 3D Models
- Create 3D Models
- Overview of 3D Modeling
- Create Solids and Surfaces from Lines and Curves
- Create Solids
- Create Surfaces
- Create Meshes
- Create Wireframe Models
- Add 3D Thickness to Objects
- Modify 3D Models
- Create Sections and 2D Drawings from 3D Models
- Create 3D Models
- Annotate Drawings
- Work with Annotations
- Hatches, Fills, and Wipeouts
- Notes and Labels
- Tables
- Dimensions and Tolerances
- Understand Basic Concepts of Dimensioning
- Use Dimension Styles
- Set the Scale for Dimensions
- Create Dimensions
- Modify Existing Dimensions
- Add Geometric Tolerances
- Plot and Publish Drawings
- Prepare Drawings for Plotting and Publishing
- Quick Start to Saving Settings for Plotting and Publishing
- Specify Page Setup Settings
- Overview of Page Setup Settings
- Select a Printer or Plotter for a Layout
- Select a Paper Size for a Layout
- Set the Plot Area of a Layout
- Adjust the Plot Offset of a Layout
- Set the Plot Scale for a Layout
- Set the Lineweight Scale for a Layout
- Select a Plot Style Table for a Layout
- Set Shaded Viewport and Plot Options for a Layout
- Determine the Drawing Orientation of a Layout
- Use the Layout Wizard to Specify Layout Settings
- Import PCP or PC2 Settings into a Layout
- Create and Use Named Page Setups
- Use Named Page Setups with Sheet Sets
- Plot Drawings
- Quick Start to Plotting
- Overview of Plotting
- Use a Page Setup to Specify Plot Settings
- Select a Printer or Plotter
- Specify the Area to Plot
- Set Paper Size
- Position the Drawing on the Paper
- Control How Objects Are Plotted
- Preview a Plot
- Plot Files to Other Formats
- Publish Drawings
- Prepare Drawings for Plotting and Publishing
- Share Data Between Files
- Reference Other Drawing Files
- Link and Embed Data (OLE)
- Work with Data in Other Formats
- Import Other File Formats
- Attach Files as Underlays
- Attach Raster Image Files
- Export Drawings to Other File Formats
- Use Drawings from Different Versions and Applications
- Extract Data from Drawings and Spreadsheets
- Access External Databases
- Overview of Using External Databases
- Access a Database from Within AutoCAD
- Link Database Records to Graphical Objects
- Use Labels to Display Database Information in the Drawing
- Use Queries to Filter Database Information
- Share Link and Label Templates and Queries with Other Users
- Work with Links in Files from Earlier Releases
- Manage Files with Autodesk Vault
- Collaborate with Others
- Protect and Sign Drawings
- Use the Internet for Collaboration
- Use Markups for Design Review
- Render Drawings
- Draw 2D Isometric Views
- Add Lighting to Your Model
- Materials and Textures
- Render 3D Objects for Realism
- Glossary
- Index
To specify formatting for extracted data in a column
1 Click Insert tab ➤ Linking & Extraction panel ➤ Extract Data.
2 In the Data Extraction wizard on the Refine Data page, right-click the
column label for the column that will have its data type changed. From
the shortcut menu, click Set Column Data Format.
3 In the Set Cell Format dialog box, select the data type from the Data Type
list (Angle, Currency, Data, Decimal Number, General, Percentage, Point,
Text, or Whole Number.)
4 Depending on the selected data type, specify additional options from the
right side of the dialog box.
5 Click OK.
To insert a formula column in the extracted data
1 Click Insert tab ➤ Linking & Extraction panel ➤ Extract Data.
2 In the Data Extraction wizard on the Refine Data page, right-click a
column label. Click Insert Formula Column.
3 In the Insert Formula Column dialog box, in the Column Name field,
enter a name for the formula column.
4 In the Columns list, double-click a column name that contains numerical
data. The column name displays in the Formula field.
5 Choose an operator button [ + - * / ]. The operator displays in the Formula
field.
6 Add another column from the Column Name list, or enter a numerical
value.
7 Click Validate.
8 Click OK.
1848 | Chapter 38 Extract Data from Drawings and Spreadsheets