Excel with .xlsm

Aspose.Cells Product Family
1

Team, I have a .xlsm excel file which has macro enabled in it, which has been stored as template in Azure blob container.
We download the template from azure blob using C#, load it in aspose update 2 sheets with data and again push it to blob
Then we download.
But if we save as .xlsx the macros is gone, or if we save as .xlsm file it saves in protected format which the formulas are not updated.

How doe aspose.cells helps in reading, updating and then download .xlsm file ?

2

@neemlal,

Could you please call Workbook.CalculateFormula() method before saving to XSLM file format if it makes any difference.

If you still find any issue, kindly provide a sample project with sample Excel file(s) to reproduce the issue on our end, we will check it soon.

PS. please zip the project and resource files prior attaching.