Hey!
>poor me, i'm thinking to give this up and use asp instead.....
Yes, poor you. If your customer's requirements include Excel
you are better off staying with Microsoft. It reads like you
prefer VB anyway. Now there's a 'language' I dare not even
comment about. :>)
Once you put Excel into you app. you are stuck with
Windows and Intel.
I tried Excel and it made our apps so unstable
that I had to pull it out. BTW, AlphaWorks dropped
the "ExcelAccessor" bean. It would be nice to know why.
Could it be the above.
I suggest that you solve this requirement using Java.
BTW, this is a SERVLET-INTEREST list not VB.
Please don't be offended by these comments.
Sans adieu,
Danny Rubis
Alvin Lau wrote:
> 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
