BoldSignA modern eSignature application with affordable pricing. Sign up today for unlimited document usage!
Hi Pradheep,
Thanks for using Syncfusion products.
Query : Unable to export $ symbol from gridgrouping control to excel using GridExcelExport?
To achieve your requirement, we suggest you handle the ExcelOnCompleteHandler event in the button click control and formatting the number in the excel sheet by using below code snippet.
[aspx.cs]
void excel_ExcelOnCompleteHandler(object sender, OnExportExcelEventArgs e)
{
var column = e.workbook.ActiveSheet.Columns[1];
for(int i=0;i<column.Rows.Length;i++)
{
column.Rows[i].NumberFormat = "$##,###.##";
}
}
Please refer the below UG link to know further details about number formatting in the excel sheet.
http://help.syncfusion.com/ug/asp.net/xlsio/default.htm#!documents/numberformatting.htm
Please refer the below link to download the sample.
Please let us know if you have any concerns.
Regards,
Ajith R
Hi Pradheep,
Thanks for your update.
Query : The type or namespace name 'OnExportExcelEventArgs' could not be found?
We are sorry for the inconvenience caused. We suspect that you have missed some important references in your project. Please refer the below screen shot to review the references in your project.
If issue still persist please get back to us with essential studio version and other issue related information, so that we could sort out the issue and provide you with solution. The information provided would be of great help in resolving the issue.
Please let us know if you have any concerns.
Regards,
Ajith R
Hi Pradheep,
Thanks for your update.
Query : The type or namespace name 'OnExportExcelEventArgs' could not be found?
Please ignore the previous update.
We are sorry for the inconvenience caused. We suspect that you have missed some important references in your project. Please refer the below attachment to review the references in your project.
If issue still persist please get back to us with essential studio version and other issue related information, so that we could sort out the issue and provide you with solution. The information provided would be of great help in resolving the issue.
Please let us know if you have any concerns.
Regards,
Ajith R