[XSSFWorkbook Problem] While creating new files

[rahul.soa]

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