I'm trying to create a line in an excel file through the NPOI library. The problem is that I do not know how to set a size for the line. Currently, the line is capping the content of the text.
How can I set the height of the line (if possible automatic height)?
private static void CreateHeader(IRow row, List<string> header)
{
HSSFWorkbook wb = new HSSFWorkbook();
ISheet sheet = wb.CreateSheet("Modelo");
ICellStyle style = wb.CreateCellStyle();
IRow row = row.CreateRow(0);
for (int i = 0; i < header.Count; i++)
{
ICell cell = row.CreateCell(i);
cell.SetCellValue(header[i]);
cell.CellStyle = style;
}
}