I want evaluate excel formula in node js how to do this

0 votes
I have excel in this excel multiple sheets available but I want read only one sheet from this excel. also i want read data from other sheets but same sheet in using formula please help me.

example

sheet1 , sheet2 , sheet3 ,sheet4 etc.

I want to read sheet2 and also suppose sheet1 data read in same sheet using formula

formula is like =sheet1!J10 means i want read sheet1 J10 value but i tried to read value using below code but not getting.

const Excel = require('exceljs');

const workbook = new Excel.Workbook();

        workbook.xlsx.readFile(req.files[0].path).then(() => {

            var worksheet = workbook.getWorksheet("sheet2");

            worksheet.getCell('C' + 100).formula = '=sheet1!J10';

            console.log("getValue", worksheet.getCell('C'+ 100).value);

        });
Sep 1, 2022 in Ask us Anything! by vishal

edited Mar 4 27 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