Loading Reporting Services EXCEL or HTML4.0 output

How do I load the 'EXCEL' or 'HTML4.0' output from a Reporting Services ServerReport.Render call to an 'Excel.Application' object using Javascript?
[177 byte] By [BrinkSr] at [2007-11-20 11:12:58]
# 1 Re: Loading Reporting Services EXCEL or HTML4.0 output
Can you explain yourself more clearly? What exactly are you attempting?

Remember that JavaScript is a client-side scripting language. It can invoke an ActiveX object to interface with Excel, but that is limited, and IE only.
PeejAvery at 2007-11-8 0:43:15 >
# 2 Re: Loading Reporting Services EXCEL or HTML4.0 output
I have an ASP .Net page that uses a Reporting Services ReportViewer object to generate a report file server-side. The resulting HTML fragment is stored to a div. I then need to display the resultant report using an 'Excel.Application' object using client-side Javascript in an 'onload' or 'onclick' function. I can create the report and Excel.Application object (fluent in C#, Javascript, VBScript, VB, etc) ... I just don't know how to load the report HTML (basically a <TABLE> with embedded <TABLE> elements) to the Excel.Workbooks object without creating a temporary file. The Microsoft documentation is not the greatest in the world.

I just need to know if it is possible and if so, how to do it. If it's not possible ... then on to Plan B
BrinkSr at 2007-11-8 0:44:12 >
# 3 Re: Loading Reporting Services EXCEL or HTML4.0 output
Note that because you are using ActiveX, you are limiting yourself to IE only.

Take a look at the following links...

[JavaScript] http://www.webreference.com/js/column55/performance.html
[VBScript] http://www.greggriffiths.org/webdev/both/excel/activex.html
PeejAvery at 2007-11-8 0:45:11 >
# 4 Re: Loading Reporting Services EXCEL or HTML4.0 output
I appreciate your reply, but the references do not have anything to do with my question ... is it posible to load an HTML (or XML for that matter) text string to an Excel.Workbooks object without using a temporary file, and if so ... how?
BrinkSr at 2007-11-8 0:46:16 >
# 5 Re: Loading Reporting Services EXCEL or HTML4.0 output
I appreciate your reply, but the references do not have anything to do with my question
Yes, they do.

is it posible to load an HTML (or XML for that matter) text string to an Excel.Workbooks object without using a temporary file, and if so ... how?
The links show you how you use JavaScript or VBScript to alter the values of workbooks.
PeejAvery at 2007-11-8 0:47:18 >
# 6 Re: Loading Reporting Services EXCEL or HTML4.0 output
NO ... they don't. Read the question ... and by the way I found the answer myself with deeper research ... Excel.Workbook.XmlLoadXml can be used to load XML data to the workbook from a string. Which is one of the formats that ReportServer.Render will output. Thanks anyway.
BrinkSr at 2007-11-8 0:48:23 >