Might be worth keeping the number of styles you create to a minimum as well.
Regards, Glen Stampoultzis (TriNexus Pty Ltd) Fixed:+61 3 9753-6850 Mob:+61 (0)402 835 458 ICQ: 62722370 EMail: [EMAIL PROTECTED] URL's: http://jakarta.apache.org/poi, http://www.krysalis.org > Size of files are generally bigger in HSSF for one of two reasons: > > 1. Unicode - (If for some reason the strings in the file are saved as > unicode they'll be twice as big" > 2. Number/Multi record conversion - > We currently do not support writing: > RK > MULRK > MULBlank > records. We convert RK to a Number record (increasing its data > size from an 32 bit number to 64 bit). We convert > MULRK records to multiple Number records (repeating like the first > 8 bytes and increasing data size to 64 bit). We > convert MULBlank to multiple BLANK records (increasing their size > as well). > > To see which it is compare the files with > org.apache.poi.hssf.dev.BiffViewer. If the strings have been > needlessly converted to unicode and you did not specifically set them to > be such, then we'd like to hear about it. (with code samples and sheet > samples of course). If its just numeric record promotion, support for > the smaller records is a feature we have stated for 2.0. Just no one > has worked on it yet. We may delay that past 2.0 because it could be > easier to implement in the planned 3.0 memory model. > > Hope that helps, > > -Andy > > [EMAIL PROTECTED] wrote: > > >Hi > > > > Well is not really a problem. In fact, all goes well, i can make file but > >the output file is very > >big. How do i know its bigger than a excel file made with excel? Then, i > >open the file > >made with HSSF and i save it as a new file with the floppy disk icon on the > >menu, the second > >file's size is around 1/2 the size of the first one. I would know if its > >possible to reduce > >the size in the HSSF code or is there a method of programming which make > >less large files. > >Its a problem for me cause i would like to send the Excel file into a > >browser and then size must be as > >low as possible. > > > >Thks. > > > > > >-- > >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
