NPOI简单导入导出EXCEL
1 //创建写入
2 HSSFWorkbook wb = new HSSFWorkbook();
3 ISheet sheet1 = wb.CreateSheet("Tab One");
4 IRow ir = sheet1.CreateRow(0);
5 ir.CreateCell(0, CellType.String).SetCellValue("Hell No!");
6 using (Stream stream = File.OpenWrite("d:/1.xls")) //或者d:\\1.xls
7 {
8 wb.Write(stream);
9 }
10 //读取
11 string str;
12 using (Stream stream = File.OpenRead("d:\\1.xls"))
13 {
14 HSSFWorkbook hswb = new HSSFWorkbook(stream);
15 str = hswb.GetSheet("Tab One").GetRow(0).GetCell(0).StringCellValue;
16 }
17 Console.WriteLine(str);
18 Console.ReadKey();
日期格式的处理
1 HSSFWorkbook workbook = new HSSFWorkbook();
2 ISheet sheet1 = workbook.CreateSheet("Employees");
3 IRow row = sheet1.CreateRow();
4 //日期格式处理
5 ICellStyle dateStyle = workbook.CreateCellStyle();
6 IDataFormat dateFormat = workbook.CreateDataFormat();
7 //格式可以从Excel右击单元格，设置格式，自定义中获得
8 dateStyle.DataFormat = dateFormat.GetFormat("yyyy\"年\"mm\"月\"dd\"日\"");
9 ICell cellInDate = row.CreateCell(0, CellType.Numeric);
10 cellInDate.CellStyle = dateStyle;
11 cellInDate.SetCellValue(一个DateTime格式的值);
浙公网安备 33010602011771号