Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HSSF - Excel maximum number of rows problem

807588Jan 31 2009 — edited Jan 31 2009

Hi

I am working on an application where I am generating a excel spreadsheet using HSSF.
I got an issue when I was told that maximum number of records might exceed 70,000.
But Excel supports only 64556 (approx) rows.

How can I overcome this.
Idea in my mind is, I will generate a separate sheet when number of records exceed maximum limit of Excel spreadsheet.
Is this the only way out of this scenario, because I feel customer will not be happy with the output.

Please suggest me the alternate if exists.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2009

Added on Jan 31 2009

3 comments

1,111 views