A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Spring in Action
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.
It is sorta covered in the
JavaRanch Style Guide
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-2014