NPOI基本使用

1.添加引用：

using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.SS.Util;

2.操作xsl：

string fullPath = System.AppDomain.CurrentDomain.BaseDirectory+ DateTime.Today.ToString("yyyyMMdd") + ".xls";
using (FileStream fs = File.Create(fullPath))
{
    ISheet sheet = workbook.GetSheetAt(0); //获取sheet
     //写数据
    sheet.CreateRow(1).CreateCell(0).SetCellValue("日期"); 
    sheet.GetRow(1).CreateCell(1).SetCellValue(DateTime.Today.ToString("yyyyMMdd"));
    //合并单元格
    sheet.AddMergedRegion(new CellRangeAddress(1, 2, 0, 0));
                       
    //保存文件
    workbook.Write(fs);
 }