Epplus find column using column name
<p>I have excel sheet created dynamically, i would like to format some columns as date however i don't know the index of these columns in advance i only know the header title.</p>

<p>1- I load the excel from DataTable</p>

<pre><code>var templateXls = new ExcelPackage();
        var sheet = templateXls.Workbook.Worksheets.Add(parameters.ReportName);

        sheet.Cells["A1"].LoadFromDataTable(myDataTable, true);
</code></pre>

<p>Now how can i format for example column with name "Birthdate" to be short-date field? the column can be in any index depends on user selection also there is a possibility that the column is not generated. (if the user doesn't include it)</p>