Search code examples
node.jsjsonxlsx

How to print only last column for xlsx sheet using Node.js


const reader = require('xlsx')

const file = reader.readFile('./Excel Template 3.xlsx')

const sheets = file.SheetNames
console.log(sheets.length)
for(let i = 0; i < sheets.length; i++)
{
 
var data = reader.utils.sheet_to_json(
        file.Sheets[file.SheetNames[i]])
  

}
console.log(data)
delete data.Numbers
console.log(data)

I printed the excel sheet using node.js but I want always to delete last column.


Solution

  • for (i=0; i<data.length;i++){
      for(y=0; y<data.length;y++){
        console.log(y)
        delete data[y].Numbers
        
      }
    }
    
    
    console.log(data)