Microsoft Office: Excel

This connector is available with any role.

Note: The graphical view may have minor differences with the former editor (default icons are sometimes used, for example).

This page discusses:

See Also
About Connectors

Supported Version and Format

From Microsoft Office 97:

  • .xls
  • .xlsx

Maximum file size: 700 MB (or 1000 rows and 1000 columns)

Extracted Elements

  • Sheet
  • Row
  • Cell

Preview

The Excel content is displayed.

Functionality

You can designate a column as the one to be used as identifier for rows. This column should contain stable identifiers.

In Excel, this column must be named SMVID. For this:

  1. Select the column.
  2. From the Formulas tab, click Define Names.
  3. Type SMVID in the Name box.