HSSFWorkbook hssfworkbook = new HSSFWorkbook();
#region//读取模板
try
{
using (FileStream file = new FileStream(templatePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
hssfworkbook = new HSSFWorkbook(file);
}
}
catch (Exception e)
{
throw e;
}
#endregion
ISheet sheet = hssfworkbook.GetSheetAt(0);//获取工作表
int startRecord = 5;
//批量插入行
sheet.ShiftRows(rowRecord, sheet.LastRowNum, dataset.Count, true, false);
说明:
startRecord , //--开始行
sheet.LastRowNum, //--结束行
dataset.Count, //--添加行数数量
true, //是否复制行高
false//, //是否重置行高
新插入行无样式
var rowSource = sheet.GetRow(5);//获取已有行
var rowStyle = rowSource.RowStyle;//获取当前行样式
var rowInsert = sheet.CreateRow(6);//创建新行
rowInsert.RowStyle = rowStyle; //给新行添加旧行样式