Dynamic Generation of Graph....

[Jawad Rehman]

Hello everybody.....

I have an excel file which is resided on server,there is some data on
the cells .Now i want to
generate dynamic graph on the basis of the data present in the excel
file using ASP.NET.


I have solution of this ,that i should use the Com component
interop.microsoft.excel.but
According to the specifaction of this Com Component.In order to
connect to excel u must have
reference of excel File that u want to manipulate.


this can be easily done by using...


Public oexcel As Excel.Application


oexcel = CreateObject("Excel.Application")


but This will create a reference of excel file of type
excel.application .& its a newly created excel process.
But my problem is that i have an excel file that is resided on
server.And i need a reference of
this excel file of the type Excel.Application.


How i can get reference , plz help me in this regard....

 

[Christopher Ireland]

Hello everybody.....

I have an excel file which is resided on server,there is some data on
the cells .Now i want to
generate dynamic graph on the basis of the data present in the excel
file using ASP.NET.

Please accept the following suggestion.

As a free alternative to using the Excel component, you may consider using
the TeeChart LITE for .NET charting control which is perfectly capably of
displaying the data the Excel chart can display in an ASP.NET page. You can
download TeeChart LITE for .NET here:

http://www.steema.com/downloads/form_tch_net.html

Thank you!

Christopher Ireland
www.steema.com

 

[Mark Rae]

Jawad,

How i can get reference , plz help me in this regard....

I've already answered this question in the ASP.NET newsgroup...

I understand that you don't like the fact that Microsoft strongly advise
against server-side automation of Office through ASP.NET:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

but there's not much I can do about that...

As I've already told you, there are plenty of free charting solutions for
ASP.NET which don't require Office automation...

Mark

 

[Rad [Visual C# MVP]]

Hello everybody.....

I have an excel file which is resided on server,there is some data on
the cells .Now i want to
generate dynamic graph on the basis of the data present in the excel
file using ASP.NET.

I have solution of this ,that i should use the Com component
interop.microsoft.excel.but
According to the specifaction of this Com Component.In order to
connect to excel u must have
reference of excel File that u want to manipulate.

this can be easily done by using...

Public oexcel As Excel.Application

oexcel = CreateObject("Excel.Application")

but This will create a reference of excel file of type
excel.application .& its a newly created excel process.
But my problem is that i have an excel file that is resided on
server.And i need a reference of
this excel file of the type Excel.Application.

How i can get reference , plz help me in this regard....

Server side automation of excel is strongly discouraged. For one thing the
odds or an errant message box being thrown by excel might occur, and said
message box will wait patiently on the server waiting for someone to
click...

There is a number of free and functional components you can use. I can
point you towards the following:
- ZedGraph
- NPot