how can i read data from specific row and column to specific row and column from excel sheet to json format in nodejs

Vote count: 0

I am using xlsx package. Please suggest any other package if available

I tried this but i am getting complete data

var sheet, jsonData,
    excelString = new Buffer(base64, 'base64').toString('binary'),
    workbook = excelParser.read(excelString, {type: 'binary'});

    if (workbook.Sheets['Sheet1']) {
      sheet = workbook.Sheets['Sheet1'];
      workbook.Sheets['Sheet1'] = sheet;
      jsonData = excelParser.utils.sheet_to_json(workbook.Sheets['Sheet1'], {});

asked 33 secs ago

Manish Kumawat

Let's block ads! (Why?)

how can i read data from specific row and column to specific row and column from excel sheet to json format in nodejs