2012
Table Of Contents
- Contents
- Commands
- 3D Commands
- A Commands
- B Commands
- C Commands
- CAL
- Understand Syntax of Expressions
- Format Feet and Inches
- Format Angles
- Use Points and Vectors
- Use System Variables in Calculations
- Convert Units of Measurement
- Use Standard Numeric Functions
- Calculate a Vector from Two Points
- Calculate the Length of a Vector
- Obtain a Point by Cursor
- Obtain the Last-Specified Point
- Use Snap Modes in Arithmetic Expressions
- Convert Points Between UCS and WCS
- Calculate a Point on a Line
- Rotate a Point About an Axis
- Obtain an Intersection Point
- Calculate a Distance
- Obtain a Radius
- Obtain an Angle
- Calculate a Normal Vector
- Use Shortcut Functions
- CHAMFER
- CHANGE
- CHPROP
- CHSPACE
- CIRCLE
- CLASSICIMAGE
- CLASSICLAYER
- CLASSICXREF
- CLEANSCREENON
- CLEANSCREENOFF
- CLIP
- CLOSE
- CLOSEALL
- COLOR
- COMMANDLINE
- COMMANDLINEHIDE
- CONSTRAINTBAR
- CONSTRAINTSETTINGS
- CONTENTEXPLORER
- CONTENTEXPLORERCLOSE
- CONVERT
- CONVERTCTB
- CONVERTPSTYLES
- COPY
- COPYBASE
- COPYCLIP
- COPYHIST
- COPYLINK
- COPYTOLAYER
- CUI
- CUIEXPORT
- CUIIMPORT
- CUILOAD
- CUIUNLOAD
- CUSTOMIZE
- CUTCLIP
- CAL
- D Commands
- DATALINK
- DATALINKUPDATE
- DCDISPLAY
- DDEDIT
- DDPTYPE
- DDVPOINT
- DELAY
- DELCONSTRAINT
- DETACHURL
- DGNADJUST
- DGNATTACH
- DGNBIND (-DGNBIND)
- DGNCLIP
- DGNEXPORT
- DGNIMPORT
- DGNLAYERS
- DGNMAPPING
- DIM and DIM1
- DIMALIGNED
- DIMANGULAR
- DIMARC
- DIMBASELINE
- DIMBREAK
- DIMCENTER
- DIMCONTINUE
- DIMDIAMETER
- DIMDISASSOCIATE
- DIMEDIT
- DIMINSPECT
- DIMJOGGED
- DIMJOGLINE
- DIMLINEAR
- DIMORDINATE
- DIMOVERRIDE
- DIMRADIUS
- DIMREASSOCIATE
- DIMREGEN
- DIMROTATED
- DIMSPACE
- DIMSTYLE
- DIMTEDIT
- DIST
- DIVIDE
- DLINE
- DONUT
- DOWNLOADMANAGER
- DRAGMODE
- DRAWINGRECOVERY
- DRAWINGRECOVERYHIDE
- DRAWORDER
- DSETTINGS
- DWFADJUST
- DWFATTACH
- DWFCLIP
- DWFFORMAT
- DWFLAYERS
- DWGCONVERT
- DWGPROPS
- E Commands
- F Commands
- G Commands
- H Commands
- I Commands
- J Commands
- L Commands
- M Commands
- N Commands
- O Commands
- OBJECTSCALE
- OFFSET
- OLELINKS
- OLESCALE
- ONLINEDRAWINGS
- OOPS
- OPEN
- OPENDWFMARKUP
- OPENONLINE
- OPENSHEETSET
- OPTIONS
- Options Dialog Box
- Alternate Font Dialog Box
- Drawing Window Colors Dialog Box
- Command Line Window Font Dialog Box
- Thumbnail Preview Settings Dialog Box
- Plot Style Table Settings Dialog Box
- Right-Click Customization Dialog Box
- Field Update Settings Dialog Box
- Visual Effect Settings Dialog Box
- Ribbon Contextual Tab State Options Dialog Box
- Advanced Preview Options Dialog Box
- Transparency Dialog Box
- Hidden Message Settings Dialog Box
- InfoCenter Settings Dialog Box
- Default Scale List Dialog Box
- ORTHO
- OSNAP
- OVERKILL
- P Commands
- Q Commands
- R Commands
- S Commands
- SAVE
- SAVEAS
- SCALE
- SCALELISTEDIT
- SCALETEXT
- SCRIPT
- SECURITYOPTIONS
- SEEK
- SELECT
- SELECTSIMILAR
- SETBYLAYER
- SETENV
- SETVAR
- SHADE
- SHADEMODE
- SHARE
- SHAREWITHSEEK
- SHEETSET
- Sheet Set Manager
- Subset Properties Dialog Box
- Publish Sheets Dialog Box
- Select Layout as Sheet Template Dialog Box
- New Sheet Dialog Box
- Rename & Renumber Sheet Dialog Box
- Rename & Renumber View Dialog Box
- Import Layouts as Sheets Dialog Box
- Insert Sheet List Table Dialog Box
- Edit Sheet List Table Settings Dialog Box
- Sheet Set Properties Dialog Box
- Sheet Set Custom Properties Dialog Box
- Add Custom Property Dialog Box
- Resource Drawing Locations Dialog Box
- Sheet Properties Dialog Box
- New Sheet Selection Dialog Box
- Sheet Selections Dialog Box
- View Category Dialog Box
- List of Blocks Dialog Box
- Select Block Dialog Box
- SHEETSETHIDE
- SHOWPALETTES
- SIGVALIDATE
- SKETCH
- SNAP
- SOLID
- SPACETRANS
- SPELL
- SPLINE
- SPLINEDIT
- STRETCH
- STYLE
- STYLESMANAGER
- SUBTRACT
- SYSWINDOWS
- T Commands
- U Commands
- V Commands
- W Commands
- X Commands
- Z Commands
- Command Modifiers
- System Variables
- 3D System Variables
- A System Variables
- B System Variables
- C System Variables
- CALCINPUT
- CANNOSCALE
- CANNOSCALEVALUE
- CBARTRANSPARENCY
- CDATE
- CECOLOR
- CELTSCALE
- CELTYPE
- CELWEIGHT
- CENTERMT
- CETRANSPARENCY
- CHAMFERA
- CHAMFERB
- CHAMFERC
- CHAMFERD
- CHAMMODE
- CIRCLERAD
- CLASSICKEYS
- CLAYER
- CLEANSCREENSTATE
- CLISTATE
- CLIPBOARD
- CMDACTIVE
- CMDDIA
- CMDINPUTHISTORYMAX
- CMDNAMES
- CMLEADERSTYLE
- CONSTRAINTBARMODE
- CONSTRAINTNAMEFORMAT
- CONSTRAINTRELAX
- CONSTRAINTSOLVEMODE
- CONTENTEXPLORERSTATE
- COORDS
- COPYMODE
- CPLOTSTYLE
- CROSSINGAREACOLOR
- CTAB
- CTABLESTYLE
- CURSORSIZE
- CVPORT
- D System Variables
- DATALINKNOTIFY
- DATE
- DBLCLKEDIT
- DBMOD
- DCTCUST
- DCTMAIN
- DEFLPLSTYLE
- DEFPLSTYLE
- DELOBJ
- DGNFRAME
- DGNIMPORTMAX
- DGNIMPORTMODE
- DGNMAPPINGPATH
- DGNOSNAP
- DIASTAT
- DIGITIZER
- DIMADEC
- DIMALT
- DIMALTD
- DIMALTF
- DIMALTRND
- DIMALTTD
- DIMALTTZ
- DIMALTU
- DIMALTZ
- DIMANNO
- DIMAPOST
- DIMARCSYM
- DIMASSOC
- DIMASZ
- DIMATFIT
- DIMAUNIT
- DIMAZIN
- DIMBLK
- DIMBLK1
- DIMBLK2
- DIMCEN
- DIMCLRD
- DIMCLRE
- DIMCLRT
- DIMCONSTRAINTICON
- DIMDEC
- DIMDLE
- DIMDLI
- DIMDSEP
- DIMEXE
- DIMEXO
- DIMFRAC
- DIMFXL
- DIMFXLON
- DIMGAP
- DIMJOGANG
- DIMJUST
- DIMLDRBLK
- DIMLFAC
- DIMLIM
- DIMLTEX1
- DIMLTEX2
- DIMLTYPE
- DIMLUNIT
- DIMLWD
- DIMLWE
- DIMPOST
- DIMRND
- DIMSAH
- DIMSCALE
- DIMSD1
- DIMSD2
- DIMSE1
- DIMSE2
- DIMSOXD
- DIMSTYLE
- DIMTAD
- DIMTDEC
- DIMTFAC
- DIMTFILL
- DIMTFILLCLR
- DIMTIH
- DIMTIX
- DIMTM
- DIMTMOVE
- DIMTOFL
- DIMTOH
- DIMTOL
- DIMTOLJ
- DIMTP
- DIMTSZ
- DIMTVP
- DIMTXSTY
- DIMTXT
- DIMTXTDIRECTION
- DIMTZIN
- DIMUPT
- DIMZIN
- DISPSILH
- DISTANCE
- DONUTID
- DONUTOD
- DRAGMODE
- DRAGP1
- DRAGP2
- DRAWORDERCTL
- DRSTATE
- DTEXTED
- DWFFRAME
- DWFOSNAP
- DWGCHECK
- DWGCODEPAGE
- DWGNAME
- DWGPREFIX
- DWGTITLED
- DYNCONSTRAINTMODE
- DYNDIGRIP
- DYNDIVIS
- DYNINFOTIPS
- DYNMODE
- DYNPICOORDS
- DYNPIFORMAT
- DYNPIVIS
- DYNPROMPT
- DYNTOOLTIPS
- E System Variables
- F System Variables
- G System Variables
- H System Variables
- HALOGAP
- HANDLES
- HELPPREFIX
- HIDEPRECISION
- HIDETEXT
- HIGHLIGHT
- HPANG
- HPANNOTATIVE
- HPASSOC
- HPBACKGROUNDCOLOR
- HPBOUND
- HPBOUNDRETAIN
- HPCOLOR
- HPDLGMODE
- HPDOUBLE
- HPDRAWORDER
- HPGAPTOL
- HPINHERIT
- HPISLANDDETECTION
- HPISLANDDETECTIONMODE
- HPLAYER
- HPMAXAREAS
- HPMAXLINES
- HPNAME
- HPOBJWARNING
- HPORIGIN
- HPORIGINMODE
- HPQUICKPREVIEW
- HPQUICKPREVTIMEOUT
- HPSCALE
- HPSEPARATE
- HPSPACE
- HPTRANSPARENCY
- HYPERLINKBASE
- I System Variables
- L System Variables
- M System Variables
- N System Variables
- O System Variables
- P System Variables
- PALETTEOPAQUE
- PAPERUPDATE
- PDFFRAME
- PDFOSNAP
- PDMODE
- PDSIZE
- PEDITACCEPT
- PELLIPSE
- PERIMETER
- PERSPECTIVE
- PERSPECTIVECLIP
- PICKADD
- PICKAUTO
- PICKBOX
- PICKDRAG
- PICKFIRST
- PICKSTYLE
- PLATFORM
- PLINECONVERTMODE
- PLINEGEN
- PLINETYPE
- PLINEWID
- PLOTOFFSET
- PLOTROTMODE
- PLOTTRANSPARENCYOVERRIDE
- POINTCLOUDDENSITY
- POLARADDANG
- POLARANG
- POLARDIST
- POLARMODE
- POLYSIDES
- PREVIEWEFFECT
- PREVIEWFACEEFFECT
- PREVIEWFILTER
- PROJMODE
- PROPOBJLIMIT
- PROXYGRAPHICS
- PROXYNOTICE
- PROXYSHOW
- PROXYWEBSEARCH
- PSLTSCALE
- PSTYLEMODE
- PSTYLEPOLICY
- PUBLISHALLSHEETS
- PUBLISHCOLLATE
- PUBLISHHATCH
- PUCSBASE
- Q System Variables
- R System Variables
- S System Variables
- SAVEFIDELITY
- SAVEFILE
- SAVEFILEPATH
- SAVENAME
- SAVETIME
- SCREENSIZE
- SELECTIONANNODISPLAY
- SELECTIONAREA
- SELECTIONAREAOPACITY
- SELECTIONCYCLING
- SELECTIONPREVIEW
- SELECTSIMILARMODE
- SETBYLAYERMODE
- SHADEDGE
- SHADEDIF
- SHORTCUTMENU
- SHORTCUTMENUDURATION
- SHOWLAYERUSAGE
- SHOWPAGESETUPFORNEWLAYOUTS
- SIGWARN
- SKETCHINC
- SKPOLY
- SKTOLERANCE
- SNAPANG
- SNAPBASE
- SNAPISOPAIR
- SNAPMODE
- SNAPSTYL
- SNAPTYPE
- SNAPUNIT
- SORTENTS
- SPLDEGREE
- SPLFRAME
- SPLINESEGS
- SPLINETYPE
- SPLKNOTS
- SPLMETHOD
- SPLPERIODIC
- SSFOUND
- SSLOCATE
- SSMAUTOOPEN
- SSMPOLLTIME
- SSMSHEETSTATUS
- SSMSTATE
- STARTUP
- STATUSBAR
- SYSCODEPAGE
- T System Variables
- TABLEINDICATOR
- TABLETOOLBAR
- TABMODE
- TARGET
- TBSHOWSHORTCUTS
- TDCREATE
- TDINDWG
- TDUCREATE
- TDUPDATE
- TDUSRTIMER
- TDUUPDATE
- TEMPOVERRIDES
- TEXTED
- TEXTFILL
- TEXTOUTPUTFILEFORMAT
- TEXTQLTY
- TEXTSIZE
- TEXTSTYLE
- THICKNESS
- TILEMODE
- TIMEZONE
- TOOLTIPMERGE
- TOOLTIPS
- TOOLTIPSIZE
- TOOLTIPTRANSPARENCY
- TPSTATE
- TRACEWID
- TRACKPATH
- TRANSPARENCYDISPLAY
- TRAYICONS
- TRAYNOTIFY
- TRAYTIMEOUT
- TREEDEPTH
- TREEMAX
- TRIMMODE
- TSPACEFAC
- TSPACETYPE
- TSTACKALIGN
- TSTACKSIZE
- U System Variables
- V System Variables
- W System Variables
- X System Variables
- Z System Variables
- Utilities
- Index
D Commands
DATALINK
Quick Reference
See also:
■ Link a Table to External Data
Displays the Data Link dialog box.
Access Methods
Button
Ribbon: Insert tab ➤ Linking & Extraction panel ➤ Data Link
Menu: Tools ➤ Data Links ➤ Data Link Manager
Summary
A table can be linked to data in a Microsoft Excel (XLS, XLSX, or CSV) file. You
can link to an entire spreadsheet, individual row, column, cell, or cell range in
Excel.
The
Data Link Manager on page 266 is displayed.
5
265