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
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.
subject: sheet.getLastRowNum() returns -1
Problem with setBinaryStream
Can a static final constant throw an exception?
Delete a row from an Excel sheet with Apache POI / HSSF?
In struts I am getting an error
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014