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
No Data
Reply
  • 11095
    Offline posted


    Hello Matt,

    Thank you for contacting Infragistics Developer Support!

    I was not able to reproduce the behaviour that you're seeing on your side. I have attached the sample project I used to test this. The version I am using is 2112. Please test this project on your side; whether or not it works correctly may help indicate the nature of this issue.
    If this sample project is not an accurate demonstration of what you're trying to do, please feel free to modify it and send it back, or send a small sample project of your own if you have one.
    Please let me know if I can provide any further assistance.

    exporting-sample.zip
Children