I have been following this example here:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx
But I am unable to select GridExcelExportFormat.Xlsx from the list when I am setting this value:
The only options are ExcelML, Biff and Html.
The ExcelML works as a .xls file but keeps throwing warnings every time the spreadsheet is opened in Excel 2013.
How to fix that?
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx
But I am unable to select GridExcelExportFormat.Xlsx from the list when I am setting this value:
rgTools.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;The only options are ExcelML, Biff and Html.
The ExcelML works as a .xls file but keeps throwing warnings every time the spreadsheet is opened in Excel 2013.
How to fix that?
8 Answers, 1 is accepted
0
Hello Siviu,
As documented in our help article "XLSX and DOCX Export", the "Xlsx" export format was introduced in Q3 2014, so in order to export that format you need to upgrade to that or a newer version.
Hope this helps.
Best Regards,
Konstantin Dikov
Telerik
As documented in our help article "XLSX and DOCX Export", the "Xlsx" export format was introduced in Q3 2014, so in order to export that format you need to upgrade to that or a newer version.
Hope this helps.
Best Regards,
Konstantin Dikov
Telerik
See What's Next in App Development. Register for TelerikNEXT.
0
Silviu
Top achievements
Rank 1
Rank 1
answered on 03 Apr 2015, 10:29 AM
Thank you.
I have upgraded and now I have that option.
I have upgraded and now I have that option.
0
Nicholas
Top achievements
Rank 1
Rank 1
answered on 23 Jun 2015, 09:24 PM
Hello,
I'm have the issue stated in this thread (no xlsx appearing as formats). I am updated, I was wondering if there is anything else I could be missing?
Thanks for any help,
Nick
I'm have the issue stated in this thread (no xlsx appearing as formats). I am updated, I was wondering if there is anything else I could be missing?
Thanks for any help,
Nick
0
Hello Nick,
The only reason for the missing XLSX format would be if you are using older version of our controls. Can you please ensure that you are using version Q3 2014 or above.
You can also take a look at the following help article with detailed information about the upgrading and the necessary steps that needs to be taken:
Hope this helps.
Regards,
Konstantin Dikov
Telerik
The only reason for the missing XLSX format would be if you are using older version of our controls. Can you please ensure that you are using version Q3 2014 or above.
You can also take a look at the following help article with detailed information about the upgrading and the necessary steps that needs to be taken:
Hope this helps.
Regards,
Konstantin Dikov
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items
0
karthikeyan
Top achievements
Rank 1
Rank 1
answered on 11 Jan 2018, 11:46 AM
Hi I am facing the same problem I am using the Telerik.Web.UI.dll product version 2015.3.930.35. please confirm this dll belongs to version Q3 2014 or above.
0
Harish Subramanian
Top achievements
Rank 1
Rank 1
answered on 22 Jul 2020, 02:41 PM
We purchased the Telerik Devcraft product last year. My Telerik.web.ui version says 2019..2.514.35. My RadGrid excel export setting Excel-Format=" does not have "Xlsx". It only has Biff, ExcelML, HTML. Currently it exports to xls file. Our organization disabled the xls download as a security violation. how to get the xlsx download enabled in the Radgrid. Please help.
0
Harish Subramanian
Top achievements
Rank 1
Rank 1
answered on 22 Jul 2020, 02:42 PM
We purchased the Telerik Devcraft product last year. My Telerik.web.ui version says 2019..2.514.35. My RadGrid excel export setting Excel-Format=" does not have "Xlsx". It only has Biff, ExcelML, HTML. Currently it exports to xls file. Our organization disabled the xls download as a security violation. how to get the xlsx download enabled in the Radgrid. Please help.
0
Hi Harish,
I have sent an answer to the support ticket you have opened about Exporting RadGrid to excel. I would suggest proceeding the communication in the support thread only, and when we reach a resolution, I could share it here also.
Concerning the missing Xlsx in the export format options, I would suggest you go check out and try the suggestions in the Upgrading Troubleshooting section. The issue could be due to referencing the old version of Telerik Control.
Check if the correct version of Telerik controls is referenced - http://somup.com/cYi0226iKR
Kind regards,
Doncho
Progress Telerik