You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ryan Ackley <sa...@cfl.rr.com> on 2004/05/19 15:31:13 UTC
Re: POI Excel Efficiency related
Darn! I joined the wrong project :-)
-Ryan
----- Original Message -----
From: "Koundinya (Sudhakar Chavali)" <su...@yahoo.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Wednesday, May 19, 2004 3:47 AM
Subject: POI Excel Efficiency related
> Hi All,
>
> When I have tested the POI and JExcelAPI which are both open
> standards, I have identified that JExcelAPI is much better than
> POI's HSSF
>
> The Reasons are
> 1. it can handle formulae
> 2. It parses much faster than the HSSF
>
> 1.2 MB filew took 9 seconds form using POI whereas it took only
> 4.7 seconds using JEXCELAPI.
>
> Jexcel API source I have found from
> http://www.andykhan.com/jexcelapi/index.html
>
> Regards
> Sudhakar
>
> =====
> "No one can earn a million dollars honestly."- William Jennings Bryan
(1860-1925)
>
> "Make everything as simple as possible, but not simpler."- Albert Einstein
(1879-1955)
>
> "It is dangerous to be sincere unless you are also stupid."- George
Bernard Shaw (1856-1950)
>
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! - Internet access at a great low price.
> http://promo.yahoo.com/sbc/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI Excel Efficiency related
Posted by Koen Pelsmaekers <ko...@groept.be>.
Well, the problem is a kind of problem as noted in the documentation of the
formulas for HFFS-poi:
[We would therefore like you to report any occurence of #VALUE! in a cell
upon opening a POI generated workbook in excel. (Check that typing the
formula into Excel directly gives a valid result.) ]
This is the formula that gives the problem:
=IF(COUNTBLANK(G11:I11)=0;SUMPRODUCT(G11:I11;$G$10:$I$10)/SUM($G$10:$I$10);"")
Once "edited" in Excel (without changing anything) it gives the correct
result (a calculated number if none of the cells G11:I11 are blank; blank
if one of these cells is blank).
Koen.
At 15:31 19/05/2004, you wrote:
>Darn! I joined the wrong project :-)
>
>-Ryan
>
>----- Original Message -----
>From: "Koundinya (Sudhakar Chavali)" <su...@yahoo.com>
>To: "POI Users List" <po...@jakarta.apache.org>
>Sent: Wednesday, May 19, 2004 3:47 AM
>Subject: POI Excel Efficiency related
>
>
> > Hi All,
> >
> > When I have tested the POI and JExcelAPI which are both open
> > standards, I have identified that JExcelAPI is much better than
> > POI's HSSF
> >
> > The Reasons are
> > 1. it can handle formulae
> > 2. It parses much faster than the HSSF
> >
> > 1.2 MB filew took 9 seconds form using POI whereas it took only
> > 4.7 seconds using JEXCELAPI.
> >
> > Jexcel API source I have found from
> > http://www.andykhan.com/jexcelapi/index.html
> >
> > Regards
> > Sudhakar
> >
> > =====
> > "No one can earn a million dollars honestly."- William Jennings Bryan
>(1860-1925)
> >
> > "Make everything as simple as possible, but not simpler."- Albert Einstein
>(1879-1955)
> >
> > "It is dangerous to be sincere unless you are also stupid."- George
>Bernard Shaw (1856-1950)
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! - Internet access at a great low price.
> > http://promo.yahoo.com/sbc/
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>---
>[This E-mail scanned for viruses by Declude Virus]
---
[This E-mail scanned for viruses by Declude Virus]
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org