MS Chart - Export to Word not displaying properly in SSIS using C#

Question

4.00/5 (2 votes)

See more:

Hi All,

I am developing an application in SSIS with C# as Code behind. My requirement is to generate MS Charts and save as Word Document in a shared path daily and send the path link as Email to Users on daily basis. Based on Certain data 'n' number of Word document needs to be generated. In each Document again based on data 'n' number of Charts to be pouplated(Bar and Pie Chart). All this should happen on scheduler basis(In my case daily 9PM).

I tried to convert Chart to Byte array and using FileStream writing it to word document. But in word document it is not displaying as chart. Rather displaying as some binary data. I tried saving Chart as Image in local disk and included the path to img src in HTML tag to write in Word document and it is displaying. But If I either remove or rename the file then 'x' red mark is showing but not the image. Saving image separately and using it in Word Document is not right option since there may be huge number of Charts to be generated daily and user wants to keep all the documents for so many months which leads to huge amount of disk space requirement.

C#

using System.IO;
using System.Web.UI.DataVisualization.Charting;

public void Main()
{
Chart CT = new Chart();
CT.Height = 250;
CT.Width = 500;
// And assigned attributes & Data points to the Chart CT.
byte[] byt;
            
MemoryStream imgStream = new MemoryStream();                
CT.SaveImage("D:\\MyChart.png", ChartImageFormat.Png);
CT.SaveImage(imgStream,ChartImageFormat.Png);
byt = imgStream.ToArray();

StringBuilder objLiteral = new StringBuilder();
objLiteral.Append("<html><head><title></title></head><body>");

// The below code block generating Sample.doc with some scrap data(Binary or encrypted data)
using (FileStream fs = File.Create("D:\\Sample.doc")) 
{
byte[] info = new UTF8Encoding(true).GetBytes(objLiteral.ToString());
                    
fs.Write(info, 0, info.Length);
fs.Write(byt, 0, byt.Length);
info = new UTF8Encoding(true).GetBytes("</body></html>");
fs.Write(info, 0, info.Length);
}
fs.flush();

// The below code block generating Sample1.doc with Chart as Image but when MyChart.png is removed or renamed it is not displaying in document also.
using (FileStream fs1 = File.Create("D:\\Sample1.doc"))
{
byte[] info = new UTF8Encoding(true).GetBytes(objLiteral.ToString());
                    
fs1.Write(info, 0, info.Length);
info = new UTF8Encoding(true).GetBytes("<img Src = 'D:\\MyChart.png'></img></body></html>");
fs1.Write(info, 0, info.Length);
}
fs1.flush();
}

Can anybody point me what I am doing wrong. I am not using any dll for Word parsing and is there anything I have to include. If there is any, pls help me how to modify the code after referencing the dll.

Posted 9-Aug-12 17:56pm

allav_arunlml

Updated 13-Aug-12 16:59pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2012-08-09T18:58:00

Add one button for export
Add on page Export.aspx.

in button click

CT.SaveImage("D:\\MyChart.png", ChartImageFormat.Png);
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "Export" + DateTime.Now.ToString(), "<script>window.open('Export.aspx?Image=" +MyChart  + "',target='_blank','toolbar=no,location=no,height=800px,width=900px,resizable=no,scrollbars=no');</script>");

In Export page design

C#

<asp:Panel ID="pnlExport" runat="server" >

 <asp:image id="imgTest" runat="server" xmlns:asp="#unknown" />

In Export page code behind

C#

protected void Page_Load(object sender, EventArgs e)
  {
if (Request.QueryString["Image"] != null
{
imgTest.ImageUrl = Request.QueryString["Image"].Tostring() + ".png";
 Response.Clear(); 
       Response.AddHeader("content-disposition", "attachment; filename=MyChart.doc");
Response.Charset = "";  
Response.ContentType = "application/vnd.ms-word";  
StringWriter sw= new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);   
pnlExport.RenderControl(hw);
  Response.Output.Write(sw.ToString());

 FileInfo fiDelete = new FileInfo(Request.QueryString["Image"].Tostring() + ".png");
        if (fiDelete.Exists)
        {
            fiDelete.Delete();
        }
    Response.Flush();
    Response.End();  

}
}