Hi, I am trying to open an XL file that has macros written in it. InputStream myxls = new FileInputStream(getServletContext().getRealPath("/") + "docs\\Payment Request.xls"); HSSFWorkbook wb = new HSSFWorkbook(myxls); The above 2 lines are in a servlet and I am testing the servlet from the browser. The following exception is thrown at line 2 and the exception is 500 Unable to construct record instance, the following exception occured: null Unable to construct record instance, the following exception occured: null I have tested the 2 lines of code with a password protected XL file, it works fine. I tested the above 2 lines with a plain XL file works beautifully. I have no clue, Please let me know if any workaround or fix is available. Will be able to send XL file on request, since the bug entry screen doesn't have a field for attachements FYI, I am using poi-bin-2.5.1-final-20040804 version of POI Thanks in adance, Sowmini Ramana
Difficult to say what your problem is without seeing an example workbook.
This was probably fixed some time ago. Recent versions of POI preserve VBA macros OK. Please re-open if you can provide an example spreadsheet which is not handled correctly.