This is a migrated thread and some comments may be shown as answers.

RadGrid to Xlsx not found

4 Answers 225 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Bertha
Top achievements
Rank 1
Bertha asked on 07 Dec 2017, 03:00 PM

radGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;

I want the format to be Xlsx.  But it only shows Biff, ExcelML, Html as selection.  My references of Telerk.Web.UI is pointing to

C:\Program Files (x86)\Progress\Telerik UI for ASP.NET AJAX R3 2017\Bin35\Telerik.Web.UI.dll

What do I miss?  Thanks.

4 Answers, 1 is accepted

Sort by
0
Vessy
Telerik team
answered on 11 Dec 2017, 04:24 PM
Hi Bertha,

Can you, please, look at the source code of a page holding the Grid and search for a comment starting with "<!-- 201" so we make sure that the app is not running with an older version from the GAC? What is the version number shown in the comment?
https://www.screencast.com/t/RS8u9qwyGg

Please, make sure, as well, that all assemblies required for the Xlxs exporting functionality of the Grid are referred in the project:
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/export-formats/xlsx-and-docx-export

Regards,
Vessy
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Bertha
Top achievements
Rank 1
answered on 11 Dec 2017, 04:58 PM

I have just added the required assemblies and recompiled but still not showing Xlsx.  I checked the version as suggested but it is 2017. When I jump to Defintion of GridExcelExportFormat as attached, it did not show Xlsx as option, too.  Should I add it manually to definition?

But this is an old program using .net Framework 3.5.  Is this restricted from not showing Xlsx?

Thanks.

0
Bertha
Top achievements
Rank 1
answered on 11 Dec 2017, 06:01 PM

attached.

namespace Telerik.Web.UI
{
//
// Summary:
// Enumeration determining in what format the Telerik.Web.UI.RadGrid Excel data
// will be exported.
public enum GridExcelExportFormat
{
Html = 0,
ExcelML = 1,
Biff = 2
}
}

0
Vessy
Telerik team
answered on 14 Dec 2017, 03:35 PM
Hi Bertha,

Yes, I am afraid that the .NET version os causing the faced . The Document Processing Libraries are supported only in .NET 4.0 and above, so you will need to upgrade your project in order to the export to XLSX functionality of the Grid.

More details on this matter are provided here:
https://docs.telerik.com/devtools/aspnet-ajax/installation/included-assemblies#telerik-document-processing-libraries

Regards,
Vessy
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Bertha
Top achievements
Rank 1
Answers by
Vessy
Telerik team
Bertha
Top achievements
Rank 1
Share this question
or