WorkSheetX
This project is an extension for xlsx, it has to clases WorksheetX and CellX
- WorksheetX lets you work with the worksheet as a container of CellX.
- CellX has some methods to query through the cells from the worksheet.
Dependencies
Creating a WorkSheetX
- To create a WorksheetX First we need to have the xlsx workbook, then get one of the sheet from that workbook, then we can pass as parameter to the constructor
var sheetName = 0; var worksheet = xlsxWorkBookSheetssheetName;
WorkSheetX functions
-
ForEachCell
This function has one argument:
callback: Parameters [cell, index]
worksheet;
-
cellFilter
This function makes a filter to the cells based on the lodash filter function, and returns the filtered cells.
This function has one argument:
filter: most be a valid lodash filter
worksheet; // cells with name == 'yea'