iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hi,
We are using Webgrid version 2014 R2 . Whenever export from Grid as Excel is choosed that time Excel date column appears string inside Excel.
We found that in exported Excel date columns have extra quote as prefix in date values therefore it works as string in Excel . For example date 11/2/2014 entered in Excel as'11/2/2014 .
It is very annoying that after exporting we have to manually fix date columns.
Please suggest a solution for this.
thanks and regards
Dev
Hi Devbrat Ghosh,
Currently we don't support this feature yet. When you export to Excel, the DotNet/C# date formats are not the same as the ones in Excel, so the grid cannot export the format along with the data.For your information, you could format the date into your desired format using dataformatstring in the OnExport server-side event handler.Example:
protected void WebGrid1_Export(object sender, ExportEventArgs e){ e.ReportInfo.IsEnableDataFormatString = true; e.Table.Columns.GetNamedItem("OrderDate").DataFormatString = "dd/MM/yyyy"; }
Best Regards,Leo
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...