Limitation while generating excel drop down list with Apache POI - can we solve this using xssf rather than hssf?

0
votes

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 ?

1
javaexcelapachexssfpoi-hssf
Please Refer this >> forumsqa.com/question/… – Vikrant Kashyap
also this >> stackoverflow.com/questions/4266888/… – Vikrant Kashyap
Just replace HSSF with XSSF in that answer's code? – Gagravarr
DVConstraint's cant be used with XSSFDataValidation – abhinav kumar

1 Answers

0
votes

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:

  1. low level structures for those with special needs
  2. an eventmodel api for efficient read-only access
  3. a full usermodel api for creating, reading and modifying XLS files

For Further Reference Please gothrough with This Link