Import EXCEL
Instructions for use
The Import EXCEL tool supports importing Microsoft Excel files (*.xlsx) as attribute tables. It also supports setting spatial fields for longitude, latitude, and elevation values to import them as spatial data, improving data entry efficiency.
Parameter description
| Parameter Name | Parameter Description | Parameter Type |
|---|---|---|
| Select File | Enter the path information of the data to be imported. | String |
| Charset | Select the character set type for the file to be imported. Default is ASCII. | Charset |
| Result Datasource | Specify the datasource where the result dataset is stored. | Datasource |
| Result Dataset | The name of the specified result dataset. | String |
| Table Name | Set the worksheet to import. If an EXCEL table contains multiple sheets, select one to import via this dropdown option. | String |
| 1st Row as Header | Set whether the first row of the source file is the field name. Default is checked, meaning the imported field names are the values from the first row of the source file. If unchecked, the imported field names are: col0, col1, col2, ..., colN-1. | Boolean |
| Import Spatial Data | Set whether to import data as a spatial dataset or attribute data. Specify fields for X, Y, or X, Y, Z coordinates. If conditions are met, it generates point or 3D point datasets. | String |
Output Result
| Parameter Name | Parameter Description | Parameter Type |
|---|---|---|
| Result Dataset | Result dataset | DatasetVector |