Import Excel data

Function Description

In Data Collection, the Spatial Info of geographic data is often saved to an Excel file to improve the utilization of existing data. provided, and the specified spatial field Import Spatial Data is also supported.

The following issues should be noted in the specific file format:

  • The imported Microsoft Excel File format only supports Office 2007 and above versions, namely *.xlsx format files.
  • When importing Microsoft Excel, all sheets with data are imported by default, and sheets without data are ignored.
  • When there are merged cells, only the first cell in the range of merged cells has data.

Function entrance

  • Start tab-> Data Processing-> Data Import.
  • In Workspace Manager-> Datasource Context Menu-> Import Dataset...
  • Toolbox-> Data Import-> Spread sheet-> Import EXCEL.

Operating instructions

  • Import Excel
    1. On the toolbar of the Data Import dialog, click the Add File button to add a *.xlsx format file to be imported. See Introduction to Import Data .
      2. Target Datasource, Result Dataset, Encode Type, Import Mode, and Parameter Description of Source File Info: in
    2. Result Data. See the Data Import Public Parameter description page.
    3. Transformation Parameters
      • 1st Row as Header: Set whether the first row of the source Excel file to be imported is Field. If this parameter is checked, the imported Field is the field value in the first row, otherwise, it is Attributes. If Select Fields is specified in the first line of the Excel file, Application automatically reads it.
    4. Import Spatial Data
      • Coordinate Field: Specify Spatial Info corresponding to Excel data by setting longitude, latitude and Elevation Field.
    5. Properties: Click Properties … Button to view the Attributes of the Excel file.
      6. After
    6. setting, click the Import button to import the Excel file. The Import Spa tial Data results are shown in the following figure:
      Excel Import Spa tial Data result
  • Open Excel File directly

    Support direct opening of Excel File for read-only viewing in the form of property sheet. The specific operation mode is as follows:

    In Workspace Manager, right click the Datasource node, select the Open File Datasource.. Item, and select the Excel file to browse in the displayed dialog box. Click the Open button to bring up the Excel Browse Parameter Settings dialog. Browsing Excel supports browsing the first 1000 records and View All Data. If 1st Row as Header is checked, the first row of the Excel table can be set as the attribute table Field. After clicking OK, the Excel File will be converted to Tabular Dataset. Double-click to open it for browsing.

    Caution:
    • If the *.xlsx file name begins with a number and the name of the source file is used at Result Dataset, the name of the Tabular Dataset after successful import is: Dataset _ + *.xlsx file name.

Related topics

Import Data

Import Shape data

Import CAD data

Import CSV data

Data Formats Supported by Type Conversion