i have a strange problem.. i can't open xslm file with apache poi.. file is 12mb, not corrupted if open with excel is all ok if open in internal editor eclipse works (2 minutes for open but work) but if i try open with java and apache poi nothing happen... no errors, no timeout.. nothing.. passed over 10minutes... with task manager i see java memory growing... but never finish.. my code is here..
public XSSFWorkbook openExcelFile(String excelFilePath) throws IOException {
XSSFWorkbook workbook = null;
FileInputStream inputStream = null;
try {
inputStream = new FileInputStream(excelFilePath);
workbook = new XSSFWorkbook(inputStream);
//workbook = (XSSFWorkbook) WorkbookFactory.create(new File(excelFilePath));
//Workbook workbook_test = WorkbookFactory.create(new File(excelFilePath));
//Workbook workbook_test = StreamingReader.builder().rowCacheSize(100)
//.bufferSize(4096)
//.open(new File(excelFilePath));
}finally{
inputStream.close();
}
return workbook;
}