Exception when writing to the xlsx document several times using apache poi 3.7

by

I’ve had the same problem today. I’ve noticed many people asking the same question on many different forums, but I haven’t seen an answer anywhere. So, here is what I came up with. It is far from ideal (I can think of at least two scenarios where this might be a bad idea), and may not suite every need, but it works!

After every save operation inside the class which the workbook object is a property of, I reload the workbook from the file I just saved it to.

Using your code example above, I would modify the method like so:

void method(int i) throws InvalidFormatException, IOException {
    ...

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xlsx");
    workbook.write(fileOut);
    fileOut.close();

    // Reload the workbook, workaround for bug 49940
    // https://issues.apache.org/bugzilla/show_bug.cgi?id=49940
    workbook = new XSSFWorkbook(new FileInputStream("workbook.xlsx"));
}

I tested this in my code, and it resolved the issue nicely. Just make sure that you read it back in from the same file you saved it to, and not an earlier or different version.

More Related Contents:

  1. How can I read numeric strings in Excel cells as string (not numbers)?
  2. Best language to parse extremely large Excel 2007 files [closed]
  3. How to read Excel cell having Date with Apache POI?
  4. Embed files into Excel using Apache POI
  5. Apache POI – FileInputStream works, File object fails (NullPointerException)
  6. Apache POI add a Series name into LineChart
  7. Apache poi Excel line chart points
  8. How to set axis’ labels in a Line Chart using Apache Poi
  9. Removing a row from an Excel sheet with Apache POI HSSF
  10. Apache POI autoSizeColumn Resizes Incorrectly
  11. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  12. Merging cells in Excel using Apache POI
  13. Password Protected Excel File
  14. how to read exact cell content of excel file in apache POI
  15. Create Bar Chart in Excel with Apache POI
  16. Excel Cell Style issue
  17. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  18. Apache-POI sorting rows in excel
  19. Java POI : How to read Excel cell value and not the formula computing it?
  20. Create a password protected Excel file using Apache POI?
  21. Apache POI evaluate formula
  22. Embed files into XSSF sheets in Excel, using Apache POI
  23. Apache POI Line Chart colors
  24. Java POI the supplied data appears to be in the Office 2007+ XML
  25. Determine MS Excel file type with Apache POI
  26. Make column read-only using apache poi
  27. Converting number representing a date in Excel to a Java Date object
  28. how to add a picture to a .docx document with Apache POI XWPF in java
  29. Insert picture in word document
  30. java.lang.OutOfMemoryError: Java heap space while reading excel with Apache POI

Leave a Comment