Microsoft Office: Excel

This connector is available with any role (including Systems Traceability Dashboarding).

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

Traceability Links

There is no link to be extracted. Patterns can be used. For more information, see Working with Patterns.

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.