更新时间:2022-09-20 09:25:40
public void NPOITest()
{
HSSFWorkbook hssWorkbook = new HSSFWorkbook();
ISheet hssSheet = hssWorkbook.CreateSheet("new sheet");
hssSheet.CreateRow(0).CreateCell(0).SetCellValue("This a sample");
FileStream fs = new FileStream(@"d:\temp\test.xls", FileMode.Create);
hssWorkbook.Write(fs);
fs.Close();
}
|
public void TestExcel()
{
FileStream file = new FileStream(@"d:\temp\test.xls", FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfWork = new HSSFWorkbook(file);
ISheet iSheet = hssfWork.GetSheet("new sheet");
//获取所有行数,然后再+1的基础上加入数据 (lastRowNum是当前数据的最后一行)
iSheet.CreateRow(iSheet.LastRowNum+1).CreateCell(0).SetCellValue("testtest");
FileStream fss = new FileStream(@"d:\temp\test.xls", FileMode.Create);
hssfWork.Write(fss);
file.Close();
}
|