Class HSSFRegionUtil

java.lang.Object
org.apache.poi.hssf.util.HSSFRegionUtil

@Removal(version="4.2") public final class HSSFRegionUtil extends Object
Deprecated.
POI 4.0.0
Various utility functions that make working with a region of cells easier.
See Also:
  • Method Details

    • setBorderLeft

      public static void setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the left border 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
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setLeftBorderColor

      public static void setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the leftBorderColor attribute of the HSSFRegionUtil object
      Parameters:
      color - The color of the border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setBorderRight

      public static void setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the borderRight attribute of the HSSFRegionUtil object
      Parameters:
      border - The new border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setRightBorderColor

      public static void setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the rightBorderColor attribute of the HSSFRegionUtil object
      Parameters:
      color - The color of the border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setBorderBottom

      public static void setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the borderBottom attribute of the HSSFRegionUtil object
      Parameters:
      border - The new border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setBottomBorderColor

      public static void setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the bottomBorderColor attribute of the HSSFRegionUtil object
      Parameters:
      color - The color of the border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setBorderTop

      public static void setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the borderBottom attribute of the HSSFRegionUtil object
      Parameters:
      border - The new border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.
    • setTopBorderColor

      public static void setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
      Deprecated.
      Sets the topBorderColor attribute of the HSSFRegionUtil object
      Parameters:
      color - The color of the border
      region - The region that should have the border
      workbook - The workbook that the region is on.
      sheet - The sheet that the region is on.