我们创建了excel后需要往里面进行添加数据,此节我们来创建excel添加shell里面的数据
引入命名控件
using NPOI;
using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using NPOI.POIFS.FileSystem;
using NPOI.XSSF.UserModel;
在程序中进行加入相关的创建文件
HSSFWorkbook books = new HSSFWorkbook();//生成xls格式excel
DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
dsi.Company = "我今天创建的";
si.Subject = "我今天创建的Subject";
si.Author = "作者";
si.LastAuthor = "做后修改者";
si.LastPrinted = System.DateTime.Now;
si.LastSaveDateTime = System.DateTime.Now;
books.DocumentSummaryInformation = dsi;
books.SummaryInformation = si;
ISh