Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
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
In struts I am getting an error
Can a static final constant throw an exception?
Delete a row from an Excel sheet with Apache POI / HSSF?
Problem with setBinaryStream
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013