RadGrid Exprot to XLSX format

0 Answers 42 Views
Grid
Dev
Top achievements
Rank 1
Dev asked on 01 Mar 2024, 05:51 AM

Hi All,

We are using the below code for xlsx format export using the Telerik.Web.UI.dll.

  "gridControl.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;"

Is that enough to work in production? and advice if we purchase the DevCraft Ultimate, will it be working fine?

Rumen
Telerik team
commented on 01 Mar 2024, 07:36 AM

Hi Dev Team,

For exporting data from Telerik RadGrid to Excel in XLSX format, the provided code snippet is a part of the setup needed for initiating the export. Telerik's documentation provides comprehensive details on exporting RadGrid to Excel-Xlsx (OOXML) format. This includes necessary assembly references, usage examples, and customization options for the export output, such as formatting cell values, hiding columns/rows, and styling elements. The assemblies you need to reference for exporting to Excel are

  • Telerik.Windows.Documents.Core.dll
  • Telerik.Windows.Documents.Spreadsheet.dll
  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll
  • Telerik.Windows.Zip.dll


Additionally, there is a live demo that showcases the Excel export functionality in action, demonstrating various export options, such as ignoring paging (to export all pages), applying custom styles, and setting the worksheet name and column auto-fit mode for the XLSX format.

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Dev
Top achievements
Rank 1
Share this question
or