Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-180

support public API to get named range list of a sheet

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Done
    • Icon: Normal Normal
    • 5.1.0
    • None
    • None
    • Security Level: Jimmy
    • None
    • None

      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.

            jumperchen jumperchen
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: