1
How many drop-down lists apache poi/excel 2016 supports ?
I ask this, because I am working with a code that dynamically generates a spreadsheet with several dynamic lists, which depending on the amount of data that are 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 version of POI:
- 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 spreadsheet, but excel does not. I’ve already updated the lib to the latest version and still the error persists.
Any help is welcome! Thank you in advance!
What would be a drop-down (or dynamic) list? I didn’t understand the problem well.
– Dherik
@Dherik, when generating a spreadsheet with many suspended lists excel is not able to open the spreadsheet. Take a look at this link on the suspended lists / Data validation / Dropdown: https://poi.apache.org/apidocs/dev/org/apache/poiss/usermodel/DataValidation.html
– Carlos Henrique
Are you using these suspended lists within a table with merged cells? Another question, how many suspended lists are we talking about?
– Dherik