<div>
Further research suggests that this is not possible:<br />
<br />
<a href="http://www.eggheadcafe.com/aspnet_answers/officedeveloperwebcomponents/Aug2006/post27684322.asp" rel="ugc">http://www.eggheadcafe.com/aspnet_answers/officedeveloperwebcomponents/Aug2006/post27684322.asp</a><br />
<br />
The OWC cannot open XLS files, neither can it open Excel XML files as the file structure is different.
</div>


Further research suggests that this is not possible:

http://www.eggheadcafe.com/aspnet_answers/officedeveloperwebcomponents/Aug2006/post27684322.asp [http://www.eggheadcafe.com/aspnet_answers/officedeveloperwebcomponents/Aug2006/post27684322.asp]

The OWC cannot open XLS files, neither can it open Excel XML files as the file structure is different.

<div>
<div class="content wysiwyg-content">
We have a classic database reporting setup with SQL Server 2005, ASP .net 2 and IE 6. The reports produced are highly customised and do not neatly fall into datagrid style layouts. Additionally the reports have already been developed to use an excel pivottable embedded in the report to select and layout the data (using GETPIVOTDATA).<br />
<br />
We want to make it possible for a user to be able to select a number of parameters from a webpage to filter the data in the report and then make the report available for download.<br />
<br />
Can the Office Web Component (OWC) be used to load a copy of the excel template and refresh the pivottable against a stored procedure in SQL? <br />
<br />
This works using Excel Automation, however Excel cannot be installed on the webserver; the Office Web Component (OWC) is available. Version 10 is currently installed, although 11 could be installed if necessary.<br />
<br />

</div>
</div>


We have a classic database reporting setup with SQL Server 2005, ASP .net 2 and IE 6. The reports produced are highly customised and do not neatly fall into datagrid style layouts. Additionally the reports have already been developed to use an excel pivottable embedded in the report to select and layout the data (using GETPIVOTDATA).

We want to make it possible for a user to be able to select a number of parameters from a webpage to filter the data in the report and then make the report available for download.

Can the Office Web Component (OWC) be used to load a copy of the excel template and refresh the pivottable against a stored procedure in SQL? 

This works using Excel Automation, however Excel cannot be installed on the webserver; the Office Web Component (OWC) is available. Version 10 is currently installed, although 11 could be installed if necessary.



How can I load an xls file and refresh a pivottable using OWC?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).