Skip to content
Advertisement

Tag: xssf

Limitation while generating excel drop down list with Apache POI

I’m trying to generate an excel file with some validations, I’ve read the poi dev guides for implementing it. During implementation, I got an exception (String literals in formulas can’t be bigger than 255 characters ASCII). POI concatenates all drop down options into ‘0’ deliminated string and checking its length and giving me exception. 🙁 I’m using latest version of

Advertisement