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.converter |
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.usermodel.helpers |
org.apache.poi.hssf.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.

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

Methods in org.apache.poi.hssf.converter with parameters of type HSSFSheet
`static CellRangeAddress[][]` | `ExcelToHtmlUtils.buildMergedRangesMap(HSSFSheet sheet)` Creates a map (i.e.
`protected static int` | `AbstractExcelConverter.getColumnWidth(HSSFSheet sheet, int columnIndex)`
`protected static int` | `AbstractExcelConverter.getDefaultColumnWidth(HSSFSheet sheet)`
`protected void` | `ExcelToHtmlConverter.processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)`
`protected void` | `ExcelToFoConverter.processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)`
`protected void` | `ExcelToHtmlConverter.processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)` Creates COLGROUP element with width specified for all columns.
`protected float` | `ExcelToFoConverter.processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)` Creates COLGROUP element with width specified for all columns.
`protected void` | `ExcelToHtmlConverter.processSheet(HSSFSheet sheet)`
`protected float` | `ExcelToFoConverter.processSheet(HSSFWorkbook workbook, HSSFSheet sheet, org.w3c.dom.Element flow)`
`protected void` | `ExcelToHtmlConverter.processSheetHeader(org.w3c.dom.Element htmlBody, HSSFSheet sheet)`
`protected void` | `ExcelToFoConverter.processSheetName(HSSFSheet sheet, org.w3c.dom.Element flow)`

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

Methods in org.apache.poi.hssf.record with parameters of type HSSFSheet
`static CFRule12Record` | `CFRule12Record.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, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)` Creates a new comparison operation rule
`static CFRule12Record` | `CFRule12Record.create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2, java.lang.String formulaTextScale)` Creates a new comparison operation rule
`static CFRule12Record` | `CFRule12Record.create(HSSFSheet sheet, ExtendedColor color)` Creates a new Data Bar formatting
`static CFRule12Record` | `CFRule12Record.create(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet)` Creates a new Icon Set / Multi-State formatting
`static CFRule12Record` | `CFRule12Record.create(HSSFSheet sheet, java.lang.String formulaText)` Creates a new comparison operation rule
`static CFRuleRecord` | `CFRuleRecord.create(HSSFSheet sheet, java.lang.String formulaText)` Creates a new comparison operation rule
`static CFRule12Record` | `CFRule12Record.createColorScale(HSSFSheet sheet)` Creates a new Color Scale / Color Gradient formatting
`static Ptg[]` | `CFRuleBase.parseFormula(java.lang.String formula, HSSFSheet sheet)` TODO - parse conditional format formulas properly i.e.

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

Fields in org.apache.poi.hssf.usermodel with type parameters of type HSSFSheet
`protected java.util.List<HSSFSheet>` | `HSSFWorkbook._sheets` this holds the HSSFSheet objects attached to this workbook

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 a new sheet for this Workbook and return the high level representation.
`HSSFSheet` | `HSSFRow.getSheet()` Returns the HSSFSheet this row belongs to
`HSSFSheet` | `HSSFPicture.getSheet()`
`HSSFSheet` | `HSSFCell.getSheet()` Returns the HSSFSheet this cell belongs to
`protected HSSFSheet` | `HSSFPatriarch.getSheet()`
`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
`void` | `HSSFChart.createBarChart(HSSFWorkbook workbook, HSSFSheet parentSheet)` Creates a bar chart.
`DVRecord` | `HSSFDataValidation.createDVRecord(HSSFSheet sheet)`
`float` | `HSSFClientAnchor.getAnchorHeightInPoints(HSSFSheet sheet)` Calculates the height of a client anchor in points.
`static HSSFChart[]` | `HSSFChart.getSheetCharts(HSSFSheet sheet)` Returns all the charts for the given sheet.

Constructors in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet
`HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval)` Creates an HSSFCell from a CellValueRecordInterface.
`HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col)` Creates new Cell - Should only be called by HSSFRow.
`HSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type)` Creates new Cell - Should only be called by HSSFRow.
`HSSFColorScaleFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)`
`HSSFConditionalFormattingThreshold(Threshold threshold, HSSFSheet sheet)`
`HSSFDataBarFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)`
`HSSFDataValidationHelper(HSSFSheet sheet)`
`HSSFIconMultiStateFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)`

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

Constructors in org.apache.poi.hssf.usermodel.helpers with parameters of type HSSFSheet
`HSSFRowShifter(HSSFSheet sh)`

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

Methods in org.apache.poi.hssf.util with parameters of type HSSFSheet
`static void` | `HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`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.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderRight attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the bottomBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the leftBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the rightBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the topBorderColor attribute of the HSSFRegionUtil object

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

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.