You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Marx, Stefan ext. MA Fa. Lynx" <St...@rewe.de> on 2005/06/21 15:17:10 UTC
Best practice guide or something similar availible?
Hi List,
while dealing with POI/HSSF for several weeks in a quite big pro-
ject at my customer site we encountered some difficulties (aka
out-of-memory exceptions) in the areas of formatting huge lists and
and juggling with fancy formatting (many fonts). And I know of
cause that the *very* clear reason for this is the ultimative
broken BIFF format in Excel 97.
Before we make an other pace towards more POI programming to gene-
rate sophisticated template: Is there a kind of best practise guide
or other hints what to do (and much more) to avoid in composing
sheets and generate them programmatically with HSSF?
The reason is obvious - I don't want to design yummy sheets with
niffy features and run into trouble afterwards while implementing
that stuff.
Any hint is warmly welcome ;=).
THX && many greetings,
Stefan
P.S.: Sorry for the double posting! This mail client allows blank
subject in the SMTP envelope ...
--
Tel: +49-221-149-5953
Fax: +49-221-149-97-5953
E-Mail: Stefan.Marxext.MAFa.Lynx >at< rewe.de
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Best practice guide or something similar availible?
Posted by Avik Sengupta <av...@itellix.com>.
1. Reuse your styles and formats
2. Strings take more memory than numbers
3. Test ... test... test!
On Tue, 2005-06-21 at 15:17 +0200, Marx, Stefan ext. MA Fa. Lynx wrote:
> Hi List,
>
> while dealing with POI/HSSF for several weeks in a quite big pro-
> ject at my customer site we encountered some difficulties (aka
> out-of-memory exceptions) in the areas of formatting huge lists and
> and juggling with fancy formatting (many fonts). And I know of
> cause that the *very* clear reason for this is the ultimative
> broken BIFF format in Excel 97.
>
> Before we make an other pace towards more POI programming to gene-
> rate sophisticated template: Is there a kind of best practise guide
> or other hints what to do (and much more) to avoid in composing
> sheets and generate them programmatically with HSSF?
>
> The reason is obvious - I don't want to design yummy sheets with
> niffy features and run into trouble afterwards while implementing
> that stuff.
>
> Any hint is warmly welcome ;=).
>
> THX && many greetings,
>
> Stefan
>
> P.S.: Sorry for the double posting! This mail client allows blank
> subject in the SMTP envelope ...
> --
> Tel: +49-221-149-5953
> Fax: +49-221-149-97-5953
> E-Mail: Stefan.Marxext.MAFa.Lynx >at< rewe.de
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
--
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/