（转）NPOI+SharpZipLib实现压缩多个Excel下载

转载自：NPOI+SharpZipLib实现压缩多个Excel下载

 

导出excel是再常见不过的功能，其中NPOI是我一直使用的导出excel的框架。你可以猛击这里了解NPOI，最近有这样一个需求，当我想一次性导出多个excel文件时。我想在内存里面压缩后输出到浏览器进行下载。由此接触到了另外一个框架SharpZipLib，猛击这里了解。demo的代码贴在这里，以备后面查阅。

using System;
using System.IO;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using NPOI.SS.UserModel;

using ICSharpCode.SharpZipLib.Zip;

namespace NpoiAndZip
{
    public partial class ExportDownloadExcel : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }

        protected void btnOK_Click(object sender, EventArgs e)
        {
            string filename = "test.zip";
            Response.ContentType = "application/zip";
            Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", filename));
            Response.Clear();

            InitializeWorkbook();
            GenerateData();
            MemoryStream ms1 = new MemoryStream();
            MemoryStream ms2=new MemoryStream();
            MemoryStream ms3=new MemoryStream();
            ms1 = WriteToStream(hssfworkbook);
            ms2 = WriteToStream(hssfworkbook2);
            ms3 = WriteToStream(hssfworkbook3);
            MemoryStream st = new MemoryStream();
            using (ZipFile zip = ZipFile.Create(st))
            {
                zip.BeginUpdate();
                StreamDataSource d1=new StreamDataSource(ms1);
                StreamDataSource d2 = new StreamDataSource(ms2);
                StreamDataSource d3 = new StreamDataSource(ms3);
                //添加文件
                zip.Add(d1, "test1.xls");
                zip.Add(d2, "test2.xls");
                zip.Add(d3, "test3.xls");
                zip.CommitUpdate();
            }
            Response.BinaryWrite(st.GetBuffer());
            Response.End();
        }

        HSSFWorkbook hssfworkbook;
        HSSFWorkbook hssfworkbook2;
        HSSFWorkbook hssfworkbook3;
        MemoryStream WriteToStream(HSSFWorkbook workbook)
        {
            //Write the stream data of workbook to the root directory
            MemoryStream file = new MemoryStream();
            workbook.Write(file);
            return file;
        }

        void GenerateData()
        {
            ISheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
            ISheet sheet2 = hssfworkbook2.CreateSheet("Sheet1");
            ISheet sheet3 = hssfworkbook3.CreateSheet("Sheet1");
            sheet1.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample");
            sheet2.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample");
            sheet3.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++);
                }
            }
            for (int i = 1; i <= 15; i++)
            {
                IRow row = sheet2.CreateRow(i);
                for (int j = 0; j < 15; j++)
                {
                    row.CreateCell(j).SetCellValue(x++);
                }
            }
            for (int i = 1; i <= 15; i++)
            {
                IRow row = sheet3.CreateRow(i);
                for (int j = 0; j < 15; j++)
                {
                    row.CreateCell(j).SetCellValue(x++);
                }
            }
        }

        void InitializeWorkbook()
        {
            hssfworkbook = new HSSFWorkbook();
            hssfworkbook2 = new HSSFWorkbook();
            hssfworkbook3 = 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;

            ////create a entry of DocumentSummaryInformation
            DocumentSummaryInformation dsi2 = PropertySetFactory.CreateDocumentSummaryInformation();
            dsi2.Company = "NPOI Team";
            hssfworkbook2.DocumentSummaryInformation = dsi2;

            ////create a entry of SummaryInformation
            SummaryInformation si2 = PropertySetFactory.CreateSummaryInformation();
            si2.Subject = "NPOI SDK Example";
            hssfworkbook2.SummaryInformation = si2;

            ////create a entry of DocumentSummaryInformation
            DocumentSummaryInformation dsi3 = PropertySetFactory.CreateDocumentSummaryInformation();
            dsi3.Company = "NPOI Team";
            hssfworkbook3.DocumentSummaryInformation = dsi3;

            ////create a entry of SummaryInformation
            SummaryInformation si3 = PropertySetFactory.CreateSummaryInformation();
            si3.Subject = "NPOI SDK Example";
            hssfworkbook3.SummaryInformation = si3;
        }
    }

    //只有实现IStaticDataSource接口才能实现流操作
    class StreamDataSource : IStaticDataSource
    {
        public byte[] bytes { get; set; }
        public StreamDataSource(MemoryStream ms)
        {
            bytes = ms.GetBuffer();
        }

        public Stream GetSource()
        {
            Stream s = new MemoryStream(bytes);
            return s;
        }
    }
}

谢谢浏览！