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
On the Refine Data page, you access the Link External Data dialog box; you
can set up a link to an entire Excel spreadsheet, or to a range of rows and
columns, to the extracted data.
Before you can link a spreadsheet, Microsoft Excel needs to be installed on
the same computer on which the data extraction is performed. If Microsoft
Excel is not installed, or if the XLS file is not saved locally on the computer
that is performing the data extraction, a data link cannot be established.
If a linked spreadsheet has been changed, such as a row or column has been
added, the table in your drawing can be updated accordingly using the
DATALINKUPDATE command. Likewise, if a change is made to the table in
the drawing, the linked spreadsheet can be updated using the same command.
NOTE To delete a data link, use the DATALINK command. You cannot delete a
data link from the External References Palette.
Understand Data Linking and Matching
Data linking is the process of selecting a Microsoft Excel spreadsheet with the
purpose of merging all or some of its contents with extracted drawing data.
See
Link a Table to External Data on page 1401 for more information about data
linking.
Data matching creates a relationship between two sets of data; the data in a
column from the extracted drawing data and the data in a column from an
Excel spreadsheet.
For example, you have a simple bill of materials (BOM). Three columns of
data are extracted from a drawing. These columns contain data for: Part #,
Revision, and Quantity. You want to include two additional columns of data in
the BOM from a spreadsheet. These columns contain data for Cost and Supplier.
In this example, the spreadsheet contains a column of part numbers labeled
Catalog Number that matches the Part Number column in the extracted data.
In the Link External Data dialog box, you select Part # as the column for the
drawing data and Catalog Number as the column for the external data. Because
there is at least one cell of matching data in the drawing data column and the
external data column, the data extraction feature “knows” how both sources
are tied together.
You can test if the data matching is valid by clicking the Check Match button
from the Link External Data dialog box. If the match is unsuccessful, a warning
message indicates what the problem is. In some situations, the drawing data
might not link correctly to the data in the spreadsheet. See Data Matching
Validation for more information.
1852 | Chapter 38 Extract Data from Drawings and Spreadsheets