worksheetx

2.3.9 • Public • Published

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

  • lodash npm install lodash --save
  • xlsx npm install xlsx --save

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 = new WorksheetX(xlsxWorkBook.Sheets[sheetName]);

WorkSheetX functions

  • ForEachCell

    This function has one argument:

    callback: Parameters [cell, index]

worksheet.forEachCell(function (cell, index) {
// code
});
  • 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.cellFilter({name: 'yea'}); // cells with name == 'yea'

CellX

Package Sidebar

Install

npm i worksheetx

Weekly Downloads

0

Version

2.3.9

License

MIT

Last publish

Collaborators

  • mastershil