excel formula Problem While creating a copy of an excel sheet
- 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.