chart missing when exporting to the excel

[kurkure]

Hi

[TomasT]

Hi,

Chart FX FX does not have a built-in feature to export charts to excel.

Can you please provide some details? Are you exporting as bitmap or a metafile and simply adding that image to an excel sheet?

 Thanks,

 TT

[shane2004]

I used this to export as excel format, HTH private void ExportToExcel(string strFileName, DataView dv)

{

Response.ClearContent();

Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);

Response.ContentType =

"application/excel";System.IO.StringWriter sw = new System.IO.StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

//Instantiate a datagridSystem.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();

dg.DataSource = dv;

dg.DataBind();

//Tell the datagrid to render itself to htmltextwriter

dg.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

[TomasT]

Hi,

 Thanks for the additional info. Unfortunately, I don't believe this approach will work with Chart FX.

While the DataGrid Control ultimately renders as an HTML table, the generated charts are basically images. The RenderControl call for the chart object returns the HTML that refers to an image on the server.

You may want to work with the Office libraries instead in order to create a new Excel file with an embedded image. I found some information on line that may be of help:

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_insert_picture.htm 

regards,

TT