Limitation While Generating Excel Drop Down with Apache POI
This link solves the problem for an HSSFWorkbook
. Can we do this for an XSSFWorkbook
too ?
HSSF
is the POI Project's pure Java
implementation of the Excel 97(-2007)
file format.
While XSSF
is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx)
File format.
HSSF
and XSSF
provides ways to read
spreadsheets create
, modify
, read and write
XLS spreadsheets.
They also provide:
For Further Reference Please gothrough with This Link
HSSF
withXSSF
in that answer's code? – Gagravarr