A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
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";
FileInputStream fis = null;
fis = new FileInputStream(filename);
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.
I agree. Here's the link:
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