I'm trying to get Excel cell formatting as users sees it. In VBA or the Microsoft.Office.Interop.Excel this is done via the DisplayFormat API. But I can't use interop or VBA on the prod server.. Is there any way to access this information using OpenXML or ClosedXML please?
Reason I'm asking is I'm trying create HTML tables from the sheets including formatting, especially whatever conditional formatting does to the cells. Using cell.Style.Fill.BackgroundColor.Color returns Transparent, as it should, the formatting is not actually set in the cell details. Thank you!