GridExcelExport custom date format

[Jo Scothern]

We have a function that takes a dataset and exports it to excel using the GridExcelExport function. The problem we are having is that this is automatically converting the date format in excel to mm/dd/yyyy

We need to be able to specify the format that this comes out.

The code that we are using looks like this:

public static void ExportToExcel(this DataSet data, string filename)
	{
		GridGroupingControl syncGrid = new GridGroupingControl();
		syncGrid.DataSource = data.Tables[0];
		GridExcelExport gridExcelExport = new GridExcelExport(syncGrid, filename + ".xls");
 
		gridExcelExport.ExportNestedTable = true;
		gridExcelExport.Export();
	}

Regards
Jo

[Hariharan J V]

Hi Jo,
 
Thank you for using Syncfusion products.

Your requirement can be achieved by customizing the export cell data format in FormatExcelCellHandler event. Please refer to the following code snipptes:

[Default.aspx.cs]
protected void Button1_Click(object sender, EventArgs e)
{
GridExcelExport excel = new GridExcelExport(this.GridGroupingControl1, "excel.xls");
excel.ExportNestedTable = true;
//Exporting event
excel.FormatExcelCellHandler += new ExportExcelCellHandler(excel_FormatExcelCellHandler);
excel.Export();
}

void excel_FormatExcelCellHandler(object sender, ExcelExportEventArgs e)
{
if (e.RowElement.IsRecord() && e.ExcelCell.Column == 5) // condition to check the record and column as 5th column(Date column)
{
// set the format for specified cell data.
e.ExcelCell.Cells[0].NumberFormat = "m/d/yyyy";
}}

For your convenience, we have prepared a simple sample to demonstrate this and the same can be downloaded from the below link.

Sample: www.syncfusion.com/downloads/support/directtrac/general/export-1432353488.zip

Please let us know if you need any further assistance.

Regards,
Hariharan J.V.