使用NPOI将数据导出至Excel
第一次使用NPOI.觉得很强大.........
简单代码:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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 }
作者:javaoraspx
出处:http://www.cnblogs.com/xyong/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。