Restrict Date Format in Excel to 'dd\mm\yy'

[Jackyog]

Hi,

While exporting to excel, Is there a way to restrict the format for date columns like 'dd\mm\yy'. And should not allow user to enter any other format on the excel.


- Jack

[DataExport]

Hello,

If you want to set data format on a column, You need to write code in GetDataParams event.
Try to use the following example code,

Code: Select all

private void cellExport1_GetDataParams(object sender, Spire.DataExport.EventArgs.DataParamsEventArgs e)
{
      if (e.Col == 1)
      {
            e.FormatText = "dd/MM/yy";
      }
}