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
The first time you extract data, you are prompted to save the data extraction
settings in a data extraction (DXE) file. Later, if you need to edit the data
extraction, you select the DXE file, which contains all the settings (data source,
selected objects and their properties, output format and table style) that you
used to create the extraction. For example, if you wanted to remove some
property data from the extraction, you would select the DXE file that was used
to create the extraction and made the desired changes.
A data extraction file can also be used as a template to perform the same type
of extraction in a different drawing. The DXE file stores drawing and folder
selections, object and property selections, and formatting choices. If you need
to extract the same type of information repeatedly, using a DXE file is
time-saving and convenient.
You can also edit a DXE file. You can add or remove drawings, add or remove
objects, or select different properties from which to extract data. Tables that
reference the same DXE file, even if those tables are in other drawings, display
the changes when those tables are updated.
NOTE You can use an attribute extraction (BLK) file as a template for extracting
data from blocks and attributes. When using a BLK file for extracting data or editing
an existing extraction, you are prompted to save the data extraction to a DXE file
in order to proceed with the extraction.
See also:
■ For information on identifying data extraction objects, see Highlight External
References in a Drawing in
Attach and Detach Referenced Drawings on page
1668.
To create a new data extraction table
It is recommended you save the current drawing before using the Data
Extraction wizard. If the current drawing is not saved, you are prompted to
save the drawing before proceeding with the data extraction.
1 Click Annotate tab ➤ Tables panel ➤ Extract Data.
2 On the Data Extraction wizard on the Begin page, click Create a New
Data Extraction. If you want to use a template (DXE or BLK) file, click
Use Previous Extraction as a Template. Click Next.
3 On the Save Data Extraction As dialog box, specify a file name for the
data extraction file. Click Save.
1836 | Chapter 38 Extract Data from Drawings and Spreadsheets