I could not come up with an exect number, but it was around 4500-5000. I fixed my problem by creating reusable cell styles that could be used over and over. I had been creating a new cell style for every cell when I had the problem.
--- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > Interesting, can you do some investigation and find > out what the upper > limit is? > > Can you optimize your use of cell formats? HSSF by > design creates a new > cell > format (even if its a duplicate) if you do. I > thought long and hard > about this but > decided to go with that because you may wish to use > a particular cell > format for > a particular group of cells. Should you ever decide > to change it, it > would be > reflected in all of those cells. > > I think HSSF should throw an exception to warn you > if you hit the bounds. > > -Andy > > Cornellious Mann wrote: > > >"Too many different cell formats." > > > >Has anyone seen this error message? I get this > when I > >generate a large Excel file and then try to open > the > >file using Excel. The file is then unable to open. > > > >===== > >Best Regards, > >Cornellious Mann > > > >__________________________________________________ > >Do You Yahoo!? > >Yahoo! Shopping - Mother's Day is May 12th! > >http://shopping.yahoo.com > > > >-- > >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]> > ===== Best Regards, Cornellious Mann __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
