Class RegionUtil

java.lang.Object
org.apache.poi.ss.util.RegionUtil

public final class RegionUtil extends Object
Various utility functions that make working with a region of cells easier.
  • Method Details

    • setBorderLeft

      public static void setBorderLeft(BorderStyle border, CellRangeAddress region, Sheet sheet)
      Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left
      Parameters:
      border - The new border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.16 beta 1
    • setLeftBorderColor

      public static void setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet)
      Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left
      Parameters:
      color - The color of the border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.15 beta 2
    • setBorderRight

      public static void setBorderRight(BorderStyle border, CellRangeAddress region, Sheet sheet)
      Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right
      Parameters:
      border - The new border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.16 beta 1
    • setRightBorderColor

      public static void setRightBorderColor(int color, CellRangeAddress region, Sheet sheet)
      Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right
      Parameters:
      color - The color of the border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.15 beta 2
    • setBorderBottom

      public static void setBorderBottom(BorderStyle border, CellRangeAddress region, Sheet sheet)
      Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom
      Parameters:
      border - The new border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.16 beta 1
    • setBottomBorderColor

      public static void setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet)
      Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom
      Parameters:
      color - The color of the border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.15 beta 2
    • setBorderTop

      public static void setBorderTop(BorderStyle border, CellRangeAddress region, Sheet sheet)
      Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top
      Parameters:
      border - The new border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.16 beta 1
    • setTopBorderColor

      public static void setTopBorderColor(int color, CellRangeAddress region, Sheet sheet)
      Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top
      Parameters:
      color - The color of the border
      region - The region that should have the border
      sheet - The sheet that the region is on.
      Since:
      POI 3.15 beta 2