Exporting Chart OWC to Excel

[Brian Hman]

I have a ASP.NET web page that has a Chart and a Spreadsheet web components
embedded in it. The spreadsheet is the source for the chart. I can export the
spreadsheet data to excel, but I'd like to be able to export the chart with
that data.
I don't think this is possible because if it were MS would put an Export to
Excel button on the chart OWC's toolbar.

But I still wanted to ask if this is possible. If it isn't, do you have any
suggestions on how I might do this another way?

Thanks,
Brian Hman

 

[Kevin Yu [MSFT]]

Hi Brian,

We have reviewed this issue and are currently researching on it. We will
update you ASAP. Thanks for your patience!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Wei-Dong XU [MSFT]]

Hi Brian,

For exporting the data into Excel, currently we will need to use script
code (VBscript /JScript/javascript) in the html page to export the data to
excel or write one activex component for this.

The 1st method is to use script code calling the Excel to draw the chart
based on the data from SpreadSheet.
'------------------------------------------------

Quick Chart VBA Examples
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

http://lab.msdn.microsoft.com/productfeedback/

Please feel free to let me know if you have any further question on this
matter.

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
It is my pleasure to be of assistance.

 

[Wei-Dong XU [MSFT]]

Hi Brian,

For exporting the data into Excel, currently we will need to use script
code (VBscript /JScript/javascript) in the html page to export the data to
excel or write one activex component for this.

The 1st method is to use script code calling the Excel to draw the chart
based on the data from SpreadSheet.
'------------------------------------------------
var app = new ActiveXObject("Excel.Application");
app.Visible = true;
var wbk = app.Workbooks.Add();
wbk.Charts.Add();
'------------------------------------------------
The script code above instantiates one Excel workbook and create one chart.
Then we could use the Excel object model to create chart. This site
introduces very detailed steps on how to create Excel chart in VBA.
Quick Chart VBA Examples
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

This method has one very serious user-experience issue that IE will pop up
one security alert on the ActiveX control execution. So we could use the
2nd method to write one ActiveX component and then register it as safe in
IE (we could implement the security interface in this custom activex
component then IE will not pop up security alert). However, this will evlve
the C++/COM development and require more time on the test; the client will
also need to install this ActiveX component. For better performance and
user experience, this is the best resolution.

Furthermore, since current OWC chart version doesn't provide the exporting
to Excel functionality. I'd suggest you could post one feedback on the
feature request at this site. Your suggestion will be considered by product
team and may be included into the next version OWC. Thanks a lot!
http://lab.msdn.microsoft.com/productfeedback/

Please feel free to let me know if any further question on this matter.

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
It is my pleasure to be of assistance.