POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(filename));
HSSFWorkbook hssfworkbook = new HSSFWorkbook(fs);
// grab the first sheet
HSSFSheet sheet = hssfworkbook.getSheetAt(0);
// define objects for housing spreadsheet data
HSSFRow currentRow = sheet.getRow(0);
// cycle through rows and display cell values
int rowCount = 0;
while (currentRow != null) {
currentRow = sheet.getRow(rowCount++);
if (currentRow != null) {
for (int j = 0; j < currentRow.getPhysicalNumberOfCells(); j++) {
if (currentRow.getCell(j) != null){
this.line += currentRow.getCell(j).toString() + cellSeparator;
}
}
this.arr_excelLines.add(this.line);
this.line = "";
}
else
break;
