Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Comment set Column Type when using EPPlus

ayi

I’m using <code>EPPlus</code> to generate <code>Excel</code> files, in DAL I’m populating <code>DataTable</code>, filling data into table, and passing table to Presentation Layer. From there I’m using <code>LoadFromDataTable()</code> method to generate <code>Excel</code> file.
Everything works fine, except that I want to set one of the column’s type to <code>Date</code>. I tried to set Column type of my <code>DataTable</code> to<code>Date</code> and than pass <code>DataTable</code> to Presentation Layer, but it seems <code>EPPlus</code> either, ignored it, or didn’t recognize, because when I’m opening generated <code>Excel</code> file, cell’s type is <code>Number</code>.
If I manually Format Cells and set Type to <code>Date</code>, <code>Excel</code> shows correct dates. So how can I achieve this ?

ayi_2

You do need the DataTable column to have the right type but you also need to modify the column or cell’s Style.Numberformat.Format property.
Say you have an <code>ExcelWorksheet</code> named <code>ws</code>:
<pre><code class="lang-auto">ws.Column(1).Style.Numberformat.Format = "yyyy-mm-dd";
//OR "yyyy-mm-dd h:mm" if you want to include the time!

</code></pre>