Getting format exception and not getting proper value of a cell which shows properly on excel

[YonathanFeyessa]

I am getting a '((ClosedXML.Excel.XLCell)timeCell).Value' threw an exception of type 'System.FormatException' when trying to access the value of a cell which contains a date with a custom format of [$-en-US]dddd, mm/dd .

Appreciate all the help.

[igitur]

ClosedXML won't be able to evaluate a custom format like that. I suggest changing the format to something more standard before trying to retrieve the value.

[YonathanFeyessa]

thanks for the reply I changed the format to a standard date format and still throwing the same error....is there another lib you suggest for this kind of issues. thank you

[igitur]

If you can attach your spreadsheet, I can have a look at the problem.

[YonathanFeyessa]

Book1.xlsx
Can you format the cell with Monday, 11/21 text. Thank you.

[igitur]

Using the latest code from the develop branch, I can successfully retrieve the date value using this code:

private static void Main(string[] args)
{
    using (var wb = new XLWorkbook("test.xlsx"))
    {
        var ws = wb.Worksheets.First();
        var cell = ws.Cell("B11");
        cell.Style.NumberFormat.SetFormat("yyyy-MM-dd");
        cell.DataType = XLCellValues.DateTime;
        Console.WriteLine(cell.Value);
    }

    Console.WriteLine("Press any key to continue");
    Console.ReadKey();
}

[YonathanFeyessa]

ok Thank you I will clone and test.