File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other JSE/JEE APIs and the fly likes HSSF Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "HSSF" Watch "HSSF" New topic


Dan John

Joined: Feb 06, 2006
Posts: 7
I am trying to create and populate a spreadsheet. I create a new fileOuputStream and per each line I insert I create a new row and for each row I create a new cell. The problem is that it doesnt start the insert from row 0 like I want it to. It inserts at one row at 65,000. Any ideas on why this is?
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
Welcome to JavaRanch.

That sounds odd - I don't think XLS supports more than 2^16 rows. Seeing a short, relevant excerpt of the code would be helpful in diagnosing this.
Dan John

Joined: Feb 06, 2006
Posts: 7
I think I figured it out... I have something else looping in the code. If it comes back I will update the post.

I agree. Here's the link:
subject: HSSF
It's not a secret anymore!