Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

## Uses of Class
org.apache.poi.hssf.usermodel.HSSFSheet

Packages that use HSSFSheet
org.apache.poi.hssf.record | Record package contains class representations for XLS binary strutures.
org.apache.poi.hssf.usermodel | usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
org.apache.poi.ss.usermodel |

Uses of HSSFSheet in org.apache.poi.hssf.record

Methods in org.apache.poi.hssf.record with parameters of type HSSFSheet
`static CFRuleRecord` | `CFRuleRecord.create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)` Creates a new comparison operation rule
`static CFRuleRecord` | `CFRuleRecord.create(HSSFSheet sheet, java.lang.String formulaText)` Creates a new comparison operation rule

Uses of HSSFSheet in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel that return HSSFSheet
`HSSFSheet` | `HSSFWorkbook.cloneSheet(int sheetIndex)` create an HSSFSheet from an existing sheet in the HSSFWorkbook.
`HSSFSheet` | `HSSFWorkbook.createSheet()` create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.
`HSSFSheet` | `HSSFWorkbook.createSheet(java.lang.String sheetname)` create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.
`HSSFSheet` | `HSSFRow.getSheet()` Returns the HSSFSheet this row belongs to
`HSSFSheet` | `HSSFCell.getSheet()` Returns the HSSFSheet this cell belongs to
`HSSFSheet` | `HSSFWorkbook.getSheet(java.lang.String name)` Get sheet with the given name (case insensitive match)
`HSSFSheet` | `HSSFWorkbook.getSheetAt(int index)` Get the HSSFSheet object at the given index.

Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet
`DVRecord` | `HSSFDataValidation.createDVRecord(HSSFSheet sheet)`
`float` | `HSSFClientAnchor.getAnchorHeightInPoints(HSSFSheet sheet)` Calculates the height of a client anchor in points.

Constructors in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet
`HSSFDataValidationHelper(HSSFSheet sheet)`
`HSSFFormulaEvaluator(HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Sep 2008) HSSFSheet parameter is ignored

Uses of HSSFSheet in org.apache.poi.hssf.util

Methods in org.apache.poi.hssf.util with parameters of type HSSFSheet
`static HSSFRow` | `HSSFCellUtil.getRow(int rowIndex, HSSFSheet sheet)` Get a row from the spreadsheet, and create it if it doesn't exist.
`static void` | `HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderBottom(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
`static void` | `HSSFRegionUtil.setBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderRight attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderRight(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderTop(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the bottomBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBottomBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the leftBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the rightBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setRightBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
`static void` | `HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the topBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setTopBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook)` Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`

Uses of HSSFSheet in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return HSSFSheet
`HSSFSheet` | `Workbook.cloneSheet(int sheetNum)` Create an Sheet from an existing sheet in the Workbook.
`HSSFSheet` | `Workbook.createSheet()` Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
`HSSFSheet` | `Workbook.createSheet(java.lang.String sheetname)` Create an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
`HSSFSheet` | `Row.getSheet()` Returns the Sheet this row belongs to
`HSSFSheet` | `Cell.getSheet()` Returns the sheet this cell belongs to
`HSSFSheet` | `Workbook.getSheet(java.lang.String name)` Get sheet with the given name
`HSSFSheet` | `Workbook.getSheetAt(int index)` Get the Sheet object at the given index.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES