Regarding HSSF Sheet issue(Invalid row number (65536) outside allowable range (0..65535) exception)

java hssf
Manikanta picture Manikanta · Jun 20, 2016 · Viewed 7.4k times · Source

I am using Excel 2007 and it supports 1,048,576 rows but through my code it displays only 65,536 rows. If data is more than 65,536 rows I am getting the exception as Invalid row number (65,536) outside allowable range (0..65535).

I used HSSF API.how to display data more than 65,536 rows in Excel sheet with HSSF API only.

Answer

Vijay picture Vijay · Jun 20, 2016

Even though you are using Excel 2007, you will be limited to 65K rows, as you write to xls file using HSSF.

You should be using XSSF api, to take advantage of xlsx 1M row limitation.

For converting an HSSF object to XSSF, you can refer to https://stackoverflow.com/a/7297596/6310050

Related questions

How to use rowiterator in apache poi with java?

I tried to read an excel file using apache poi in java, however, Eclipse did not compile the code. public class ReadExcel { public static void main(String[] args) throws IOException { FileInputStream file = new FileInputStream(new File("C:\\Users\\XXXXXXXXXXXXXXXXal\\042012.xls")); …

Read More
Apache POI, using both XSSF and HSSF

I have a problem with Apache POI project. I failed to use XSSF and HSSF in the "Same Java Class". Which jar should I download or which artifact should I get add into maven? I want to handle both xls …

Read More
Which library should I use to write an XLS from Linux / Python?

I'd love a good native Python library to write XLS, but it doesn't seem to exist. Happily, Jython does. So I'm trying to decide between jexcelapi and Apache HSSF: http://www.andykhan.com/jexcelapi/tutorial.html#writing http://poi.apache.…

Read More