首先添加引用NPOI.dll
using NPOI.HSSF.UserModel; //HSSFWorkbook
using NPOI.SS.UserModel; // ISheet IRow
之后可以在代码中利用NPOI来对Excel进行操作
读excel:
HSSFWorkbook wb1 = new HSSFWorkbook();
ISheet sheet1 = wb1.CreateSheet();
using (FileStream fsRead = File.OpenRead(@"d:/myxls.xls"))
{
wb1 = new HSSFWorkbook(fsRead);
sheet1 = wb1.GetSheetAt(0);
NumAll = sheet1.LastRowNum + 1; //获取文本最后一行具体为多少,然后加一
if (NumAll !=