Uses of Class
org.apache.poi.hssf.usermodel.HSSFSheet
Packages that use HSSFSheet
Package
Description
Record package contains class representations for XLS binary strutures.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
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 HSSFSheetModifier and TypeMethodDescriptionprotected static intAbstractExcelConverter.getColumnWidth(HSSFSheet sheet, int columnIndex) protected static intAbstractExcelConverter.getDefaultColumnWidth(HSSFSheet sheet) protected voidExcelToFoConverter.processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, Element table) protected voidExcelToHtmlConverter.processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, Element table) protected floatExcelToFoConverter.processColumnWidths(HSSFSheet sheet, int maxSheetColumns, Element table) Creates COLGROUP element with width specified for all columns.protected voidExcelToHtmlConverter.processColumnWidths(HSSFSheet sheet, int maxSheetColumns, Element table) Creates COLGROUP element with width specified for all columns.protected floatExcelToFoConverter.processSheet(HSSFWorkbook workbook, HSSFSheet sheet, Element flow) protected voidExcelToHtmlConverter.processSheet(HSSFSheet sheet) protected voidExcelToHtmlConverter.processSheetHeader(Element htmlBody, HSSFSheet sheet) protected voidExcelToFoConverter.processSheetName(HSSFSheet sheet, Element flow) -
Uses of HSSFSheet in org.apache.poi.hssf.record
Methods in org.apache.poi.hssf.record with parameters of type HSSFSheetModifier and TypeMethodDescriptionstatic CFRule12RecordCFRule12Record.create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2) Creates a new comparison operation rulestatic CFRule12RecordCFRule12Record.create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2, String formulaTextScale) Creates a new comparison operation rulestatic CFRule12RecordCreates a new comparison operation rulestatic CFRule12RecordCFRule12Record.create(HSSFSheet sheet, ExtendedColor color) Creates a new Data Bar formattingstatic CFRule12RecordCFRule12Record.create(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet) Creates a new Icon Set / Multi-State formattingstatic CFRuleRecordCFRuleRecord.create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2) Creates a new comparison operation rulestatic CFRuleRecordCreates a new comparison operation rulestatic CFRule12RecordCFRule12Record.createColorScale(HSSFSheet sheet) Creates a new Color Scale / Color Gradient formattingstatic Ptg[]CFRuleBase.parseFormula(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 HSSFSheetModifier and TypeFieldDescriptionHSSFWorkbook._sheetsthis holds the HSSFSheet objects attached to this workbookMethods in org.apache.poi.hssf.usermodel that return HSSFSheetModifier and TypeMethodDescriptionHSSFWorkbook.cloneSheet(int sheetIndex) create an HSSFSheet from an existing sheet in the HSSFWorkbook.HSSFWorkbook.createSheet()create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.HSSFWorkbook.createSheet(String sheetname) Create a new sheet for this Workbook and return the high level representation.HSSFCell.getSheet()Returns the HSSFSheet this cell belongs toprotected HSSFSheetHSSFPatriarch.getSheet()HSSFPicture.getSheet()HSSFRow.getSheet()Returns the HSSFSheet this row belongs toGet sheet with the given name (case insensitive match)HSSFWorkbook.getSheetAt(int index) Get the HSSFSheet object at the given index.Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFSheetModifier and TypeMethodDescriptionvoidHSSFChart.createBarChart(HSSFWorkbook workbook, HSSFSheet parentSheet) Creates a bar chart.HSSFDataValidation.createDVRecord(HSSFSheet sheet) floatHSSFClientAnchor.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 HSSFSheetModifierConstructorDescriptionprotectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col) Creates new Cell - Should only be called by HSSFRow.protectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type) Creates new Cell - Should only be called by HSSFRow.protectedHSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval) Creates an HSSFCell from a CellValueRecordInterface.protectedHSSFColorScaleFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet) protectedHSSFConditionalFormattingThreshold(Threshold threshold, HSSFSheet sheet) protectedHSSFDataBarFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet) protectedHSSFIconMultiStateFormatting(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 -
Uses of HSSFSheet in org.apache.poi.hssf.util
Methods in org.apache.poi.hssf.util with parameters of type HSSFSheetModifier and TypeMethodDescriptionstatic voidHSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.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 voidHSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderRight attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the borderBottom attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the bottomBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the leftBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the rightBorderColor attribute of the HSSFRegionUtil objectstatic voidHSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) Deprecated.Sets the topBorderColor attribute of the HSSFRegionUtil object