Grid Export

4 posts, 0 answers
  1. Fábio
    Fábio avatar
    12 posts
    Member since:
    Oct 2017

    Posted 29 Nov 2017 Link to this post

    Hello,

    I'm trying to export the grid in excel format with the code below and it's not being processed, I need something else installed, I do not have Excel, but LibreOffice installed on the machine.

      Protected Sub ImageButton1_Click(sender As Object, e As ImageClickEventArgs)

            RadGrid1.ExportSettings.Excel.Format = DirectCast([Enum].Parse(GetType(GridExcelExportFormat), "Xlsx"), GridExcelExportFormat)
            RadGrid1.ExportSettings.IgnorePaging = False
            RadGrid1.ExportSettings.ExportOnlyData = True
            RadGrid1.ExportSettings.OpenInNewWindow = True
            RadGrid1.MasterTableView.ExportToExcel()
        End Sub

    Thank you,
    Automatically translated

     

     

  2. Vessy
    Admin
    Vessy avatar
    2299 posts

    Posted 01 Dec 2017 Link to this post

    Hi,

    The export to Xlsx functionality in RadGrid is based on the Telerik document processing libraries, so you will ave to make sure that all assemblies listed here are referred in your project:
    https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/export-formats/xlsx-and-docx-export#required-assemblies

    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. Fábio
    Fábio avatar
    12 posts
    Member since:
    Oct 2017

    Posted 01 Dec 2017 in reply to Vessy Link to this post

    Hi Vessy,

    Thanks for the reply, but this morning I managed to resolve it, I was missing the DLL Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll.

    Automatically translated
  4. Vessy
    Admin
    Vessy avatar
    2299 posts

    Posted 04 Dec 2017 Link to this post

    Hi,

    Thank you for the update, Fábio - I am glad you managed to resolve the problem. Please, feel free to reach us again should any further issue occur.

    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