Is it possible to use MS Excel library capabilities in ASP.NET? Excel has such a powerful charting engine and I wish I could program like VBA from ASP.NET and use the chart/graph feature.
Well.. I completely understand those articles. I have done a lot of VBA with VB and C# but always in stand-alone applications.
My question was related to integrating an excel chart in a website as a component. You must have seen chart controls provided by Terelink, .netCharting and other 3rd party libraries. Can excel chart be used like this?
There is something like
Office Web Components available to download in Microsoft website. I'm not very sure if it is the package you need, but description looked promising to me.
Don't forget to mark solution providing post as "Answered".
With OWC one can achieve highly interactive functionality but from what I have read in its licensing section, every client must have a valid office license to run it in interactive mode.
By interactive mode, I mean showing custom tooltips and handling events on server-side. So I think it makes it a good fit in Intranet deployments where you have control over software packages running on clients. By default it renders in non-interactive mode
(image) on Internet clients.
If my understanding is correct, it is not meant for SOA type systems which are getting more popular every day.
Well.. I completely understand those articles. I have done a lot of VBA with VB and C# but always in stand-alone applications.
My question was related to integrating an excel chart in a website as a component. You must have seen chart controls provided by Terelink, .netCharting and other 3rd party libraries. Can excel chart be used like this?
If you want to use Excel charts - I mean chart objects from Excel - you have to install MS Office to your server and handle Excel files through code. I'm thinking about converting those Excel files to CSV and useing CSV data as source for ASP.NET charting components.
Of course, you can store this data also to SQL Server and use Reporting Services. Version 2008 enables you to make professional looking reports pretty fast.
Don't forget to mark solution providing post as "Answered".
Member
217 Points
243 Posts
Use excel capabilities in ASP.NET
Apr 11, 2008 06:24 PM|mthakershi|LINK
Hello everyone,
Is it possible to use MS Excel library capabilities in ASP.NET? Excel has such a powerful charting engine and I wish I could program like VBA from ASP.NET and use the chart/graph feature.
Is it possible?
Thank you for your help.
excel asp.neet 2.0
Member
693 Points
840 Posts
Re: Use excel capabilities in ASP.NET
Apr 13, 2008 10:31 AM|Dollarjunkie|LINK
http://support.microsoft.com/kb/302084
http://support.microsoft.com/kb/308247
http://www.eggheadcafe.com/articles/20021012.asp
Member
217 Points
243 Posts
Re: Use excel capabilities in ASP.NET
Apr 14, 2008 12:01 PM|mthakershi|LINK
Hi,
Well.. I completely understand those articles. I have done a lot of VBA with VB and C# but always in stand-alone applications.
My question was related to integrating an excel chart in a website as a component. You must have seen chart controls provided by Terelink, .netCharting and other 3rd party libraries. Can excel chart be used like this?
Thank you for your help.
Contributor
4020 Points
998 Posts
MVP
Re: Use excel capabilities in ASP.NET
Apr 14, 2008 05:54 PM|DigiMortal|LINK
Also visit my ASP.NET blog or follow me @ Twitter:twitter.com/gpeipman
Member
217 Points
243 Posts
Re: Use excel capabilities in ASP.NET
Apr 14, 2008 11:57 PM|mthakershi|LINK
With OWC one can achieve highly interactive functionality but from what I have read in its licensing section, every client must have a valid office license to run it in interactive mode.
By interactive mode, I mean showing custom tooltips and handling events on server-side. So I think it makes it a good fit in Intranet deployments where you have control over software packages running on clients. By default it renders in non-interactive mode (image) on Internet clients.
If my understanding is correct, it is not meant for SOA type systems which are getting more popular every day.
Thank you.
Member
693 Points
840 Posts
Re: Use excel capabilities in ASP.NET
Apr 15, 2008 01:57 AM|Dollarjunkie|LINK
I believe it is possible to do so .
Contributor
4020 Points
998 Posts
MVP
Re: Use excel capabilities in ASP.NET
Apr 15, 2008 12:44 PM|DigiMortal|LINK
Also visit my ASP.NET blog or follow me @ Twitter:twitter.com/gpeipman