如何在Excel文件中导出图像 [英] How do I export Image in Excel file

问题描述

嗨朋友们，



我正在尝试生成并下载应该包含图像的.xls文件。我能够生成并下载文件，并且所有文本都是正确的但是图像没有出现。

我使用的是来自网络的图片网址，这仅供参考。

下面是我的代码。请引导我知道我缺少或错误的地方。

Hi Friends,

I am trying to generate and download the .xls file that should include the image. I am able to generate and download the file and all the text is proper but Image is not appearing.
I am using the image url from web this is for example only.
Below is my code. Please guide me to know where I am lacking or putting wrong.

System.Net.HttpWebRequest req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create("http://www.floristdex.com/images/flowers/alstroemeria.jpg");
            System.Net.HttpWebResponse res = (System.Net.HttpWebResponse)req.GetResponse();
            Stream stream = res.GetResponseStream();
            byte[] buffer = new byte[16*1024];
            using (var streamReader = new MemoryStream())
            {
                stream.CopyTo(streamReader);
                buffer = streamReader.ToArray();
            }

            MemoryStream mss = new MemoryStream(buffer);
            System.Drawing.Image mgg = System.Drawing.Image.FromStream(mss);

            System.Text.StringBuilder strBuilder = new System.Text.StringBuilder();
            strBuilder.Append(@"<table id=""exportToExcel"" runat=""server"" style=""width:100%;""><tr><td>");
            //strBuilder.Append(@"<img id=""Image1"" src=""http://www.floristdex.com/images/flowers/alstroemeria.jpg""  runat=""server""/>");
            strBuilder.Append(mgg);
            strBuilder.Append(@"</td><td>Hello</td></tr><tr><td>hi</td><td>Hello</td></tr></table>");

            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition","attachment; filename=ExcelFile.xls");
            Response.ContentType = "application/vnd.ms-excel";
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.Write(strBuilder);
            Response.End();

谢谢：）

Thanks :)

推荐答案

这篇关于如何在Excel文件中导出图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！