You can import point data from Excel into an industry model . Import from complete Excel files or from selected columns.
|
Excel Import |
Description |
|---|---|
|
Excel Import (Direct) |
Imports data from Excel files. |
|
Excel Update (Direct) |
Updates feature data from Excel files. The new values are loaded from the Excel file. Mark key columns with the # character. All fields used for search (search condition WHERE) must be preceded with the # sign. If the Excel file contains a # field, AutoCAD Map 3D toolset performs an update instead of an import. |
For point feature classes, you can import or update point geometry data. Use GEOM.X and GEOM.Y as column names in your Excel sheet.
If you import years with a two-digit format, the two missing numbers are added as follows: For numbers between 0 and 50, the year is saved as 20xx. For numbers greater than 50, the year is saved as 19xx. For example, 50 becomes 2050; 49 becomes 2049; 51 becomes 1951.
If no cell range is selected, or if just one cell is selected, the cells are selected from cell A1 to the last cell found. Normally, you do not need to select any cells.
You can also update industry model data using Excel.
The example shows how to update the feature class TREE. The attribute TREE_NAME is updated for all records whose FIDs are listed in the Excel file.
#FID TREE_NAME
1 oak
2 pine
Excel import will process the following commands:
Update TREE set TREE_NAME='oak' where ID=1; Update TREE set TREE_NAME='pine' where ID=2;
The example shows how to update the feature class TREE. The attribute CATEGORY will be updated with a more detailed value depending on the TYPE. The example assumes that TYPE = 1 = oak and TYPE = 2 = pine.
#CATEGORY #TYPE CATEGORY
tree 1 deciduous tree
tree 2 conifer
Excel import will process the following commands:
Update TREE set CATEGORY='deciduous tree' where CATEGORY='tree' and TYPE=1; Update TREE set CATEGORY='conifer' where CATEGORY ='tree' and TYPE=2;