File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
REST with Spring (video course)
this week in the
Java in General
sheet.getLastRowNum() returns -1
Joined: Dec 01, 2010
Oct 10, 2011 07:05:17
filename = "D:\\PersonalValuesAssets.xlsx";
fis = null;
fis = new
XSSFWorkbook workbook = new XSSFWorkbook(fis);
XSSFSheet sheet = workbook.getSheetAt(0);
rows = sheet.rowIterator();
System.out.println(" number of rows: "+ number);
Here, number returns
as the .xlsx file currently have more than
1.5 lakhs records
To execute this program I had also increases the heap size using the VM parameters to min 512 MB ans max to 1280 MB.
Please help me to out from this thing...
Thanks in advance.
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: sheet.getLastRowNum() returns -1
Can a static final constant throw an exception?
Problem with setBinaryStream
In struts I am getting an error
Delete a row from an Excel sheet with Apache POI / HSSF?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015