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

support public API to get named range list of a sheet

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Done
    • Normal
    • 5.1.0
    • None
    • None
    • Security Level: Jimmy
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: