Can someone help me get started the following?

I would like to call Excel on the server side from ASP, send it some data 

to chart, produce a chart on the server side (of some given size) save it 

as a .jpg file (or .gif) and then present it to the user via the client 

browser.  I need a small example of how to do this.



I am aware that this isn't scalable but I am prototyping to get a general 

feel of the overall flow.  I don't want any Java, ActiveX or Flash to do 

the charting on the client side as I want the final application to be as 

broadly useable as possible.



Thanks,

Gary

Hi



You can use AspImage Component or any third party tool like Dundas Charts

or FX Charts to make charts.



Regards,

Salman Mustafa



email: smustafa@a...

Can someone help me get started the following?

I would like to call Excel on the server side from ASP, send it some data

to chart, produce a chart on the server side (of some given size) save it

as a .jpg file (or .gif) and then present it to the user via the client

browser.  I need a small example of how to do this.



I am aware that this isn't scalable but I am prototyping to get a general

feel of the overall flow.  I don't want any Java, ActiveX or Flash to do

the charting on the client side as I want the final application to be as

broadly useable as possible.



Thanks,

Gary

Salman:



A question about ASPImage. A few months ago I tried to see an a example of 

just what "allows you to create images on the fly" means. Every site 

related to ASPImage either quoted that or sent me to an example page that 

wasn't working. Do you know of any site where I can see more of what 

ASPImage does, how it does it, and how efficient it is. 



Thanks,



Joe M.



> Hi

> 

> You can use AspImage Component or any third party tool like Dundas Charts

> or FX Charts to make charts.

> 

> Regards,

> Salman Mustafa

> 

> email: smustafa@a...

> Can someone help me get started the following?

> I would like to call Excel on the server side from ASP, send it some data

> to chart, produce a chart on the server side (of some given size) save it

> as a .jpg file (or .gif) and then present it to the user via the client

> browser.  I need a small example of how to do this.

> 

> I am aware that this isn't scalable but I am prototyping to get a general

> feel of the overall flow.  I don't want any Java, ActiveX or Flash to do

> the charting on the client side as I want the final application to be as

> broadly useable as possible.

> 

> Thanks,

> Gary

> 

> 

Yes.  Thanks to all for the variety of solutions but NOT what I am looking 

for.  The other solutions are either too expensive or activex driven.



Let me restate:  Is it possible to invoke excel from vb through ASP, pass 

data, produce a chart, save it to the server side and then display it as a 

jpg or png or gif?

thanks.









> Can someone help me get started the following?

> I would like to call Excel on the server side from ASP, send it some 

data 

> to chart, produce a chart on the server side (of some given size) save 

it 

> as a .jpg file (or .gif) and then present it to the user via the client 

> browser.  I need a small example of how to do this.

> 

> I am aware that this isn't scalable but I am prototyping to get a 

general 

> feel of the overall flow.  I don't want any Java, ActiveX or Flash to do 

> the charting on the client side as I want the final application to be as 

> broadly useable as possible.

> 

> Thanks,

> Gary

> 

OK after a quick scan of the help file for excel it seems that it is

possible to create a chart from VBA in Excel. based on this you could create

a VB component that can create the chart for you or you could do it all in

the page. The first option is the better of the two. The problem as I see it

is going to be getting the chart from excel to a image file format. Unless

anyone else has any suggestions, you would need a 3rd party component to

create the image file. Such a component may not exist.



The reason people are suggesting not-Excel solutions is that it is a better

solution in almost all cases. Unless you had a special reason for wanting

the result in excel, then there is no reason to use Excel. If the end

solution is solely to produce a chart, then the third party components are

definitely better. If you were to use excel you would not even be saving on

the price of the component as you would need the 3rd party component.



As for making the final application as usable as possible, you are making it

less usable by using Excel. Better to have one dll that must be installed on

the server than a whole app.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Gary Marcos [mailto:gary_marcos@y...]

Sent: Friday, 14 September 2001 1:34 PM

To: ASP Databases

Subject: [asp_databases] Re: ASP, VB, Excel





Yes.  Thanks to all for the variety of solutions but NOT what I am looking 

for.  The other solutions are either too expensive or activex driven.



Let me restate:  Is it possible to invoke excel from vb through ASP, pass 

data, produce a chart, save it to the server side and then display it as a 

jpg or png or gif?

thanks.

Please see www.serverobjects.com





Regards,

Salman Mustafa



email: smustafa@a...

Yes, you can. There a many examples on some of the ASP sites. However, this

is going to be *VERY* resource intensive on the Server. --Every-- request

will invoke an instance of Excel on the server thereby eating up resources.



-- Tomm



> -----Original Message-----

> From: Gary Marcos [mailto:gary_marcos@y...]

> Sent: Friday, September 14, 2001 3:34 AM

> To: ASP Databases

> Subject: [asp_databases] Re: ASP, VB, Excel

>

>

> Yes.  Thanks to all for the variety of solutions but NOT what I

> am looking

> for.  The other solutions are either too expensive or activex driven.

>

> Let me restate:  Is it possible to invoke excel from vb through ASP, pass

> data, produce a chart, save it to the server side and then

> display it as a

> jpg or png or gif?

> thanks.

>

>

>

>

> > Can someone help me get started the following?

> > I would like to call Excel on the server side from ASP, send it some

> data

> > to chart, produce a chart on the server side (of some given size) save

> it

> > as a .jpg file (or .gif) and then present it to the user via the client

> > browser.  I need a small example of how to do this.

> >

> > I am aware that this isn't scalable but I am prototyping to get a

> general

> > feel of the overall flow.  I don't want any Java, ActiveX or

> Flash to do

> > the charting on the client side as I want the final application

> to be as

> > broadly useable as possible.

> >

> > Thanks,

> > Gary