Importer xlsx
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' |