3 Replies Latest reply on Mar 12, 2007 9:08 AM by emmim44

    POI-Apache ERR

    emmim44 Level 1

      What is the solution people ?

      The file exist in c drive with 2 sheets in excel file called "As-Built and Design"
      ........

      ===================ERR==================
      -1


      The error occurred in D:\CFusionMX\wwwroot\1.cfm: line 16

      14 : fis.close();
      15 : </cfscript>
      16 : <cfx_ExcelQuery action="read" file="c:\template.xls" sheet="#sheetNumber#" variable="myQuery" />
      17 : <cfdump var="#myQuery#">




      =============Code=============
      <cfscript>
      fis = createObject("java", "java.io.FileInputStream").init("c:\template.xls");
      wb = createObject("java", "org.apache.poi.hssf.usermodel.HSSFWorkbook").init(fis);
      sheetNumber = wb.getSheetIndex("Sheet1");
      fis.close();
      </cfscript>
      <cfx_ExcelQuery action="read" file="c:\template.xls" sheet="#sheetNumber#" variable="myQuery" />
      <cfdump var="#myQuery#">