Is there any reponse for this query, has anybody encountered this yet? Many Thanks for yoru response!
On Thu, Aug 18, 2011 at 1:20 PM, rahul.soa <[email protected]> wrote: > Hello Users/Devs, > > I have a problem with XSSFWorkbook apis while creating new xlsx files. > > *Scenario:* I have a menu item "New File" in my gui's menu which creates > new xlsx file from stream. First time when I click the menu item "New > File" then file new dialogue box appears and I give the name of new xlsx > file and new file gets created. But when I click on this menu item "New > File" second time then new xlsx does not get created. > > > //Code snippet > > File newOpenXLSFile; > public XSSFWorkbook newPtrIrWorkBook; > > newPtrIrStream = > this.getClass().getResourceAsStream("/org/ama/defect/prevention/templates/MainTemplate.xlsx"); > > > private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) > { > // TODO add your handling code here: > logger.debug("You choose to create new PTR/IR file"); > int returnVal = jFileChooser4.showDialog(this, "New PTR/IR Data > File"); > > if (returnVal == JFileChooser.APPROVE_OPTION) { > > newOpenXLSFile = jFileChooser4.getSelectedFile(); > logger.debug("file path " + newOpenXLSFile); > try { > logger.debug("For second time, I am stopped here:"); > //newPtrIrWorkBook = new HSSFWorkbook(newPtrIrPFS, true); > //copying extract into Excel file > newPtrIrWorkBook = new XSSFWorkbook(newPtrIrStream); > logger.debug("New File..." + newOpenXLSFile.getPath()); > FileOutputStream out = new > FileOutputStream(newOpenXLSFile); > newPtrIrWorkBook.write(out); > out.close(); > } catch (Exception e) { > e.getMessage(); > } > } else { > logger.debug("New file dialogue cancelled by user."); > } > > } > > > For second time, I guess it blocks here on the code statement: > > logger.debug("For second time, I am stopped here:"); > //newPtrIrWorkBook = new HSSFWorkbook(newPtrIrPFS, true); //copying > extract into Excel file > *---> newPtrIrWorkBook = new XSSFWorkbook(newPtrIrStream); <--- > * > > > logs: > ==== > > 2011-08-18 13:04:37,602 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - You choose to create new > PTR/IR file > 2011-08-18 13:04:45,586 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - file path C:\Documents and > Settings\rmehta\Desktop\Try\FirstFile.xlsx > 2011-08-18 13:04:45,586 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - For second time, I am stopped > here: > 2011-08-18 13:04:46,351 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - New File...C:\Documents and > Settings\rmehta\Desktop\Try\FirstFile.xlsx > > 2011-08-18 13:04:52,898 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - You choose to create new > PTR/IR file > 2011-08-18 13:04:57,116 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - file path C:\Documents and > Settings\rmehta\Desktop\Try\SecondFile.xlsx > 2011-08-18 13:04:57,116 [AWT-EventQueue-0] DEBUG > org.ama.defect.prevention.tool.gui.GUI.class - For second time, I am stopped > here: > > > > Can you please help me solving this problem? However, it was fine with > HSSFWorkbook (for xls file). > > Many Thanks, > rahul >
