POI Excel SXSSFSheet Sınıfı

createRow metodu
Şöyle yaparız.

SXSSFSheet sheet = ...;

int no_of_rows = 50000;

for(int i=0;i<=no_of_rows;i++) {
  SXSSFRow row1 = sheet.createRow(i);
  ...
}

addDataValidation metodu - DataValidation
Drop down liste ekler.
Örnek
Şöyle yaparız.

String[] optionsArray = new String[] {"1000.00","2000.00"};

int no_of_rows = 50000;

DataValidationConstraint constraint1 = sheet.getDataValidationHelper()
  .createExplicitListConstraint(optionsArray);
CellRangeAddressList addressList1 = new CellRangeAddressList(0, no_of_rows, 0, 0);
DataValidation dataValidation1 = sheet.getDataValidationHelper()
  .createValidation(constraint1, addressList1);
sheet.addValidationData(dataValidation1);

getDataValidationHelper metodu
Şöyle yaparız.

String[] optionsArray = new String[] {"1000.00","2000.00"};
DataValidationConstraint constraint1 = sheet.getDataValidationHelper()
  .createExplicitListConstraint(optionsArray);