This is a migrated thread and some comments may be shown as answers.
Grid Export
3 Answers 9 Views
This is a migrated thread and some comments may be shown as answers.
Fábio
Top achievements
Rank 1
Fábio asked on 29 Nov 2017, 04:36 PM

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

 

 

3 Answers, 1 is accepted

Sort by
0
Vessy
Telerik team
answered on 01 Dec 2017, 04:24 PM
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.
0
Fábio
Top achievements
Rank 1
answered on 01 Dec 2017, 06:01 PM
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
0
Vessy
Telerik team
answered on 04 Dec 2017, 07:27 AM
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.
Tags
Grid
Asked by
Fábio
Top achievements
Rank 1
Answers by
Vessy
Telerik team
Fábio
Top achievements
Rank 1
Share this question
or