本地版本2.1.3.1
1、创建或获取excel文件
var fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
IWorkbook workbook = WorkbookFactory.Create(fs);
2、行、列获取,设置
int rowCount = sheet.LastRowNum;
int cellCount = firstRow.LastCellNum;
IRow firstRow = sheet.GetRow(0);
ICell cell = firstRow.GetCell(cellCount);
cell = firstRow.CreateCell(3);
cell.CellStyle = columnStyle;
cell.SetCellValue("test");
3、样式:
ICellStyle columnStyle = workbook.CreateCellStyle();
columnStyle.BorderBottom = BorderStyle.Thin;
columnStyle.BorderLeft = BorderStyle.Thin;
columnStyle.BorderRight = BorderStyle.Thin;
columnStyle.BorderTop = BorderStyle.Thin;
columnStyle.Alignment = HorizontalAlignment