I - by accident - saved an XLSB file in XLSX file format. When I try to open from either Excel or Aspose.Cells it says it can’t open it because it contains Macro enabled content.
Unfortunately I cannot, it is a customer file which I cannot share.
Are there any options that would allow Aspose to load the file it saved as XLSX?
Thank you. We dug deeper and because the XLSB file had macros we did lose information. There is corruption, but independent of this. I am create a new post for that since it is independent of this.
//First check if this Excel file has macros
if(wb.HasMacro == true)
//Since it has macros so save it in Xlsm format. Xlsx will not be OK here.
//Since it does not have macros so save it in Xlsx format. But Xlsm will also be OK here