exceljs / exceljs/exceljs

excel formula Problem While creating a copy of an excel sheet

Open
#2,657 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
JavaScript
Stars
15.5k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

i am using the library excel js

const downloadExcel = async () => {
try {
const response = await fetch(`${process.env.PUBLIC_URL}/veccalc.xlsx`);
// const arrayBuffer = await response.arrayBuffer();
const blob1 = await response.blob();
const originalWorkbook = new ExcelJS.Workbook();
console.log("arun")
await originalWorkbook.xlsx.load(blob1);
console.log("arun1")
const copiedWorkbook = new ExcelJS.Workbook();

originalWorkbook.eachSheet((originalSheet) => {
const newSheet = copiedWorkbook.addWorksheet(originalSheet.name);
newSheet.model = Object.assign({}, originalSheet.model);;
// newSheet.model = Object.assign({}, originalSheet.model);
});

const sheetName = "INPUT_FERM";
const sheet = copiedWorkbook.getWorksheet(sheetName);

let rowNumber = 18;
while (sheet.getRow(rowNumber).getCell("A").value) {
const lowercase = sheet.getRow(rowNumber).getCell("A").value.toLowerCase();
const value = responseData[lowercase];
sheet.getRow(rowNumber).getCell("B").value = value;
rowNumber++;
}
console.log("arun3")
copiedWorkbook.eachSheet((ws) => {
ws.recalculate = true;
});
console.log("arun2")

const buffer = await copiedWorkbook.xlsx.writeBuffer();
const blob = new Blob([buffer], { type: "application/octet-stream" });

hiddenLinkRef.current.href = URL.createObjectURL(blob);
hiddenLinkRef.current.click();
} catch (error) {
console.error(error);
}
};

this is my cod what i am trying to do here is create a copy of my original workbook then in the copiedworkbook i will do some update on one of the sheet based this update my copied excel sheet should calculate some values

but the issue i am presisting is whenever i try to open my copiedexceksheet after downloading

it gives me following error

Repaired Records: Cell information from /xl/worksheets/sheet1.xml part
Repaired Records: Cell information from /xl/worksheets/sheet6.xml part

=@INPUT_MP_SUM/@INPUT_DAYS_YEAR(this is the formula in my downloaded excel sheet )
=INPUT_MP_SUM/INPUT_DAYS_YEAR(this is the formula in older one)

plzz help me in this

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.