Hello,
I am currently using the Export method from the UltraWebGridExcelExporter class of the Infragistics35.WebUI.UltraWebGrid.ExcelExport.v11.1, Version=11.1.20111.2178 library to export an UltraWebGrid to Excel. This works as expected but I now wish to export data into Excel 2007 (.xlsx).
So far, I've set the WorkbookFormat to Excel 2007 which creates an Excel 2007 file but the DownloadName gets appended with an .xls extension. Is there a way to set the file extension for the DownloadName to xlsx with this version of the UltraWebGrid?
Thanks!
Hello Carl,
Thank you for posting to our forum.
The UltraWebGrid (infragistics version 11.1)is no longer supported.
I have tested the scenario with the latest version of infragistics V 16.2 ,created a sample of WebDataGrid with WebExcelExporter and set the WorkbookFormat to Excel2007 and when I export the grid DownloadName file does append with the .xlsx extension.
Code snippet:
this.WebExcelExporter1.DownloadName = fileName;
this.WebExcelExporter1.WorkbookFormat = Infragistics.Documents.Excel.WorkbookFormat.Excel2007;
I would recommend you to upgrade your project from classic controls(V11.1) to latest Infragistics control 16.2 to get advantage of latest feature of WebDataGrid and for further assistance.
You may be able to find and ask for more information on this in our retired controls forum section for the UltraWebGridExcelExporter.
Please let me know if you need further assistance on this matter.
Thanks for your response. I was under the impression that I posted this question in the retired controls forum under WebGrid which is where the UltraWebGridExcelExporter is defined. Also, replacing the UltraWebGrid with the latest Infragistics version is not possible at the moment.
Based on your response, are you saying it is not possible to create an Excel document with the .xlsx extension with the 11.1 version of Infragistics?
I am not sure if it is possible to create an Excel document with the .xlsx extension with the 11.1 version because Version 11.1 has been retired and no longer in support environment.
I cannot test this scenario or have further information with version 11.1 ,With the latest version 16.2 it is working as expected so my recommendation is to upgrade your project and get the latest build.
Please let me know if you need further assistance to upgrade your project.