order to increase the performance and reduce the file size, by default,
Aspose.Cells does not exp cellName to xlsx if not necessary. But Ms Excel will exp cellName to xlsx, so the file will bloat if open and saved by Ms Excel. If you need to export cellName information to xlsx, you may try the following code lines.
OoxmlSaveOptions option = new OoxmlSaveOptions(Aspose.Cells.SaveFormat.Xlsx); option.ExportCellName = true; // default value is false report.Save(“myfile.xlsx”, option);
You will see the size of file saved by Aspose.Cells is almost equal to the one saved by MS Excel.
In your current scenario, <c r=“BG10” s=“3” t=“s”> r=“BG10” is the cell name.
Sounds like there’s nothing I can do to keep Excel from automatically adding the cell name attribute to each cell node. Unfortunate, but that’s how it goes.