<-- Back

Zip File is closed error when using the Excel Importer module

Issue

When importing a Microsoft Excel file using the ExcelImporter module, the following error occurs:

Document could not be imported, because:
Fail to save: an error occurs while saving the package : Zip File is closed

The import process fails before the data is imported into the application.

Environment

  • Studio Pro (all versions)
  • Excel Importer v10.7.7
  • Community Commons v10.2.0

Cause

This error can occur when the application contains incompatible Java Archive (JAR) files in the project's userlib directory.

Multiple Marketplace modules can include different versions of shared libraries, such as Apache POI. Incompatible library versions can cause runtime conflicts during Excel processing, resulting in the following exception:

Caused by: java.lang.IllegalStateException: Zip File is closed

The issue can also occur when the installed versions of ExcelImporter, Community Commons, or other Marketplace modules are not compatible with the Studio Pro version used by the application.

Solution/Workaround

Verify that all Marketplace modules are compatible with the Studio Pro version and remove any conflicting JAR files.

  1. Determine the Studio Pro version used by the application.
  2. Review the Marketplace pages for ExcelImporter, Community Commons, and any other modules that contribute libraries to the userlib directory.
  3. Verify that the installed module versions are supported for the Studio Pro version.
  4. Update the modules to compatible versions if required.
  5. Open the project's userlib directory(can be accessed via Studio Pro by navigating to App > Show App Directory in Explorer)
  6. Review the JAR files included by Marketplace modules.
  7. Identify overlapping dependencies, particularly Apache POI libraries.
  8. Follow the cleanup procedure described in the related knowledge base article for cleaning the userlib directory.
  9. Remove any conflicting or obsolete JAR files.
  10. Restart the application.
  11. Retry the import.

If multiple versions of the same dependency are present, retain only the version required by the compatible Marketplace modules.

Internal information related

278675

Additional information

Have more questions? Submit a request

0 Comments

Article is closed for comments.

To provide feedback, please open a ticket here. Don't forget to include the article's URL along with the feedback you would like to provide.