将数据库二进制图片导出显示到EPPlus Excel2007中

2013-09-11 11:19 Evan.Pei 阅读(1479) 评论(0) 编辑收藏举报

1.EPPlus Excel 控件可以参考我的另一篇博客：http://blog.163.com/pei_huiping/blog/static/206573067201281810549984/

这里我主要记录将二进制图片从数据库取出来，然后显示到Excel中。

//导出Excel
        protected void Button3_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=192.168.10.58; Initial Catalog=saveImagesDB; user ID=sa; password=123; pooling=true;";
            string sql = "select imageobj from T_image where id=" + txt_id.Value;
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand com = new SqlCommand();
            com.Connection = conn;
            com.CommandType = CommandType.Text;
            com.CommandText = sql;
            conn.Open();
            SqlDataReader dr = com.ExecuteReader();
            byte[] bytes = null;
            if (dr.Read())
            {
                bytes = (byte[])dr["imageobj"];
            }
            dr.Close();
            conn.Close();
            System.IO.MemoryStream ms = new System.IO.MemoryStream(bytes);
            System.Drawing.Bitmap myimge = new System.Drawing.Bitmap(ms);
            //this.Response.BinaryWrite(bytes);//打印到页面上
 
            OfficeOpenXml.ExcelPackage ep = new OfficeOpenXml.ExcelPackage();
            OfficeOpenXml.ExcelWorkbook wb = ep.Workbook;
            OfficeOpenXml.ExcelWorksheet ws = wb.Worksheets.Add("我的工作表");
            ws.Drawings.AddPicture("", myimge);
           // ws.Cells[1, 1].Value = pic;
            //写到客户端（下载）
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;  filename=FileFlow.xls");
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            Response.BinaryWrite(ep.GetAsByteArray());
            //ep.SaveAs(Response.OutputStream);    第二种方式
            Response.Flush();
            Response.End();
 
        }