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)
Start the Excel Importer add-on by selecting Add-ons > Excel add-on.
Configuration per sheet
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
The tool lets the user save file conversion configurations and reuse them later. This is done with the SAVE / LOAD CONFIG buttons.
Preview the data range of each sheet with the configured header row by pressing the EXCEL SHEET PREVIEW tab.
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.
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.
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.
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
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