/**
* Name should be created after sheets created. A special defined name, _xlnm._FilterDatabase
* (xlsx) or _FilterDatabase (xls), stores the selected cells for auto-filter
*/
protected void importNamedRange() {
for (int i = 0; i < workbook.getNumberOfNames(); i++) {
Name definedName = workbook.getNameAt(i);
if (skipName(definedName)) {
continue;
}
SName namedRange = null;
if (definedName.getSheetIndex() == -1) { // workbook scope
namedRange = book.createName(definedName.getNameName());
} else {
namedRange = book.createName(definedName.getNameName(), definedName.getSheetName());
}
namedRange.setRefersToFormula(definedName.getRefersToFormula());
}
}
