Export to Excel Date Format for UK

[thowra]

Hi, My web application exports a List of objects to an Excel spreadsheet by creating a DataGrid and binding it to the List. The objects that the List contains include columns whose type is DateTime and while the resulting spreadsheet correctly lists all the objects, the date format is US instead of UK (which is what I want) - to be expected really. I can, of course, create a new object class and copy each object in the List to a second List of these new object types and bind the DataGrid to that but I'll have to do the same for every list of object types I want to export. Can anyone suggest a simple method to resolve this issue? Thanks :)

Evil cannot be conquered in the world... It can only be resisted within oneself.

[thowra]

Simplest method turned out to be iterating through the list, parsing any DateTime fields with the DateTime.Parse() method specifying "en-GB" CultureInfo as the DateTimeFormat parameter :cool:

Evil cannot be conquered in the world... It can only be resisted within oneself.