display excel graph or certain sheet

A

asdf

Hello
Is there a way to connect to an excel file and just display a certain chart
or graph or sheet?
I can make a link to the excel and open the whole thing, but it would be
nice to just open one sheet. I can copy and paste a graph onto frontpage and
update the webpage every week, but I just thought it would be nicer if people
can always see the current data and I don't feel like updating it like that.
Does anyone have a suggestion?
Thank you.
 
K

Kevin Spencer

The solution would probably be more painful in the short run. You would need
to use ASP.Net with VSTO (Visual Studio Tools for Office) to create a
server-side application that opens the Spreadsheet and dynamically creates a
new Spreadsheet from one of the sheets in it, passing that back to the
client browser when a particular ASP.Net Page URL was requested. It is not a
trivial exercise, even for an experienced ASP.Net programmer.

--
HTH,

Kevin Spencer
Microsoft MVP

DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top