This project has moved and is read-only. For the latest updates, please go here.

Column Formatting

Nov 25, 2013 at 9:15 PM
Is it possible to assign the number format to a column as straight forward as ClosedXML, I mean

I've tried something like this in ClosedXML and it works perfectly

ws.Cell(row, col).Style.NumberFormat.NumberFormatId = 9;

The only way I see how to do this in EPPlus is using custom formats:

ws.Column(1).Style.Numberformat.Format = "0.00%"

But I really would like to be able to use the built in formats as :

ews.Column(1).Style.Numberformat.NumFmtID = 9;

but NumFmtID is read only, is there are work around this?

Thanks in advance