My company has had good results using the ExcelAccessor bean with KavaChart
to generate the chart. Have you tried that combination?
----- Original Message -----
From: Alvin Lau <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 6:29 PM
Subject: for those who are interested in making a excel file
> I c a lot of people in this list are interested in building an excel file
> with java, so let share my experience.
>
> as far as i know, there are 2 packages in java that can generate excel
file.
>
> 1st one is ExcelAccessor bean from IBM's Alphaworks site
> ExcelAccessor cannot generate any chart, so i didn't tried it
>
> 2nd one is Forumla one.
> Formula one version 7 is a very good package as long as you don't need to
> plot a chat..... It only provides two functions (i should say one because
> both of these functions are used to set the range of the chart), to plot a
> chart. If you want to plot a chart with more than 1 set of data with each
> set has its own x and y values programmatically (without excel marco), it
is
> just not possible (tell me if i'm wrong, i'm trying to solve this problem
> for 20 hrs now). I made a call yesterday, they said they will have a
better
> verion later on this year.....
>
> poor me, i'm thinking to give this up and use asp instead.....
>
>
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
API
> Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Alvin Lau
> Sent: Thursday, July 06, 2000 1:45 PM
> To: [EMAIL PROTECTED]
> Subject: Re: excel file---formula one
>
>
> if u only need a chart, you can use kavachart (www.ve.com they have some
> nice example to show how to generate a chart on fly.). I use formula one
> because my customer requested a excel report (including some tables and
> chart).
>
> if you need my src code, i can send it to do.......
>
> the problem i'm having now is that i know know hoe to set the x-label.....
>
> alvin
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
API
> Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Ritu Kama
> Sent: Thursday, July 06, 2000 12:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: excel file---formula one
>
>
> Hi,
> I am not using Formula one right now but in my project, I will also be
> required to do reports and then plot charts on the fly. can you tell me
how
> you used formula one in your program?
> thanks in advance.
> bye
> ritu
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Alvin
> Lau
> Sent: Thursday, July 06, 2000 3:32 PM
> To: [EMAIL PROTECTED]
> Subject: excel file---forumla one
>
>
> hi,
>
> I'm using formula one for java to generate a excel report on fly in a
> servlet. I'm having trouble with plotting a chart. And i would like to
know
> is there anyone here in this list did the same thing or used forumla one
> before?
>
> alvin
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
