You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "rahul.soa" <ra...@googlemail.com> on 2011/08/18 13:20:21 UTC
[XSSFWorkbook Problem] While creating new files
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
Re: [XSSFWorkbook Problem] While creating new files
Posted by "rahul.soa" <ra...@googlemail.com>.
fyi,
The problem was identified using debugger:
"java.io.IOException: Stream closed"
Seems the problem was: stream can only be read once, a second attempt to
read will result in this IOException.
so to fix this problem, I put
newPtrIrStream =
this.getClass().getResourceAsStream("/org/ama/defect/prevention/templates/MainTemplate.xlsx");
inside jMenuItem1ActionPerformed and problem fixed.
Many Thanks,
rahul
On Wed, Aug 24, 2011 at 1:58 PM, rahul.soa <ra...@googlemail.com> wrote:
> 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 <ra...@googlemail.com>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
>>
>
>
Re: [XSSFWorkbook Problem] While creating new files
Posted by "rahul.soa" <ra...@googlemail.com>.
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 <ra...@googlemail.com> 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
>