Doubt Apache POI

1

How many drop-down lists does apache poi / excel 2016 support?

I ask this, because I am working with a code that dynamically generates a spreadsheet with several dynamic lists, depending on the amount of data that is selected to be exported, excel can not open the spreadsheet.

Error:

Excel found unreadable content in "abc.xlxs" .Do you want to recover the contents of this workbook?If you trust the source of this workbook, click 'yes'

Apache POI version:

  • poi-3.14-20160307.jar
  • poi-ooxml-3.14-20160307.jar
  • poi-ooxml-schemas-3.14-20160307.jar
  • poi-scratchpad-3.14-20160307.jar

NOTE: The WPS reader can normally open the generated worksheet, but excel does not. I have already updated lib to the latest version and still the error persists.

Any help is welcome! Thank you in advance!

    
asked by anonymous 13.12.2018 / 18:19

0 answers