excel.chart.export fails in web app but works in windows app 1

[MuadDubby]

I've got a wierd problem with excel.chart.export (which just saves the image of the chart to a JPG or GIF).

I have a library that creates the excel file and chart, and two projects that use the library: a windows app (just a form, really) and a web app. Both projects use the library, and the method that creates the chart pases back the excel.chart object to the caller.

In the windows app case, if I do this

Excel.chart ExcelChart;
ExcelObj.MakeChart (ref ExcelChart); //ExcelObj is an object of the library class
ExcelChart.Export (@"c:\temp\charttest.gif", "GIF", true);

There's no problem, and the gif file is created.

If do the exact same thing from the web app, though, I get an exception with the error of "Exception from HRESULT: 0x800A03EC."

Moreover, the third parameter to .Export is supposed to show a dialog box with the available filters in my registry. Neither true or false setting (in this param) shows me the dialog.

Any ideas? Someone had posted something similar back in 2005 and got no answers. I'm hoping for better luck this time around

Thx,

 

[MuadDubby]

Ok, found the answer myself. The problem is with the Excel controls; they're not meant to be used on the web.

If you need to show spreadsheets and charts on a web page, use the Office Web Components (OWC).

Here a sample article on how to use OWC:

http://aspnet.4guysfromrolla.com/articles/080603-1.2.aspx

Have fun!

 

[misterstick]

1. very seldom do people post their solutions if they find them themselves.
2. useful to know howsoever.

many thanks, have a star.


mr s. <

 

[MuadDubby]

It's the least I could do. I've received a lot of help from users on this site. If I get a chance to reciprocate, why wouldn't I?

And thx for the star