The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
Is there a way to efficiently export the data from a gridGroupcontrol to an excel sheet along with formatting, grouping(if any), summary rows(if any)..
currently I use IWorkbook myWB = ExcelUtils.CreateWorkbook(1); IWorksheet sheet = myWB.Worksheets[0];
GridTableCellStyleInfo si = this.grid.TableModel[row, col];
Then I get each cell and check the si.Formatted text to see if its a $ or a date or a price, etc... The I set the number format(if $) to the excel cell and do a .text = value..
This is very slow as my grid contains 5000 rows with 50-70 columns.. Is there a quick way to export?
RARajagopal Syncfusion Team July 26, 2007 02:15 AM UTC
Hi Navaneeth,
Thanks for your interest in Syncfusion Products.
In our latest version (v5.1), we ship a sample called 'Excel Export' with our browser samples, that has these features implemented when exporting the gridgroupingcontrol to excel.
I am using 4.4.. Is there a way to achieve this feature in 4.4?
Thanks
RARajagopal Syncfusion Team August 2, 2007 06:07 AM UTC
Hi Navaneeth,
We have added these features from our latest version. If you want this in the version 4.4, then you would have to derive the GridExcelConverterControl class and implement the GridToExcel method to add this feature. We will update you with a sample accordingly, that has this feature of exporting the formatting, grouping if any in gridgroupingcontrol to excel.