0

I've a big file with 10000 rows... Opening it, lasts an eternity... After 10mins I stopped the programm...

OPCPackage opcPackage = OPCPackage.open(item.getFilePath());
workbook = new XSSFWorkbook(opcPackage);
sheet = workbook.getSheet(item.sheet);
evaluator = new XSSFFormulaEvaluator(workbook);
itRows = sheet.rowIterator();

the itRows = sheet.rowIterator(); newer finishes...it needs so much time...

How can I read such a big file?

prom85
  • 16,896
  • 17
  • 122
  • 242
  • 10,000 rows isn't that many, and requesting a sheet iterator should be really quick. Are you sure that it isn't hanging somewhere else? – Gagravarr Jan 12 '13 at 19:17
  • this time, I had another problem as well... but though, loading the file needs much time... and if the file gets bigger, heap space error occurs as well... so I'm now using a SAXParser in combination with the XSSF Lib to iterate over the data without loading it beforehand... – prom85 Jan 15 '13 at 09:28

0 Answers0