Import EXCEL
Instructions for use
The Import EXCEL tool supports importing Microsoft Excel (*.xlsx) files as attribute tables, and also supports setting spatial fields corresponding to longitude, latitude, and elevation values to import spatial data, improving data entry efficiency.
Parameter description
| Parameter Name | Parameter Interpretation | Parameter Type |
|---|---|---|
| select file | Enter the data path information to be imported. | String |
| Character Set | Select the character set type of the file to be imported, default is ASCII. | Charset |
| result datasource | Specify the datasource where the result dataset is stored. | Datasource |
| result dataset | Specify the resulting dataset name. | String |
| Group | Supports importing data into a specified group; if no group is selected, data is imported under the datasource. | String |
| Table Name | Set the worksheet to import. If an Excel file contains multiple sheets, select one to import through this dropdown. | String |
| 1st row as header | Set whether the first row of the source file is a field. By default, it is checked, meaning the imported fields are the values from the first row of the source file; if unchecked, the imported fields are: col0, col1, col2, ..., colN-1. | Boolean |
| import spatial data | Used to set whether to import data as spatial data or attribute data. Specify fields for X, Y, or X, Y, Z coordinates respectively; if conditions are met, a point or 3D point dataset is generated. | String |
Output Result
| Parameter Name | Parameter Interpretation | Parameter Type |
|---|---|---|
| result dataset | Result dataset | DatasetVector |