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 ?
Asked
Active
Viewed 237 times
0
Community
- 1
- 1
abhinav kumar
- 153
- 1
- 9
-
Please Refer this >> http://forumsqa.com/question/what-is-the-difference-between-xssf-and-hssf/ – Vikrant Kashyap Apr 08 '16 at 07:01
-
also this >> https://stackoverflow.com/questions/4266888/apache-poi-using-both-xssf-and-hssf – Vikrant Kashyap Apr 08 '16 at 07:01
-
Just replace `HSSF` with `XSSF` in that answer's code? – Gagravarr Apr 08 '16 at 10:37
-
DVConstraint's cant be used with XSSFDataValidation – abhinav kumar Apr 08 '16 at 11:48
1 Answers
0
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 readspreadsheets create, modify, read and write XLS spreadsheets.
They also provide:
- low level structures for those with special needs
- an eventmodel api for efficient read-only access
- a full usermodel api for creating, reading and modifying XLS files
For Further Reference Please gothrough with This Link
Vikrant Kashyap
- 6,398
- 3
- 32
- 52