Hi When using the epplus library like this:
If the Datatable contains a date e.g. 05/05/2011 it converts it to a numeric value of 40668.
Looking in the worksheet xml, this renders (as an example):
<c r="J14" s="0">
When I open the worksheet in Excel and Modify the cell to Date, it changes the above XML to
<c r="J14" s="1">
I was just wondering if I can set this flag to 1 based on the datatype from the datatable, and if so - what the syntax would be, as I cant find it in the documentation