I see a lot of examples in documentation where data type for a cell is set:
ws.Cell(1, 1).SetDataType(XLCellValues.Text);
But when I try to set a data type for a column:
ws.Column(1).SetDataType(XLCellValues.Text)
ClosedXML generates a 5MB file and data type is not actually set.
This operation works as expected in Excel (right-click on the column header, format cells, ...).
If it is a limitation of ClosedXML, can it be easily fixed, or is there a workaround?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…