Grid Export

[Fábio]

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

 

 

[Vessy]

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

[Fábio]

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

[Vessy]

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