I'm trying to utilize the Excel Exporter in IgniteUI 15.1, and cannot get any exported file to open. I'm using a carbon copy of the sample code provided.
I get the following two messages:
"We found a problem with some content in 'igGrid.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."
If I click yes, the next message is displayed:
"Excel cannot open the file 'igGrid.xlsx' because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
If I do an export from the samples website, it works great. When I try to implement it in my own website, it fails.
Hello,
I'm just following up to see if you had the time to provide the requested files and information.
Hello Peter,
Thank you for posting in the Infragistics community !
Please provide the sample file used to generate the excel worksheet and I will be glad to investigate this for you. Any relevant environment information will help troubleshooting.
Looking forward to hearing from you.
I decided to dig a little deeper and use the Excel JS library to do a custom export.
Excel2007 does not generate a valid file. Neither does strictOpenXML. But if I choose Excel97to2003, it works fine.