NPOI读取和写入文件

增加命名空间:

using NPOI.HSSF.UserModel;
using System.IO;

实现代码:

//文件名称
            string fileName = “D:\\test.xls”;
            FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.ReadWrite);
            //读取文件
            HSSFWorkbook book = new HSSFWorkbook(fs);
            fs.Close();
            FileStream fs1 = new FileStream(fileName, FileMode.Open, FileAccess.ReadWrite);
            //写入文件
            book.Write(fs1);
            fs1.Close();