Posted 11 August 2021, 1:57 pm EST - Updated 30 September 2022, 2:38 pm EST
SaveExcel: File corrupted
Posted by: mehar.rehill on 11 August 2021, 1:57 pm EST
-
-
Posted 12 August 2021, 1:46 am EST
Hi,
Spread Windows Forms has very limited support for XLSM. The XLSM support is limited to importing the macro content (including all unsupported content in the workbook like pivot tables, VBA content, macros, etc.) and caching it in memory for later exporting to XLSM (possibly with some changes that you have made using the Spread API). Spread cannot return any of the macro content from the API.
You need to use the DocumentCaching ExcelOpenFlags and ExcelSaveFlags for macros to be preserved while opening and saving Excel.
Please make sure you used it while opening and saving the file and if the issue still persists, please share the excel file so that we can investigate it further at our end.Regards,
Avnish