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, 2025 992 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