asp.net 调用NPOI 输出Excel
来源:互联网 发布:科比历年数据 编辑:程序博客网 时间:2024/06/09 12:49
using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using NPOI.POIFS.FileSystem;
using NPOI.SS.UserModel;
namespace ExportXlsToDownload
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string filename="test.xls";
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}",filename));
Response.Clear();
InitializeWorkbook();
GenerateData();
Response.BinaryWrite(WriteToStream().GetBuffer());
Response.End();
}
HSSFWorkbook hssfworkbook;
MemoryStream WriteToStream()
{
//Write the stream data of workbook to the root directory
MemoryStream file = new MemoryStream();
hssfworkbook.Write(file);
return file;
}
void GenerateData()
{
ISheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
sheet1.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample");
int x = 1;
for (int i = 1; i <= 15; i++)
{
IRow row = sheet1.CreateRow(i);
for (int j = 0; j < 15; j++)
{
row.CreateCell(j).SetCellValue(x++);
}
}
}
void InitializeWorkbook()
{
hssfworkbook = new HSSFWorkbook();
////create a entry of DocumentSummaryInformation
DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
dsi.Company = "NPOI Team";
hssfworkbook.DocumentSummaryInformation = dsi;
////create a entry of SummaryInformation
SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
si.Subject = "NPOI SDK Example";
hssfworkbook.SummaryInformation = si;
}
}
}
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using NPOI.POIFS.FileSystem;
using NPOI.SS.UserModel;
namespace ExportXlsToDownload
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string filename="test.xls";
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}",filename));
Response.Clear();
InitializeWorkbook();
GenerateData();
Response.BinaryWrite(WriteToStream().GetBuffer());
Response.End();
}
HSSFWorkbook hssfworkbook;
MemoryStream WriteToStream()
{
//Write the stream data of workbook to the root directory
MemoryStream file = new MemoryStream();
hssfworkbook.Write(file);
return file;
}
void GenerateData()
{
ISheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
sheet1.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample");
int x = 1;
for (int i = 1; i <= 15; i++)
{
IRow row = sheet1.CreateRow(i);
for (int j = 0; j < 15; j++)
{
row.CreateCell(j).SetCellValue(x++);
}
}
}
void InitializeWorkbook()
{
hssfworkbook = new HSSFWorkbook();
////create a entry of DocumentSummaryInformation
DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
dsi.Company = "NPOI Team";
hssfworkbook.DocumentSummaryInformation = dsi;
////create a entry of SummaryInformation
SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
si.Subject = "NPOI SDK Example";
hssfworkbook.SummaryInformation = si;
}
}
}
- asp.net 调用NPOI 输出Excel
- ASP.NET NPOI导出Excel
- NPOI Asp.net操作Excel
- [ASP.NET] 使用NPOI產生EXCEL
- asp.net C# NPOI 读取 Excel 文件
- ASP.Net使用NPOI导出Excel
- Asp.net NPOI导入导出Excel表格
- asp.net(C#)之NPOI"操作Excel
- asp.net用NPOI导出Excel
- asp.net(C#)之NPOI"操作Excel
- asp.net输出Excel
- 用asp.net调用excel并输出的一点经验
- ASP.NET使用NPOI类库导出Excel
- ASP.NET服务端不装Office 操作Excel NPOI 3
- ASP.NET服务端不装Office 操作Excel NPOI 3
- asp.net 利用NPOI导出数据到Excel模版
- ASP.NET操作Excel(终极方法NPOI)
- ASP.NET使用NPOI类库导出Excel(收藏)
- eclipse 启动tomcat问题
- 利用JOOR简单编写java的反射
- Android AIDL
- java 对比两个属性文件的key
- 扎稳打Silverlight(44) - 4.0浏览器外运行(Out Of Browser)之OOB的增强及其新增的NotificationWindow
- asp.net 调用NPOI 输出Excel
- java抽象类和接口的区别,使用场景
- listview listctrl排序
- Activity之间的数据传递-service与activity之间的数据传递
- 在内核树内增加驱动模块
- Linux 3.3.0移植到S3C6410开发板上之一
- 网络ADB调试方法(最简单实用)
- oracle 行转列,列转行
- Android系统取消自动锁定屏幕