Formula one ver 8.0 beta is out. :-> the charting API is improved a lot.
Finally I can go futher with my project :->
alvin
-----Original Message-----
From: Bing Zhang [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 08, 2000 9:00 AM
To: 'Alvin Lau '
Subject: RE: for those who are interested in making a excel file
I heard that Formula One charges a lot. Have you ever tried Spread?
Bing
-----Original Message-----
From: Alvin Lau
To: [EMAIL PROTECTED]
Sent: 7/7/00 5: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
