RadGrid to Xlsx not found

5 posts, 0 answers
  1. Bertha
    Bertha avatar
    94 posts
    Member since:
    Aug 2012

    Posted 07 Dec 2017 Link to this post

    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.

  2. Vessy
    Admin
    Vessy avatar
    2033 posts

    Posted 11 Dec 2017 Link to this post

    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.
  3. Bertha
    Bertha avatar
    94 posts
    Member since:
    Aug 2012

    Posted 11 Dec 2017 Link to this post

    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.

  4. Bertha
    Bertha avatar
    94 posts
    Member since:
    Aug 2012

    Posted 11 Dec 2017 in reply to Bertha Link to this post

    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
    }
    }

  5. Vessy
    Admin
    Vessy avatar
    2033 posts

    Posted 14 Dec 2017 Link to this post

    Hi Bertha,

    Yes, I am afraid that the .NET version os causing the faced probelm. The Document Processing Libraries are supported only in .NET 4.0 and above, so you will need to upgrade your project in order to usilize 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.
Back to Top