Details on Excel Import


  1. Select File > Open....

  2. Browse to a Microsoft Excel file and click Open.

load_excel_import_d.png

Option

Description

Worksheet

Select the worksheet containing the data you wish to import.

Note: If you cannot see all worksheets available in the file, try saving and closing the file in Excel before you open it in Spotfire.

Refresh

Updates the Data preview field to reflect any changes made to the settings.

Ignore empty rows

Select the check box to skip empty rows during import.

Data preview

Shows how the file will be interpreted, given the specified settings.

     Name

Double-click on a column name to edit the name.

     Type

Change the type for a column by clicking on the arrow and selecting the new type from the drop-down menu. The available data types are: String, Integer, Real, Currency, Date, Time, DateTime, TimeSpan, LongInteger, SingleReal and Boolean. If an inapplicable data type is selected, the data in the preview will be displayed in italics once you have clicked on the Refresh button.

     Included

Clear the check box to ignore a specific column upon import.

 

The drop-down list available on each row contains the following options:

Option

Description

Name row

Select this option on the row or rows that will be used to specify the column names in the imported data.

Type row

Select this option on the row that will be used to specify the data types.

Data row

Select this option for all data rows that you wish to import.

Ignore

Select this option for rows that should be ignored during import.

See also:

Opening an Excel File