Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
825
iggrid export to Excel produces an unreadable xlsx file
posted

When I export to an Excel file there are no JS errors, and I get an .xlsx file. Unfortunately neither Windows Excel 2007 nor Mac Excel 2011 can open it. They both complain that the file is corrupt, but are unable to repair it.

         $.ig.GridExcelExporter.export($(selector), {
                  fileName: fname_prefix + suffix,
                  gridFeatureOptions: {
                        // Exports the currentPage in the excel document
                        paging: "allRows"
                    },
                  gridStyling: "none"
                });

Note that our grid uses the paging, filtering, groupby, and sorting features. But I turned paging off for export (see above), and the test I'm running has no grouping, sorting, or filtering applied by the user. (I also tried filtering the results down to one row, but that didn't help.) Plus I turned off styling, just in case.

Infragistics jQuery controls version 15.1.20151.1005

I am using the versions of FileSaver.js and Blob.js from http://www.igniteui.com/js/external/

Not sure what else to look for. Suggestions needed.

Thanks,

Matt

Parents Reply Children