Cannot export to XLSX

[Silviu]

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:

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?

[Konstantin Dikov]

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

 

 

[Silviu]

Thank you.
I have upgraded and now I have that option.

[Nicholas]

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

[Konstantin Dikov]

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:

• Upgrading a Trial to a Developer License or to a Newer Version

Hope this helps.


Regards,
Konstantin Dikov
Telerik

[karthikeyan]

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.

[Harish Subramanian]

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.

[Harish Subramanian]

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.

[Doncho]

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