Excel importer add-on

ReqEdit Online Documentation

Excel importer add-on

2 min read
last updated: 08/24/2021

Convert a single MS Excel file with XLSX extension to a ReqIF Archive file (.xlsx to .reqifz)

Usage

Start the Excel Importer add-on by selecting Add-ons > Excel add-on.

ReqEdit Excel importer add-on

Configuration per sheet

Sheet selection
display the specific sheet to configure, check Ignore Sheet to skip conversion

Set header row
select a header row that represent the attributes

Set import data range
start and end of converted data, this will be the attribute values

Configure Attributes (center)

Columns can be ignored from conversion with checkbox (Ignore columns). Tool will try to guess the data types automatically

  • Boolean – true/false type values
  • Integer – whole numbers
  • Real – decimal numbers
  • Date – date format
  • String – single line text, no formatting
  • Text – multi line text with formatting
  • Enumeration – values can be one or more of a fixed set of values in all the rows in a sheet. Single value if no separator is found. Multi value if separator is found [ , ; newline ]. The conversion will combine all values found in all the rows within a single sheet so it can be memory intensive if overused

Note: if the conversion is taking long. Please use Integer instead of Real and String instead of Text types

Configuration reuse

The tool lets the user save file conversion configurations and reuse them later. This is done with the SAVE / LOAD CONFIG buttons.

Preview

Preview the data range of each sheet with the configured header row by pressing the EXCEL SHEET PREVIEW tab.

Best practice

Use the preview to check import settings periodically, the list can be adjusted to show the start or the end of the range and also the number of the preview rows.

ReqEdit Excel add-on preview tab

Importing Excel to ReqIF

After the excel file is configured press IMPORT to start the conversion.

The tool will generate a reqifz file near the source xlsx file. All actions are logged.

Output files

Each conversion will overwrite any previous REQIFZ files in the original directory

All generated output is REQIFZ archive format and will be saved near the original document.

Logging

All conversions are logged into the application directory /logs folder. The log files are splitted into 10mb files and rotated when needed.

The logging uses the log4net library. Experienced users can configure the file log4net.config to suit the logging needs. Documentation log4net: https://logging.apache.org/log4net/release/manual/introduction.html

Limitations

Only the XLSX format is supported

Additional content will be discarded (images, charts or any other floating elements)

Marcos are not processed

Merged cells will be converted to the first cell the merge starts horizontally or vertically