private Workbook readWorkbookFrom(Response whenPostingToReportUrl) {
try {
return WorkbookFactory.create(new ByteArrayInputStream(whenPostingToReportUrl.asByteArray()));
} catch (IOException | InvalidFormatException e) {
e.printStackTrace();
throw new AssertionFailedError(e.getMessage());
}
}
/**
* Create a simple Excel file reader.
*
* @param filename name of the excel workbook
* @param numField number of cells per row to read
*/
public ExcelReader(String filename, int numField) {
this.numField = numField;
sheet = null;
msg = "";
try {
InputStream inp = new FileInputStream(filename);
Workbook wb = WorkbookFactory.create(inp);
sheet = wb.getSheetAt(0);
} catch (IOException | InvalidFormatException e) {
msg = e.getMessage();
}
}