Importer xlsx
Version note: this reference describes Nanook 1.x (JavaScript). Since 2.0 (March 2026) Nanook is TypeScript/ESM; Processor is now TestcaseProcessor, TDGServiceRegistry is DataGeneratorRegistry. The current reference is on this site: API reference, 3.x rows, generated from the repository.
ImporterXlsx
An importer to load Excel Spreadsheets. This importer is used by the file processor. So it is possible to create importer for different kind of files.
Kind: global class
importerXlsx.sheets
{Map} Stores the sheets by there name
Kind: instance property of ImporterXlsx
importerXlsx.converter
A converter to map Excel columns to numbers. The first column starts with '0'
Kind: instance property of ImporterXlsx
importerXlsx.sheetNames ⇒ array
Returns the list with the names of the loaded sheet in the original order
Kind: instance property of ImporterXlsx
Returns: array - sheets A list of sheet names
importerXlsx.clear()
Frees some memory. Cleats the existing loaded sheets
Kind: instance method of ImporterXlsx
importerXlsx.loadFile(fileName)
Opens the Spreadsheet file and loads it.
Kind: instance method of ImporterXlsx
| Param | Type | Description |
|---|---|---|
| fileName | string |
The file to open |
importerXlsx.cellValue(sheetName, column, row) ⇒ string
Returns the Cell value from a given sheet
Kind: instance method of ImporterXlsx
Returns: string - value The Cell value
| Param | Type | Description |
|---|---|---|
| sheetName | string |
The name of the sheet |
| column | number |
The column number start with '0' |
| row | number |
The row number start with '0' |