Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Normal
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 5.1.0
-
Component/s: None
-
Security Level: Jimmy
-
Labels:None
Description
Problem description
The only way to get named range is Book.getInternalBook().getNames() which is an internal API.
Use case
Named range is an important feature to decouple cell address and java code when accessing data from a sheet. With named ranges, application code doesn't have to hard-coded cell address like B1, developers can write
Ranges.rangeByName(sheet, "price")
to get or set cell data.
So that the application code can resist sheet design change better.
Requirements
Keikai should provide API about
- get a list of named ranges upon a sheet.
the most common case, app developers need to process fields of a sheet.