NPOI操作Excel

1、转载地址：http://www.cnblogs.com/knowledgesea/archive/2012/11/16/2772547.html

2、日期的处理

     row.CreateCell(0, CellType.NUMERIC).SetCellValue(employees[i].InDate);

     要设置CellStyle

     ICellStyle styledate = hssfworkbook.CreateCellStyle();

     IDataFormat format = hssfworkbook.CreateDataFormat();

      styledate.DataFormat = format.GetFormat("yyyy\"年\"m\"月\"d\"日\"");

3、code

 

for (int i = 0; i < employees.Length; i++)
            {
                IRow row = sheet.CreateRow(i+1);
                row.CreateCell(0, CellType.STRING).SetCellValue(employees[i].Name);
                row.CreateCell(1, CellType.STRING).SetCellValue(employees[i].Number);
                //日期
                ICellStyle styledata = book.CreateCellStyle();
                IDataFormat format = book.CreateDataFormat(); 
                styledata.DataFormat = format.GetFormat("yyyy年m月d日");
                ICell cell = row.CreateCell(2, CellType.NUMERIC);
                cell.CellStyle = styledata;
                cell.SetCellValue(employees[i].InDate);
                //日期

            }