search

pinussilvestrus / camunda-modeler-excel-import-plugin

Camunda Modeler plugin to import Excel Sheets to DMN 1.3 Decision Tables (and vice versa).
MIT License
23 stars 3 forks source link

Not able to open exported xslx file with EXCEL #106

Closed ThoreKleinschmidt closed 2 years ago

ThoreKleinschmidt commented 2 years ago

Describe the Bug

EXCEL is not able to open a file which was exported via the plugin from a DMN table created with Camunda modeler.

Steps to Reproduce

  1. Create the DMN or load an existing one into the Modeler
  2. Export via plugin as xlsx file
  3. Open EXCEL
  4. Select exported xslx file to open
  5. Excel opens popup "Problems occured. Should we restore the content as much as possible..."
  6. Click on YES
  7. Another popup appears "EXCEL cannnot open the file . ..."

Expected Behavior

EXCEL should open the exported file.

Environment

DMN_Export.zip

pinussilvestrus commented 2 years ago

Thank you for reporting! I can reproduce this on Windows with the latest version of the plugin. I will investigate this 👍

pinussilvestrus commented 2 years ago

The issue should be resolved via https://github.com/pinussilvestrus/camunda-modeler-excel-import-plugin/commit/586c1a9bff94dc22f81773aac69243fba5b8ecd6. I had to pin the node-xlsx which handles the Excel export. For some reason, it behaves differently in newer versions of the library.

You can use the latest plugin version of the main branch. Feel free to reach out if something is still not working 👍

ThoreKleinschmidt commented 2 years ago

Thanks for fixing. The plugin is really helpful.