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!