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.
I am getting a minor problem when exporting data from grid to Excell. I have applied currency formatting on grid to a specific column, but when I export it to Excel, currency formatting is simply not there.
if grid shows $30.00, then excel is showing 30.
code I used for it is
Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();
if (saveFileDialog.ShowDialog() == DialogResult.OK) { try {
gecc.GridToExcel(this.grdSpreadsheetANReport.Model, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.Visible); if (MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) System.Diagnostics.Process.Start(saveFileDialog.FileName); } catch (Exception ex) { MessageBox.Show(ex.Message);
HAhaneefm Syncfusion Team April 3, 2007 06:21 PM UTC
Hi Touqeer,
You would have to derive the GridExcelConverterControl class and implement the GridToExcel method. Please refer to the attached sample for more details and let me know if this helps.