Looking for suggested architecture of web based app that loads Excel worksheet from database and exposes chart
I'm looking for suggestions on the Visual Studio approach to take for a web application that is in the conceptual stage. 

My environment has a lot of tools:

 - Windows Server 2008 R2 Standard 64bit  
 - Visual Studio 2010 Professional Edition
 - Sharepoint 2010 Server Enterprise Edition
 - SQL Server 2008 R2
 - Office 2010 Professional

I know I will need this app to retrieve data from a database (or a web service - not sure exactly at this point). The data needs to be placed in an Excel workbook dynamically. The app will need to a nice user interface with the normal Excel ribbon and interface completely hidden. Some web control(s) will cause the Excel chart(s) to be rendered.

I am thinking this sounds like Visual Studio Tools for Office (VSTO) so as to leverage .Net and hide Excel. 

Can you offer suggestions regarding:
One ASP.Net Web App Project
One Class Library Project for Excel

Would Excel Services for Sharepoint be useful (or required) ?

I am feeling a little overwhelmed with so many choices at this early stage of conceptualizing the app. Can you suggest some ideas for this sort of thing?




Looking for suggested architecture of web based app that loads Excel worksheet from database and exposes chart
===

I'm looking for suggestions on the Visual Studio approach to take for a web application that is in the conceptual stage. 

My environment has a lot of tools:

 - Windows Server 2008 R2 Standard 64bit  
 - Visual Studio 2010 Professional Edition
 - Sharepoint 2010 Server Enterprise Edition
 - SQL Server 2008 R2
 - Office 2010 Professional

I know I will need this app to retrieve data from a database (or a web service - not sure exactly at this point). The data needs to be placed in an Excel workbook dynamically. The app will need to a nice user interface with the normal Excel ribbon and interface completely hidden. Some web control(s) will cause the Excel chart(s) to be rendered.

I am thinking this sounds like Visual Studio Tools for Office (VSTO) so as to leverage .Net and hide Excel. 

Can you offer suggestions regarding:
One ASP.Net Web App Project
One Class Library Project for Excel

Would Excel Services for Sharepoint be useful (or required) ?

I am feeling a little overwhelmed with so many choices at this early stage of conceptualizing the app. Can you suggest some ideas for this sort of thing?



