sheet to json set range by columns using xlsx nodejs

0 votes

Using xlsx sheet to json, I want to know how to get values just from a given set of columns.

Read data from D to J in an excel spreadsheet using xlsx nodejs.

const XLSX = require("xlsx");

const workbook = XLSX.readFile("data.xlxs"); 
const worksheet = workbook.Sheets["data summary"]; 
       

const result= XLSX.utils.sheet_to_json(worksheet,{range: "D:J", blankrows: false });;

Sep 6, 2022 in Node-js by Vaani
• 7,070 points

edited 4 days ago 8 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP