使用NPOI将数据导出至Excel

第一次使用NPOI.觉得很强大.........

简单代码:

View Code

 1 using System;
 2 using System.Data;
 3 using System.Configuration;
 4 using System.Collections;
 5 using System.Web;
 6 using System.Web.Security;
 7 using System.Web.UI;
 8 using System.Web.UI.WebControls;
 9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using NPOI.HPSF;
12 using NPOI.HSSF.UserModel;
13 using System.IO;
14 
15 public partial class Default2 : System.Web.UI.Page
16 {
17     protected void Page_Load(object sender, EventArgs e)
18     {
19         if (!IsPostBack)
20         {
21             Test();
22         }
23     }
24     HSSFWorkbook hssfworkbook = new HSSFWorkbook();  //创建一个实例
25     private void Test()
26     {
27         DataSet ds = DbHelp.GetDataSet("select * from sys_spec_com");  
28         HSSFSheet sheet1 = (NPOI.HSSF.UserModel.HSSFSheet)hssfworkbook.CreateSheet("sheet1");
29         HSSFRow row;
30         HSSFCell cell;
31         for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
32         {
33             row = (HSSFRow)sheet1.CreateRow(i);
34             for (int j = 0; j < ds.Tables[0].Rows[i].ItemArray.Length; j++)
35             {
36                 cell = (HSSFCell)row.CreateCell(j);
37                 cell.SetCellValue(ds.Tables[0].Rows[i][j].ToString());
38             }
39         }
40         FileStream file = new FileStream(@"C:/test.xls", FileMode.Create);
41         hssfworkbook.Write(file);
42         file.Close();
43     }
44 }

转载于:https://www.cnblogs.com/xyong/articles/2226679.html