org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save

Question

I'm facing org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save:an error occurs while saving the package : The part /docProps/app.xml fail to be saved in the stream with marshaller <br/> org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@7c81475b

Exception when try to write the each test scenario result(PASS or FAIL) into Excel sheet(.xlsx) after the each test scenario execution completion. I write the following two different modules for this purpose.

Please tell me where is the problem and how to resolve it..

//Method for writing results into Report
 public void putResultstoReport(String values[])
 {
      int j=NoofTimesExecuted;
      NoofTimesExecuted++;
      XSSFRow row = sheet.createRow(j);
      for(int i=0;i<values.length;i++)
      {
           XSSFCell cell = row.createCell(i);
           cell.setCellValue(values[i]);
      }
      try {
           System.out.println("Times:"+NoofTimesExecuted);
           wb.write(fileOut);
      }
      //fileOut.flush();
      //fileOut.close();
      }
      catch(Exception e) {
           System.out.println("Exception at closing opened Report :"+e);
      }

//Method for Creating the Excelt Report
 public void createReport()
 {
      String FileLocation = getProperty("WorkSpace")+"//SCH_Registration//OutPut//TestResults.xlsx";
      try {
           fileOut = new FileOutputStream(FileLocation);
           String sheetName = "TestResults"; //name of sheet
           wb = new XSSFWorkbook();
           sheet = wb.createSheet(sheetName);
           fileOut.flush();
           fileOut.close();
      }
      catch(Exception e)
      {
           System.out.println("Exception at Create Report file:"+e);
      }
}

The error message is not even good English. I have a bounty on this here if anyone can take a shot stackoverflow.com/questions/21116189/… — David Williams
– David Williams, Commented May 7, 2014 at 23:44

Mark Parnell · Accepted Answer · 2014-01-24 02:42:22Z

6

I had this problem today and fixed it already.

The problem is in putResultstoReport()

You can't wb.write(fileOut); in your cycle.

resolution:

first call putResultstoReport(); then wb.write(fileOut);

edited Jan 24, 2014 at 2:42

Mark Parnell

9,2109 gold badges33 silver badges37 bronze badges

answered Jan 24, 2014 at 2:15

marslee

691 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jack · Accepted Answer · 2016-01-25 15:05:16Z

6

I also had this error.

I found my mistake was caused because I was opening the same file / workbook multiple times.

So I would recommend to make sure you are opening just once before attempting to close as well.

answered Jan 25, 2016 at 15:05

Jack

3,06711 gold badges51 silver badges70 bronze badges

Comments

Ryan · Accepted Answer · 2019-05-13 15:12:55Z

5

This can happen if a timeout occurs. I have code that works for a small dataset and throws this error with huge dataset.

answered May 13, 2019 at 15:12

Ryan

8,01110 gold badges59 silver badges64 bronze badges

2 Comments

Hari Over a year ago

what you did to fix this, how you are generating the excel for big data set. Also is this client side error or server side error. Please help me I think I am having same issue

Eva Over a year ago

In my case it was due to an HTTP timeout of my request, which closes the output stream. It took me a little to find out because my HTTP request went through a proxy, which was the one that timed out. A possible solution is to avoid sending synchronous requests for big file exports, but instead use a websocket which tells the frontend when the export is done and ready to be requested for download.

Ifesinachi Bryan · Accepted Answer · 2020-01-20 13:37:20Z

1

I had the same issue. When I shortened the output excel filename, it stopped.

answered Jan 20, 2020 at 13:37

Ifesinachi Bryan

2,3881 gold badge25 silver badges20 bronze badges

1 Comment

lpkej Over a year ago

Saved countless hours, that was the case for me.

Derrick · Accepted Answer · 2017-12-01 13:05:44Z

0

I had similar Issue. Finally I got the reason and that was version for the below jar file was getting overrided.

  org.apache.xmlgraphics:batik-dom

Hence, I added below dependency and now it is working fine.

<dependency>
    <groupId>org.apache.xmlgraphics</groupId>
    <artifactId>batik-dom</artifactId>
    <version>1.8</version>
</dependency>

This jar contains dependency for xalan. To generate the report xalan is required.

edited Dec 1, 2017 at 13:05

Derrick

4,5695 gold badges41 silver badges54 bronze badges

answered Dec 1, 2017 at 12:04

Harshal_Kalavadiya

3121 gold badge5 silver badges15 bronze badges

Comments

Ali · Accepted Answer · 2020-08-11 16:08:22Z

0

I had the same problem user refreshing page and sending the request again before the previous request is completed. when creating the name use millisecond in name to avoid name conflict with these updates in code of name creation resolved the above issue.

       String sheetName="projectName"+System.currentTimeMillis() + ".xlsx"
       FileOutputStream fileOut = new FileOutputStream(sheetName);
       workbook.write(fileOut);
       fileOut.close();

answered Aug 11, 2020 at 16:08

Ali

3274 silver badges8 bronze badges

Comments

unsubble · Accepted Answer · 2024-03-24 21:28:31Z

0

The problem arises from not providing the second parameter, which should be append, for the OutputStream. The constructor of FileOutputStream is:

public FileOutputStream(File file, boolean append)

Providing "true" for the append parameter here will fix the issue. Because when append is not set to true, the output stream will overwrite the content of the file.

answered Mar 24, 2024 at 21:28

unsubble

11 gold badge1 silver badge3 bronze badges

Collectives™ on Stack Overflow

org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save

7 Answers 7

Comments

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related