Modify existing Excel File For Style

[wuzhongao]

Hi I try to edit my excel file.
But there are problems with editing styles.
let workbook = new excel.Workbook(); workbook.xlsx.readFile(old.xlsx).then(function () { let lineFont = worksheet.getCell(A14).font; lineFont['bold'] = true; worksheet.getCell(A14).font = lineFont; workbook.xlsx.writeFile(new.xlsx).then(function(){ }) })
As a result, in addition to modifying the specified cell, other cells are also changed.
Does anybody have the same problem?

[IgnatovDan]

In XLSX, a font description can be referenced from several cells. For more details see the 'fontId (Font Id)' description in the '18.8.45 xf (Format)' section, Ecma Office Open XML Part 1.

ExcelJS creates objects in accordance with the internal XLSX declarations and some Font object can be referenced from several cell objects. In this case, changes will be applied to all those cells.

You can review your XLSX file internals to see whether or not this is your case.

For one cell, you can create a copy of the source 'getCell().font' object and explicitly specify it as a font for your cell. In this case, the new font object will not be referenced from other cells.