Excel date format using EPPlus

Question

I'm having trouble with format my cells to Date.

FileInfo info = new FileInfo(path); using (ExcelPackage package = new ExcelPackage(info)) {       ExcelWorksheet ws = package.Workbook.Worksheets.Add(sheetName);       ws.Cells[3, 1].Style.Numberformat.Format = "yyyy-mm-dd";       ws.Cells["A3"].Formula = "=DATE(2014,10,5)"; } 

Output from this in Excel: 41 917,00

Why is this not working?

Answer 1

I agree with Yosoyke. You're probably targeting the wrong cells. You can try:

ws.Cells["A3"].Style.Numberformat.Format = "yyyy-mm-dd"; ws.Cells["A3"].Formula = "=DATE(2014,10,5)";