NPOI vs EPPlus 导出Excel简单对比

1.引用NPOI.dll和EPPlus.dll

http://epplus.codeplex.com/ 

http://npoi.codeplex.com/   ---- 首先应去下载需要引用的dll并引用进项目

2.EPPlus的导出实验

        /// <summary>
        /// EPPlus V4.1 for .NET3.5 24.8万行数据，总用时14秒,EXCEL共6.24MB
        /// </summary>
        protected void ToExcel_epp(DataTable dt)
        {
            using (ExcelPackage package = new ExcelPackage())
            {
                var worksheet = package.Workbook.Worksheets.Add("sheet1");   //创建sheet
                //worksheet.Cells[1, 1, 3, 6].Merge = true;        //合并单元格 worksheet.Cells[int fromRow, fromCol, int toRow,int toCol]
                //worksheet.Cells["A1"].Value = "LOUV数据汇总";  //标题
                worksheet.Cells.Style.Font.Name = "华文细黑";  //字体设置
                worksheet.Cells.Style.Font.Size = 12;
                worksheet.Column(0).Style.Font.Name = "微软雅黑"; //根据列设置样式
                worksheet.Cells.Style.Border.Left.Style = ExcelBorderStyle.Thin;  //边框样式
                worksheet.Cells.Style.Border.Right.Style = ExcelBorderStyle.Thin;
                worksheet.Cells.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
                worksheet.Cells.Style.Border.Top.Style = ExcelBorderStyle.Thin;
                worksheet.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;  //水平对齐方式
                worksheet.Cells.Style.VerticalAlignment = ExcelVerticalAlignment.Bottom;  //垂直对齐方式
                //worksheet.Cells.Style.Fill.BackgroundColor.SetColor(Color.DarkGray);  //背景色
                //worksheet.Cells.Style.Fill.PatternType = ExcelFillStyle.LightUp;