NPOI 添加行
IRow sourceRow = sheet1.GetRow(3); for (int i = 0; i < dt.Rows.Count-1; i++) { IRow row = sheet1.CreateRow(4 + i); row.Height = sourceRow.Height; for (int m = sourceRow.FirstCellNum; m < sourceRow.LastCellNum; m++) { ICell cell = row.CreateCell(m); // cell.SetCellValue("0"); ICellStyle cellStyle = sourceRow.Cells[m].CellStyle; cellStyle.Alignment = HorizontalAlignment.CENTER; cell.CellStyle = cellStyle; cell.SetCellType(sourceRow.Cells[m].CellType); } }