Uses of Class
org.apache.poi.hssf.usermodel.HSSFSheet
-
Packages that use HSSFSheet Package Description 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 modelorg.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 Modifier and Type Method Description protected static int
AbstractExcelConverter. getColumnWidth(HSSFSheet sheet, int columnIndex)
protected static int
AbstractExcelConverter. getDefaultColumnWidth(HSSFSheet sheet)
protected void
ExcelToFoConverter. processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
protected void
ExcelToHtmlConverter. processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
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. processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
Creates COLGROUP element with width specified for all columns.protected float
ExcelToFoConverter. processSheet(HSSFWorkbook workbook, HSSFSheet sheet, org.w3c.dom.Element flow)
protected void
ExcelToHtmlConverter. processSheet(HSSFSheet sheet)
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 Modifier and Type Method Description static CFRule12Record
CFRule12Record. create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
Creates a new comparison operation rulestatic CFRule12Record
CFRule12Record. create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2, java.lang.String formulaTextScale)
Creates a new comparison operation rulestatic CFRule12Record
CFRule12Record. create(HSSFSheet sheet, java.lang.String formulaText)
Creates a new comparison operation rulestatic CFRule12Record
CFRule12Record. create(HSSFSheet sheet, ExtendedColor color)
Creates a new Data Bar formattingstatic CFRule12Record
CFRule12Record. create(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet)
Creates a new Icon Set / Multi-State formattingstatic CFRuleRecord
CFRuleRecord. create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
Creates a new comparison operation rulestatic CFRuleRecord
CFRuleRecord. create(HSSFSheet sheet, java.lang.String formulaText)
Creates a new comparison operation rulestatic CFRule12Record
CFRule12Record. createColorScale(HSSFSheet sheet)
Creates a new Color Scale / Color Gradient formattingstatic 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 Modifier and Type Field Description protected java.util.List<HSSFSheet>
HSSFWorkbook. _sheets
this holds the HSSFSheet objects attached to this workbookMethods in org.apache.poi.hssf.usermodel that return HSSFSheet Modifier and Type Method Description 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
HSSFCell. getSheet()
Returns the HSSFSheet this cell belongs toprotected HSSFSheet
HSSFPatriarch. getSheet()
HSSFSheet
HSSFPicture. getSheet()
HSSFSheet
HSSFRow. getSheet()
Returns the HSSFSheet this row belongs toHSSFSheet
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 Modifier and Type Method Description 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 Constructor Description 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.HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval)
Creates an HSSFCell from a CellValueRecordInterface.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 Constructor Description HSSFColumnShifter(HSSFSheet sh)
HSSFRowShifter(HSSFSheet sh)
-
Uses of HSSFSheet in org.apache.poi.hssf.util
Methods in org.apache.poi.hssf.util with parameters of type HSSFSheet Modifier and Type Method Description static void
HSSFRegionUtil. setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. 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 leftstatic void
HSSFRegionUtil. setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderRight attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the bottomBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the leftBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the rightBorderColor attribute of the HSSFRegionUtil objectstatic void
HSSFRegionUtil. setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated.Sets the topBorderColor attribute of the HSSFRegionUtil object
-