Native Package Manager

    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

    Install

    npm i worksheetx

    DownloadsWeekly Downloads

    42

    Version

    2.3.9

    License

    MIT

    Last publish

    Collaborators

    • mastershil