Package io.keikai.model

Interface SSheet

All Known Implementing Classes:
AbstractSheetAdv
public interface SSheet
A sheet of a book. It's the main class you can manipulate rows, columns, cells, pictures, charts, and data validation.
Since:
3.5.0
Author:
dennis

  • Method Details

    • getBook

      SBook getBook()
      Get the owner book
      Returns:
      the owner book

    • getSheetName

      String getSheetName()
      Get the sheet name
      Returns:
      the sheet name

    • getRowIterator

      Iterator<SRow> getRowIterator()
      Returns:
      an iterator of existing rows excluding those blank rows

    • getRowIterator

      Iterator<SRow> getRowIterator(int start, int end)
      Parameters:
      start - the start index
      end - the end index
      Returns:
      an iterator of existing rows excluding those blank rows
      Since:
      5.0.0

    • getColumnIterator

      Iterator<SColumn> getColumnIterator()
      Returns:
      an iterator of existing columns excluding those blank columns

    • getColumnArrayIterator

      Iterator<SColumnArray> getColumnArrayIterator()

    • setupColumnArray

      SColumnArray setupColumnArray(int colunmIdx, int lastColumnIdx)
      Set up a column array, if one array range overlaps another, it throws IllegalStateException. If you setup a column array that is not continuous, (for example, 0~2, 5~6), then it will create a missing column array automatically to make them continuous.(3~4 in the example). It's required to set up in ascending order of starting column index (min), or it will create unexpected SColumnArray for columns are not continuous.
      Parameters:
      colunmIdx - index of the starting column
      lastColumnIdx - index of the end column
      Returns:
      the new created column array

    • getCellIterator

      Iterator<SCell> getCellIterator(int row)

    • getDefaultRowHeight

      int getDefaultRowHeight()
      Returns:
      default row height in pixels

    • getDefaultColumnWidth

      int getDefaultColumnWidth()
      Returns:
      default column width in pixels

    • setDefaultRowHeight

      void setDefaultRowHeight(int height)
      set default row height in pixels

    • setDefaultColumnWidth

      void setDefaultColumnWidth(int width)
      set default column width in pixels

    • getRow

      SRow getRow(int rowIdx)

    • getColumnArray

      SColumnArray getColumnArray(int columnIdx)
      See Also:

    • getColumn

      SColumn getColumn(int columnIdx)

    • getCell

      SCell getCell(int rowIdx, int columnIdx)
      This method always returns not-null cell object. Use SCell.isNull() to know it's null (blank) or not.

    • canBulkSetRangeValues

      default boolean canBulkSetRangeValues(int row1, int col1, int row2, int col2, Object[] values)
      Bulk-write capability check: returns true if this backend can set the row-major values into the rectangle [row1..row2] x [col1..col2] in a single round-trip. The default is false (per-cell). The Rust-engine backend returns true only for plain number / string / bool / blank values into a formula-free target range (formula overwrite + special cells keep the per-cell path).

    • setRangeValues

      default void setRangeValues(int row1, int col1, int row2, int col2, Object[] values)
      Bulk-writes the row-major values into the rectangle in one backend round-trip. Only valid when canBulkSetRangeValues(int, int, int, int, java.lang.Object[]) just returned true; dependents of the written cells are marked dirty so referencing formulas recalc. The default is a no-op.

    • getRangeValues

      default List<Object> getRangeValues(int row1, int col1, int row2, int col2)
      Bulk range read: returns the values of every cell in the rectangle [row1..row2] x [col1..col2] as a row-major List<Object> (blank cells as null), identical to a per-cell SCell.getValue() walk, in one backend round-trip.

      Returns null when this backend has no bulk path; callers (e.g. SRange.getValues()) then fall back to the per-cell visitor. The Rust-engine backend overrides this to issue a single JNI crossing for the whole rectangle, avoiding the per-cell JNI cost on large ranges.

    • getCell

      SCell getCell(String cellRefString)
      Returns:
      return a cell with specified cell reference, e.g. A2, B3. Area reference, A1:A2, is not acceptable.
      See Also:

    • getId

      String getId()
      Returns:
      interal sheet object ID

    • getViewInfo

      SSheetViewInfo getViewInfo()

    • getPrintSetup

      SPrintSetup getPrintSetup()

    • getStartRowIndex

      int getStartRowIndex()

    • getEndRowIndex

      int getEndRowIndex()

    • getStartColumnIndex

      int getStartColumnIndex()

    • getEndColumnIndex

      int getEndColumnIndex()

    • getStartCellIndex

      int getStartCellIndex(int rowIdx)

    • getEndCellIndex

      int getEndCellIndex(int rowIdx)

    • clearCell

      void clearCell(int rowIdx, int columnIdx, int lastRowIdx, int lastColumnIdx)
      See Also:

    • clearCell

      void clearCell(CellRegion region)
      Clear cells in specified region

    • moveCell

      void moveCell(int rowIdx, int columnIdx, int lastRowIdx, int lastColumnIdx, int rowOffset, int columnOffset)
      Move a region of cells specified by 4 indexes.
      See Also:

    • moveCell

      void moveCell(CellRegion region, int rowOffset, int columnOffset)
      Move one or more cells.
      Parameters:
      region - the region of cells to move
      rowOffset - positive number to move down, negative to move up
      columnOffset - positive number to move right, negative to move left

    • insertRow

      void insertRow(int rowIdx, int lastRowIdx)
      insert rows specified by first and last index

    • deleteRow

      void deleteRow(int rowIdx, int lastRowIdx)
      delete rows specified by first and last index

    • insertColumn

      void insertColumn(int columnIdx, int lastColumnIdx)
      insert columns specified by first and last index

    • deleteColumn

      void deleteColumn(int columnIdx, int lastColumnIdx)
      delete columns specified by first and last index

    • insertCell

      void insertCell(int rowIdx, int columnIdx, int lastRowIndex, int lastColumnIndex, boolean horizontal)
      See Also:

    • insertCell

      void insertCell(CellRegion region, boolean horizontal)
      Insert a region of cells and shift existing cells.
      Parameters:
      region - the region of cells to insert
      horizontal - TRUE for shifting right, FALSE for shifting down

    • deleteCell

      void deleteCell(CellRegion region, boolean horizontal)
      Delete a region of cells and shift existing cells.
      Parameters:
      region - the region of cells to delete
      horizontal - TRUE for shifting left, FALSE for shifting up

    • deleteCell

      void deleteCell(int rowIdx, int columnIdx, int lastRowIndex, int lastColumnIndex, boolean horizontal)
      See Also:

    • addPicture

      SPicture addPicture(SPicture.Format format, byte[] data, ViewAnchor anchor)
      Add a picture into this sheet with raw picture data and format.
      Parameters:
      format - picture format as specified in SPicture.Format
      data - raw byte data of the picture
      anchor - where to anchor this picture
      Returns:
      the added SPicture

    • addPicture

      SPicture addPicture(int index, ViewAnchor anchor)
      Add a picture into the sheet with known picture data index.
      Parameters:
      index - SPictureData index
      anchor - where to anchor this picture
      Returns:
      the SPicture added
      Since:
      3.6.0

    • getPicture

      SPicture getPicture(String picid)

    • deletePicture

      void deletePicture(SPicture picture)

    • getNumOfPicture

      int getNumOfPicture()

    • getPicture

      SPicture getPicture(int idx)

    • getPictures

      List<SPicture> getPictures()

    • addChart

      SChart addChart(SChart.ChartType type, ViewAnchor anchor)

    • getChart

      SChart getChart(String chartid)

    • deleteChart

      void deleteChart(SChart chart)

    • getNumOfChart

      int getNumOfChart()

    • getChart

      SChart getChart(int idx)

    • getCharts

      List<SChart> getCharts()

    • getMergedRegions

      List<CellRegion> getMergedRegions()

    • removeMergedRegion

      void removeMergedRegion(CellRegion region, boolean removeOverlaps)
      Remove the merged area that are contained by region
      Parameters:
      region -
      removeOverlaps - true if you want to remove the merged areas that are just overlapped.

    • addMergedRegion

      void addMergedRegion(CellRegion region)
      Add a merged area, you can't assign a area that overlaps existed merged area.
      Parameters:
      region -

    • getNumOfMergedRegion

      int getNumOfMergedRegion()

    • getMergedRegion

      CellRegion getMergedRegion(int idx)

    • getOverlapsMergedRegions

      List<CellRegion> getOverlapsMergedRegions(CellRegion region, boolean excludeContains)
      Get the merged region that overlapped the region
      Returns:
      the regions that overlaps

    • getContainsMergedRegions

      List<CellRegion> getContainsMergedRegions(CellRegion region)
      Get the merged region that are contained by region.
      Returns:
      the regions that are contained

    • getMergedRegion

      CellRegion getMergedRegion(int row, int column)

    • getMergedRegion

      CellRegion getMergedRegion(String cellRefString)

    • addDataValidation

      SDataValidation addDataValidation(CellRegion region)

    • addDataValidation

      SDataValidation addDataValidation(CellRegion region, SDataValidation src)

    • getDataValidation

      SDataValidation getDataValidation(String id)

    • deleteDataValidation

      void deleteDataValidation(SDataValidation validation)

    • getNumOfDataValidation

      int getNumOfDataValidation()

    • getDataValidation

      SDataValidation getDataValidation(int idx)

    • getDataValidations

      List<SDataValidation> getDataValidations()

    • deleteDataValidationRegion

      List<SDataValidation> deleteDataValidationRegion(CellRegion region)
      Delete data validations that are covered by the specified region.
      Parameters:
      region - the cover region
      Returns:
      the data validations deleted
      Since:
      3.6.0

    • getDataValidation

      SDataValidation getDataValidation(int row, int column)
      Parameters:
      row -
      column -
      Returns:
      the first data validation at row, column

    • getAttribute

      Object getAttribute(String name)
      Get the runtime custom attribute that stored in this sheet
      Parameters:
      name - the attribute name
      Returns:
      the value, or null if not found

    • setAttribute

      Object setAttribute(String name, Object value)
      Set the runtime custom attribute to stored in this sheet, the attribute is only use for developer to stored runtime data in the sheet, values will not stored to excel when exporting.
      Parameters:
      name - name the attribute name
      value - the attribute value

    • getAttributes

      Map<String,Object> getAttributes()
      Get the unmodifiable runtime attributes map
      Returns:

    • isProtected

      boolean isProtected()
      Check if the sheet is protected
      Returns:

    • setPassword

      void setPassword(String password)
      Sets password to protect sheet, set null to unprotect it.
      Parameters:
      password -

    • getHashedPassword

      short getHashedPassword()
      Internal Use only.
      Returns:

    • setHashedPassword

      void setHashedPassword(short hashpass)
      Internal User only.

    • getAutoFilter

      SAutoFilter getAutoFilter()
      Gets the auto filter information if there is.
      Returns:
      the auto filter, or null if not found

    • createAutoFilter

      SAutoFilter createAutoFilter(CellRegion region)
      Creates a new auto filter, the old one will be drop directly.
      Parameters:
      region - the auto filter region
      Returns:
      the new auto filter.

    • deleteAutoFilter

      void deleteAutoFilter()
      Delete current autofilter if it has

    • clearAutoFilter

      void clearAutoFilter()
      Clear auto filter if there is.

    • pasteCell

      CellRegion pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
      paste cell from src sheet to this sheet, the sheets must in same book
      Parameters:
      src - src sheet and it's region to paste
      dest - destination region in this sheet
      option - the copy option
      Returns:
      the final effected region

    • getSheetProtection

      SSheetProtection getSheetProtection()
      Gets enhanced protection.

    • getSheetVisible

      SSheet.SheetVisible getSheetVisible()
      Get the sheet current visible state.
      Since:
      3.7.0

    • setSheetVisible

      void setSheetVisible(SSheet.SheetVisible state)
      Set the sheet current visible state.
      Since:
      3.7.0

    • addTable

      void addTable(STable table)
      Add a new table
      Parameters:
      table -
      Since:
      3.8.0

    • getTables

      List<STable> getTables()
      Get tables in this sheet
      Returns:
      Since:
      3.8.0

    • removeTable

      void removeTable(String tableName)
      Remove the table of the specified table name.
      Parameters:
      tableName -
      Since:
      3.8.0

    • setHashValue

      void setHashValue(String hashValue)
      New way of hashing sheet protection password.
      Parameters:
      hashValue -
      Since:
      3.8.1

    • setSpinCount

      void setSpinCount(String spinCount)
      New way of hashing sheet protection password.
      Parameters:
      spinCount -
      Since:
      3.8.1

    • setSaltValue

      void setSaltValue(String saltValue)
      New way of hashing sheet protection password.
      Parameters:
      saltValue -
      Since:
      3.8.1

    • setAlgName

      void setAlgName(String algName)
      New way of hashing sheet protection password.
      Parameters:
      algName -
      Since:
      3.8.1

    • getConditionalFormattings

      List<SConditionalFormatting> getConditionalFormattings()
      Returns the conditional formatting applied to this sheet.
      Returns:
      Since:
      3.8.2

    • getDataRegion

      CellRegion getDataRegion()
      Returns the region which contains data(including chart, picture, and fills) in this sheet; return null if empty sheet.
      Returns:
      the region which contains data(including chart, picture, and fills) in this sheet; return null if empty sheet.
      Since:
      3.8.3

    • setTabColor

      void setTabColor(String tabColor)
      Set sheet tab color
      Since:
      5.2.0

    • getTabColor

      String getTabColor()
      Returns:
      sheet tab color
      Since:
      5.2.0

    • setArrayFormula

      @Deprecated CellRegion setArrayFormula(String formula, CellRegion region)
      Deprecated.
      since 7.0.0 — use setCseArrayFormula(String, CellRegion) for the clearer name. The legacy method delegates and remains supported indefinitely.
      Installs a legacy CSE array formula in the specified region.

      Note if there are shared formulas this will invalidate any formula-evaluator caches based on this workbook.

      CSE-only. Dynamic-array (DA) spills are created implicitly by evaluating a DA-aware formula at a single cell — there is no DA-create entry point.

      Parameters:
      formula - text representation of the formula
      region - Region of array formula for result.
      Returns:
      the CellRegion of cells affected by this change
      Since:
      6.0.0

    • setCseArrayFormula

      default CellRegion setCseArrayFormula(String formula, CellRegion region)
      Installs a legacy CSE array formula in the specified region.
      Since:
      7.0.0
      See Also:

    • removeArrayFormula

      @Deprecated CellRegion removeArrayFormula(SCell cell)
      Deprecated.
      since 7.0.0 — use removeCseArrayFormula(SCell) for the clearer name.
      Removes a legacy CSE array formula from this sheet. All cells contained in the array range are also cleared.

      CSE-only. Has no effect on dynamic-array (DA) spills.

      Parameters:
      cell - any cell within the CSE array range
      Returns:
      the CellRegion of cells affected by this change
      Since:
      6.0.0

    • removeCseArrayFormula

      default CellRegion removeCseArrayFormula(SCell cell)
      Removes a legacy CSE array formula from this sheet.
      Since:
      7.0.0
      See Also:

    • getCellRegionInArrayFormula

      @Deprecated CellRegion getCellRegionInArrayFormula(SCell cell)
      Deprecated.
      since 7.0.0 — use getCseRegion(SCell) for the clearer name.
      Returns the CSE region containing the given cell, or null if the cell is not in a CSE region.

      CSE-only. Does not report dynamic-array (DA) spills.

      Parameters:
      cell -
      Since:
      6.0.0

    • getCseRegion

      default CellRegion getCseRegion(SCell cell)
      Returns the CSE region containing the given cell, or null if the cell is not in a CSE region.
      Since:
      7.0.0
      See Also:

    • getAllArrayFormulas

      @Deprecated List<CellRegion> getAllArrayFormulas()
      Deprecated.
      since 7.0.0 — use getAllCseRegions() for the clearer name.
      Returns the list of legacy CSE array regions registered on this sheet via setArrayFormula(String, CellRegion). May miss XLSX-imported CSE regions that live only in the engine core; for a complete viewport-bounded list use getCseRegionsInViewport(int, int, int, int).
      Since:
      6.0.0

    • getAllCseRegions

      default List<CellRegion> getAllCseRegions()
      Returns the list of legacy CSE array regions registered on this sheet. Same scope as getAllArrayFormulas().
      Since:
      7.0.0
      See Also:

    • getSpillRangesInViewport

      default List<SSheet.SpillRangeInfo> getSpillRangesInViewport(int top, int left, int bottom, int right)
      Returns every dynamic-array spill range whose extent overlaps the inclusive viewport rectangle. Each entry carries the rectangle and a phantom flag: false for a successful spill (Excel paints a thin blue solid border), true for a blocked #SPILL! spill (Excel paints a dashed border).

      The default implementation returns an empty list. Engines that track dynamic-array spill ranges (the Rust core) override.

      Since:
      7.0.0

    • getCseRegionsInViewport

      default List<CellRegion> getCseRegionsInViewport(int top, int left, int bottom, int right)
      Returns every legacy-CSE array region whose extent overlaps the inclusive viewport rectangle, for painting the array outline (the aflrs wire field).

      The default implementation returns an empty list. The Rust core overrides it, sourcing the regions from the CSE region index so XLSX-imported CSE (which never enters getAllArrayFormulas()) is covered — symmetric with getSpillRangesInViewport(int, int, int, int).

      Since:
      7.0.0

    • setOutlineLevelRow

      void setOutlineLevelRow(int outlineLevelRow)
      Sets the maximum outline level for row represent of this sheet.
      Parameters:
      outlineLevelRow -
      Since:
      6.0.0

    • getOutlineLevelRow

      int getOutlineLevelRow()
      Returns the maximum outline level for row represent.
      Since:
      6.0.0

    • setOutlineLevelCol

      void setOutlineLevelCol(int outlineLevelCol)
      Sets the maximum outline level for column represent of this sheet.
      Parameters:
      outlineLevelCol -
      Since:
      6.0.0

    • getOutlineLevelCol

      int getOutlineLevelCol()
      Returns the maximum outline level for column represent.
      Since:
      6.0.0

    • isApplyStyles

      boolean isApplyStyles()
      Returns whether to apply the styles in outline.

      Default: false

      Since:
      6.0.0

    • setApplyStyles

      void setApplyStyles(boolean applyStyles)
      Sets to apply with the styles in outline.

      Note: Only used for maintaining model state. (not implemented for UI parts)

      Parameters:
      applyStyles - false not to apply
      Since:
      6.0.0

    • isSummaryBelow

      boolean isSummaryBelow()
      Returns whether to display summary below in outline for rows.

      Default: true

      Since:
      6.0.0

    • setSummaryBelow

      void setSummaryBelow(boolean summaryBelow)
      Sets to display summary below in outline for rows.

      Default: true

      Parameters:
      summaryBelow - false to display on top.
      Since:
      6.0.0

    • isSummaryRight

      boolean isSummaryRight()
      Returns whether to display summary right in outline for columns.

      Default: true

      Since:
      6.0.0

    • setSummaryRight

      void setSummaryRight(boolean summaryRight)
      Sets whether to display summary right in outline for columns.

      Default: true

      Parameters:
      summaryRight - false to display on left.
      Since:
      6.0.0

    • isShowOutlineSymbols

      boolean isShowOutlineSymbols()
      Returns whether to display outline symbols.

      Default: true

      Since:
      6.0.0

    • setShowOutlineSymbols

      void setShowOutlineSymbols(boolean showOutlineSymbols)
      Sets whether to display outline symbols.

      Default: true

      Parameters:
      showOutlineSymbols - false not to show.
      Since:
      6.0.0

    • addCellRegionValueChangeListener

      void addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)
      Adds the listener when specific cell region value change.
      Parameters:
      cellRegion -
      listener -
      Since:
      6.2.0

    • hasCellRegionValueChangeListeners

      default boolean hasCellRegionValueChangeListeners()
      IssueK790 / bulk-setValues: whether this sheet has any cell-region value-change listener registered. Range.setValues() disables its bulk fast path when this is true, so each changed cell still fires a per-cell event (the bulk single-region notification cannot reproduce that granularity). Default false.
      Since:
      7.0.0

    • removeCellRegionValueChangeListener

      boolean removeCellRegionValueChangeListener(CellRegion cellRegion)
      Remove all cell region value change listeners of specific cell region.
      Parameters:
      cellRegion -
      Returns:
      whether the listeners are removed successfully.
      Since:
      6.2.0

    • removeCellRegionValueChangeListener

      boolean removeCellRegionValueChangeListener(SerializableConsumer<CellRegion> listener)
      Remove the cell region value change listener.
      Parameters:
      listener -
      Returns:
      whether the listener is removed successfully.
      Since:
      6.2.0

    • addChart

      SChart addChart(String name, SChart.ChartType type, ViewAnchor anchor)
      Add a chart with name, type and anchor
      Parameters:
      name -
      type -
      anchor -
      Returns:
      the created chart
      Since:
      6.2.0

    • getChartByName

      SChart getChartByName(String name)
      Returns the first chart with specific name
      Parameters:
      name -
      Returns:
      the chart with specific name
      Since:
      6.2.0

    • getChartsByName

      List<SChart> getChartsByName(String name)
      Returns the charts with specific name
      Parameters:
      name -
      Returns:
      the charts with specific name
      Since:
      6.2.0

    • getCellWatches

      default List<CellRegion> getCellWatches()
      Returns the list of cell watches on this sheet.
      Returns:
      an unmodifiable list of cell regions being watched
      Since:
      7.0.0

    • addCellWatch

      default void addCellWatch(int row, int col)
      Adds a cell watch at the specified row and column.
      Parameters:
      row - the row index (0-based)
      col - the column index (0-based)
      Since:
      7.0.0

    • removeCellWatch

      default void removeCellWatch(int row, int col)
      Removes a cell watch at the specified row and column.
      Parameters:
      row - the row index (0-based)
      col - the column index (0-based)
      Since:
      7.0.0

    • getIgnoredErrors

      default List<SIgnoredError> getIgnoredErrors()
      Returns the list of ignored errors on this sheet.
      Returns:
      an unmodifiable list of ignored errors
      Since:
      7.0.0
      See Also:

    • addIgnoredError

      default void addIgnoredError(CellRegion range, ErrorCheckType... types)
      Adds an ignored error for the specified cell region and error check types.
      Parameters:
      range - the cell region
      types - the error check types to ignore
      Since:
      7.0.0
      See Also:

    • getScenarios

      default List<SScenario> getScenarios()
      Returns the list of scenarios (What-If Analysis) defined on this sheet.
      Returns:
      an unmodifiable list of scenarios
      Since:
      7.0.0

    • addScenario

      default SScenario addScenario(String name)
      Adds a new scenario with the given name.
      Parameters:
      name - the scenario name (must be unique within the sheet)
      Returns:
      the newly created scenario
      Since:
      7.0.0

    • removeScenario

      default void removeScenario(String name)
      Removes the scenario with the given name.
      Parameters:
      name - the scenario name
      Since:
      7.0.0

    • showScenario

      default void showScenario(String name)
      Applies the values from the named scenario to the sheet cells. Each input cell in the scenario will have its value set accordingly, triggering formula recalculation.
      Parameters:
      name - the scenario name
      Throws:
      IllegalArgumentException - if no scenario with the given name exists
      Since:
      7.0.0

    • getThreadedComments

      default List<SThreadedComment> getThreadedComments()
      Returns all threaded comments (root and replies) on this sheet.
      Returns:
      an unmodifiable list of threaded comments
      Since:
      7.0.0

    • addThreadedComment

      default SThreadedComment addThreadedComment(int row, int col, String text, SThreadedCommentAuthor author)
      Adds a new root threaded comment at the specified cell.
      Parameters:
      row - the row index (0-based)
      col - the column index (0-based)
      text - the comment text
      author - the comment author
      Returns:
      the newly created threaded comment
      Since:
      7.0.0

    • replyToComment

      default SThreadedComment replyToComment(SThreadedComment parent, String text, SThreadedCommentAuthor author)
      Adds a reply to an existing threaded comment.
      Parameters:
      parent - the parent comment to reply to
      text - the reply text
      author - the reply author
      Returns:
      the newly created reply comment
      Since:
      7.0.0

    • removeThreadedComment

      default void removeThreadedComment(SThreadedComment comment)
      Removes a threaded comment and all its replies from this sheet.
      Parameters:
      comment - the comment to remove
      Since:
      7.0.0

    • getProtectedRanges

      default List<SProtectedRange> getProtectedRanges()
      Returns all protected ranges on this sheet.
      Returns:
      an unmodifiable list of protected ranges
      Since:
      7.0.0

    • addProtectedRange

      default SProtectedRange addProtectedRange(String name, CellRegion range, String password)
      Adds a protected range to this sheet.
      Parameters:
      name - the range name
      range - the cell region
      password - the password (will be hashed), or null for no password
      Returns:
      the newly created protected range
      Since:
      7.0.0

    • removeProtectedRange

      default void removeProtectedRange(String name)
      Removes the protected range with the given name.
      Parameters:
      name - the range name
      Since:
      7.0.0

    • getPivotTables

      default List<SPivotTable> getPivotTables()
      Returns all pivot tables in this sheet.
      Returns:
      an unmodifiable list of pivot tables
      Since:
      7.0.0

    • addPivotTable

      default SPivotTable addPivotTable(String name, CellRegion sourceRange, CellRegion outputLocation)
      Adds a new pivot table to this sheet.
      Parameters:
      name - the pivot table name
      sourceRange - the source data range (on this sheet)
      outputLocation - the cell region where the pivot table will be placed
      Returns:
      the created pivot table
      Since:
      7.0.0

    • removePivotTable

      default void removePivotTable(String name)
      Removes a pivot table by name.
      Parameters:
      name - the name of the pivot table to remove
      Since:
      7.0.0

    • getSlicers

      default List<SSlicer> getSlicers()
      Returns all slicers in this sheet.
      Returns:
      an unmodifiable list of slicers
      Since:
      7.0.0

    • addSlicer

      default SSlicer addSlicer(String name, SPivotTable pivot, int fieldIndex)
      Adds a new slicer to this sheet.
      Parameters:
      name - the slicer name
      pivot - the pivot table this slicer will filter
      fieldIndex - the index of the pivot field to filter
      Returns:
      the created slicer
      Since:
      7.0.0

    • removeSlicer

      default void removeSlicer(String name)
      Removes a slicer by name.
      Parameters:
      name - the name of the slicer to remove
      Since:
      7.0.0

    • getTimelines

      default List<STimeline> getTimelines()
      Returns all timelines in this sheet.
      Returns:
      an unmodifiable list of timelines
      Since:
      7.0.0

    • addTimeline

      default STimeline addTimeline(String name, SPivotTable pivot, int fieldIndex)
      Adds a new timeline to this sheet.
      Parameters:
      name - the timeline name
      pivot - the pivot table this timeline will filter
      fieldIndex - the index of the date field to filter
      Returns:
      the created timeline
      Since:
      7.0.0

    • removeTimeline

      default void removeTimeline(String name)
      Removes a timeline by name.
      Parameters:
      name - the name of the timeline to remove
      Since:
      7.0.0

    • getOleObjects

      default List<SOleObject> getOleObjects()
      Returns all OLE objects on this sheet.
      Returns:
      an unmodifiable list of OLE objects
      Since:
      7.0.0

    • getFormControls

      default List<SFormControl> getFormControls()
      Returns all form controls on this sheet.
      Returns:
      an unmodifiable list of form controls
      Since:
      7.0.0

    • getSmartArt

      default List<SSmartArt> getSmartArt()
      Returns all SmartArt diagrams on this sheet.
      Returns:
      an unmodifiable list of SmartArt objects
      Since:
      7.0.0

    • getWordArt

      default List<SWordArt> getWordArt()
      Returns all WordArt objects on this sheet.
      Returns:
      an unmodifiable list of WordArt objects
      Since:
      7.0.0