Package net.sf.jasperreports.poi.export

Class JRXlsExporter

java.lang.Object

net.sf.jasperreports.engine.JRAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput,JRXlsExporterContext>

net.sf.jasperreports.engine.export.ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

net.sf.jasperreports.engine.export.JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

net.sf.jasperreports.poi.export.JRXlsExporter

All Implemented Interfaces:

Exporter<ExporterInput,XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput>

public class JRXlsExporter
extends JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Exports a JasperReports document to XLS format. It has binary output type and exports the document to a grid-based layout.

Author:

Teodor Danciu (teodord@users.sourceforge.net)

See Also:

• JRXlsAbstractExporter
• XlsExporterConfiguration
• XlsReportConfiguration

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected class	JRXlsExporter.ExporterContext
protected class	JRXlsExporter.StyleInfo

Nested classes/interfaces inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter

JRXlsAbstractExporter.SheetInfo

Nested classes/interfaces inherited from class net.sf.jasperreports.engine.export.ExcelAbstractExporter

ExcelAbstractExporter.NameScope, ExcelAbstractExporter.TextAlignHolder

Nested classes/interfaces inherited from class net.sf.jasperreports.engine.JRAbstractExporter

JRAbstractExporter.BaseExporterContext, JRAbstractExporter.PageRange

Field Summary

Fields

Modifier and Type	Field	Description
protected Map<String,List<org.apache.poi.ss.usermodel.Hyperlink>>	anchorLinks
protected Map<String,org.apache.poi.hssf.usermodel.HSSFName>	anchorNames
protected Map<org.apache.poi.hssf.usermodel.HSSFSheet,List<Integer>>	autofitColumns
protected org.apache.poi.ss.usermodel.FillPatternType	backgroundMode
protected short	blackIndex
protected org.apache.poi.hssf.usermodel.HSSFCell	cell
protected org.apache.poi.ss.usermodel.CreationHelper	createHelper
protected short	customColorIndex
protected org.apache.poi.hssf.usermodel.HSSFDataFormat	dataFormat
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	emptyCellStyle
protected Map<org.apache.poi.hssf.usermodel.HSSFCell,String>	formulaCellsMap
protected Map<JRXlsExporter.StyleInfo,org.apache.poi.hssf.usermodel.HSSFCellStyle>	loadedCellStyles
static short	MAX_COLOR_INDEX
static short	MIN_COLOR_INDEX
protected Map<Integer,List<org.apache.poi.ss.usermodel.Hyperlink>>	pageLinks
protected org.apache.poi.hssf.usermodel.HSSFPatriarch	patriarch
protected org.apache.poi.hssf.usermodel.HSSFRow	row
protected org.apache.poi.hssf.usermodel.HSSFSheet	sheet
protected short	whiteIndex
protected org.apache.poi.hssf.usermodel.HSSFWorkbook	workbook
static final String	XLS_EXPORTER_KEY	The exporter key, as used in GenericElementHandlerEnviroment.getElementHandler(JRGenericElementType, String).

Fields inherited from class net.sf.jasperreports.engine.export.ExcelAbstractExporter

autoFilterEnd, autoFilterStart, collapseRowSpan, CURRENT_ROW_AUTOFIT, CURRENT_ROW_HEIGHT, DEFAULT_DEFINED_NAME_SCOPE, DEFAULT_DEFINED_NAME_SCOPE_SEPARATOR, DEFAULT_SHEET_NAME_PREFIX, defaultCellHidden, defaultCellLocked, defaultFont, defaultIgnoreHyperlink, defaultIgnoreTextFormatting, defaultImageAnchorType, defaultShrinkToFit, defaultUseTimeZone, defaultWrapText, definedNamesMap, detectCellType, EXCEPTION_MESSAGE_KEY_CANNOT_ADD_CELL, EXCEPTION_MESSAGE_KEY_CANNOT_MERGE_CELLS, EXCEPTION_MESSAGE_KEY_CELL_FORMAT_TEMPLATE_ERROR, EXCEPTION_MESSAGE_KEY_COLUMN_INDEX_BEYOND_LIMIT, EXCEPTION_MESSAGE_KEY_LOADED_FONTS_ERROR, EXCEPTION_MESSAGE_KEY_NEGATIVE_COLUMN_INDEX, EXCEPTION_MESSAGE_KEY_REPORT_GENERATION_ERROR, EXCEPTION_MESSAGE_KEY_TEMPLATE_NOT_FOUND, firstPageNotSet, formatPatternsMap, ignoreAnchors, imageBorderFixEnabled, invalidCharReplacement, keepTemplateSheets, loadedFonts, maxColumnIndex, nature, onePagePerSheet, onePagePerSheetMap, pageFormat, pageIndex, PROPERTY_AUTO_FILTER, PROPERTY_AUTO_FIT_COLUMN, PROPERTY_AUTO_FIT_ROW, PROPERTY_AVERAGE_CHAR_WIDTH_FACTOR, PROPERTY_BREAK_AFTER_ROW, PROPERTY_BREAK_BEFORE_ROW, PROPERTY_CELL_FORMULA, PROPERTY_CELL_PATTERN, PROPERTY_COLUMN_NAME, PROPERTY_COLUMN_WIDTH, PROPERTY_COLUMN_WIDTH_METADATA, PROPERTY_DATA, PROPERTY_FREEZE_COLUMN_EDGE, PROPERTY_FREEZE_ROW_EDGE, PROPERTY_IGNORE_ROW_HEIGHT, PROPERTY_REPEAT_VALUE, PROPERTY_ROW_OUTLINE_LEVEL_PREFIX, PROPERTY_SHEET_NAME, renderersCache, reportIndex, sheetIndex, sheetInfo, sheetNames, sheetNamesIndex, sheetNamesMap, sheetsBeforeCurrentReport, sheetsBeforeCurrentReportMap, workbookTemplate, XLS_EXPORTER_PROPERTIES_PREFIX

Fields inherited from class net.sf.jasperreports.engine.JRAbstractExporter

allSelector, crtCompositeConfiguration, crtCompositeItemConfiguration, crtItem, dateFormatCache, EXCEPTION_MESSAGE_KEY_EMPTY_INPUT_SOURCE_IN_BATCH_MODE, EXCEPTION_MESSAGE_KEY_END_PAGE_INDEX_OUT_OF_RANGE, EXCEPTION_MESSAGE_KEY_INVALID_IMAGE_NAME, EXCEPTION_MESSAGE_KEY_INVALID_ZOOM_RATIO, EXCEPTION_MESSAGE_KEY_NO_INPUT_SOURCE, EXCEPTION_MESSAGE_KEY_NO_OUTPUT_SPECIFIED, EXCEPTION_MESSAGE_KEY_OUTPUT_WRITER_ERROR, EXCEPTION_MESSAGE_KEY_PAGE_INDEX_OUT_OF_RANGE, EXCEPTION_MESSAGE_KEY_START_PAGE_INDEX_OUT_OF_RANGE, exporterConfiguration, exporterContext, exporterInput, exporterOutput, filter, fontUtil, hyperlinkProducerFactory, itemConfiguration, jasperPrint, jasperReportsContext, noBackcolorSelector, noneSelector, numberFormatCache, propertiesUtil, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, rendererUtil, styledTextUtil, textValueClasses

Constructor Summary

Constructors

Constructor	Description
JRXlsExporter()
JRXlsExporter(JasperReportsContext jasperReportsContext)

Method Summary

Modifier and Type	Method	Description
protected void	addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
protected void	addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
protected void	addRowBreak(int rowIndex)
protected void	closeSheet()
protected void	closeWorkbook(OutputStream os)
protected void	createMergeRegion(JRExporterGridCell gridCell, int colIndex, int rowIndex, org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)
protected void	createSheet(CutsInfo xCuts, JRXlsAbstractExporter.SheetInfo sheetInfo)
protected void	createTextCell(JRPrintText textElement, JRExporterGridCell gridCell, int colIndex, int rowIndex, JRStyledText styledText, JRXlsExporter.StyleInfo baseStyle, short forecolor)
protected void	endCreateCell(org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)
protected void	exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int x, int y)
protected void	exportGenericElement(JRGenericPrintElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout)
void	exportImage(JRPrintImage element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout)
protected void	exportLine(JRPrintLine line, JRExporterGridCell gridCell, int colIndex, int rowIndex)
protected void	exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex)
void	exportText(JRPrintText textElement, JRExporterGridCell gridCell, int colIndex, int rowIndex)
static org.apache.poi.ss.usermodel.ClientAnchor.AnchorType	getAnchorType(ImageAnchorTypeEnum anchorType)
protected static org.apache.poi.ss.usermodel.BorderStyle	getBorderStyle(JRPen pen)
protected double	getColumnRelativePosition(JRGridLayout layout, int col, int offset)
protected Class<XlsExporterConfiguration>	getConfigurationInterface()
String	getExporterKey()
String	getExporterPropertiesPrefix()	Returns the properties prefix for the current exporter.
protected Class<XlsReportConfiguration>	getItemConfigurationInterface()
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	getLoadedCellStyle(JRXlsExporter.StyleInfo style)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	getLoadedCellStyle(org.apache.poi.ss.usermodel.FillPatternType mode, short backcolor, org.apache.poi.ss.usermodel.HorizontalAlignment horizontalAlignment, org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, JRExporterGridCell gridCell, boolean isWrapText, boolean isCellLocked, boolean isCellHidden, boolean isShrinkToFit)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	getLoadedCellStyle(org.apache.poi.ss.usermodel.FillPatternType mode, short backcolor, org.apache.poi.ss.usermodel.HorizontalAlignment horizontalAlignment, org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, net.sf.jasperreports.poi.export.JRXlsExporter.BoxStyle box, boolean isWrapText, boolean isCellLocked, boolean isCellHidden, boolean isShrinkToFit)
protected org.apache.poi.hssf.usermodel.HSSFFont	getLoadedFont(JRFont font, short forecolor, Map<AttributedCharacterIterator.Attribute,Object> attributes, Locale locale)
protected Integer	getMaxRowsPerSheet()
protected org.apache.poi.hssf.util.HSSFColor	getNearestColor(Color awtColor)
protected org.apache.poi.hssf.usermodel.HSSFRichTextString	getRichTextString(JRStyledText styledText, short forecolor, JRFont defaultFont, Locale locale)
protected double	getRowRelativePosition(JRGridLayout layout, int row, int offset)
protected org.apache.poi.hssf.util.HSSFColor	getWorkbookColor(Color awtColor)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle	initCreateCell(JRExporterGridCell gridCell, int colIndex, int rowIndex, JRXlsExporter.StyleInfo baseStyle)
protected void	initExport()
protected void	initReport()
protected void	openWorkbook(OutputStream os)
protected void	setAutoFilter(String autoFilterRange)
protected void	setColumnWidth(int col, int width, boolean autoFit)
protected void	setFreezePane(int rowIndex, int colIndex)	Creates a freeze pane for the current sheet.
protected void	setHyperlinkCell(JRPrintHyperlink hyperlink)
protected final void	setRichTextStringCellValue(JRStyledText styledText, short forecolor, JRFont defaultFont, Locale locale)
protected void	setRowHeight(int rowIndex, int lastRowHeight, Cut yCut, XlsRowLevelInfo levelInfo)
protected void	setRowLevels(XlsRowLevelInfo levelInfo, String level)
protected void	setSheetName(String sheetName)
protected final void	setStringCellValue(String textStr)

Methods inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter

configureHeaderFooter, configurePrintSettings, exportEmptyReport, exportPage, exportReportToStream, exportSheet, getSheetProps, setColumnWidths

Methods inherited from class net.sf.jasperreports.engine.export.ExcelAbstractExporter

calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, configureDefinedNames, configureDefinedNames, configureDefinedNames, ensureInput, exportReport, getColumIndexName, getColumnIndex, getColumnName, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getNature, getSheetName, getSheetName, getStyledText, getTextAlignHolder, hasGlobalSheetNames, isCellHidden, isCellLocked, isIgnoreTextFormatting, isShrinkToFit, isUseTimeZone, isValidScale, isWrapText, mergeAndSetRowLevels, resetAutoFilters, setSheetNames, toExcelName, translateDateValue, updateHeaderFooter, updatePrintSettings

Methods inherited from class net.sf.jasperreports.engine.JRAbstractExporter

checkInterrupted, createFilter, defaultParseNumber, ensureJasperReportsContext, ensureOutput, getBooleanCellValue, getCurrentConfiguration, getCurrentItemConfiguration, getCurrentJasperPrint, getDateCellValue, getDateFormat, getExporterConfiguration, getExporterContext, getExporterInput, getExporterOutput, getHyperlinkProducer, getJasperReportsContext, getLocale, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getPageRange, getPropertiesUtil, getRendererUtil, getReportContext, getReportExportConfiguration, getRepository, getStyledText, getTextFormatFactoryClass, getTextLocale, getTextTimeZone, getTextValue, getTextValueString, insideFrame, reset, resetExportContext, restoreElementOffsets, setConfiguration, setConfiguration, setCurrentExporterInputItem, setExporterInput, setExporterOutput, setFrameElementsOffset, setJasperReportsContext, setOffset, setOffset, setReportContext

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

XLS_EXPORTER_KEY

public static final String XLS_EXPORTER_KEY

The exporter key, as used in GenericElementHandlerEnviroment.getElementHandler(JRGenericElementType, String).

See Also:

• Constant Field Values

MAX_COLOR_INDEX

public static short MAX_COLOR_INDEX

MIN_COLOR_INDEX

public static short MIN_COLOR_INDEX

loadedCellStyles

protected Map<JRXlsExporter.StyleInfo,org.apache.poi.hssf.usermodel.HSSFCellStyle> loadedCellStyles

anchorLinks

protected Map<String,List<org.apache.poi.ss.usermodel.Hyperlink>> anchorLinks

pageLinks

protected Map<Integer,List<org.apache.poi.ss.usermodel.Hyperlink>> pageLinks

anchorNames

protected Map<String,org.apache.poi.hssf.usermodel.HSSFName> anchorNames

autofitColumns

protected Map<org.apache.poi.hssf.usermodel.HSSFSheet,List<Integer>> autofitColumns

workbook

protected org.apache.poi.hssf.usermodel.HSSFWorkbook workbook

sheet

protected org.apache.poi.hssf.usermodel.HSSFSheet sheet

row

protected org.apache.poi.hssf.usermodel.HSSFRow row

cell

protected org.apache.poi.hssf.usermodel.HSSFCell cell

emptyCellStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle emptyCellStyle

createHelper

protected org.apache.poi.ss.usermodel.CreationHelper createHelper

whiteIndex

protected short whiteIndex

blackIndex

protected short blackIndex

customColorIndex

protected short customColorIndex

backgroundMode

protected org.apache.poi.ss.usermodel.FillPatternType backgroundMode

dataFormat

protected org.apache.poi.hssf.usermodel.HSSFDataFormat dataFormat

patriarch

protected org.apache.poi.hssf.usermodel.HSSFPatriarch patriarch

formulaCellsMap

protected Map<org.apache.poi.hssf.usermodel.HSSFCell,String> formulaCellsMap

Constructor Details

JRXlsExporter

public JRXlsExporter()

See Also:

• JRXlsExporter(JasperReportsContext)

JRXlsExporter

public JRXlsExporter(JasperReportsContext jasperReportsContext)

Method Details

getConfigurationInterface

protected Class<XlsExporterConfiguration> getConfigurationInterface()

Specified by:

getConfigurationInterface in class JRAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput,JRXlsExporterContext>

getItemConfigurationInterface

protected Class<XlsReportConfiguration> getItemConfigurationInterface()

Specified by:

getItemConfigurationInterface in class JRAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput,JRXlsExporterContext>

initExport

protected void initExport()

Overrides:

initExport in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

initReport

protected void initReport()

Overrides:

initReport in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

openWorkbook

protected void openWorkbook(OutputStream os)

Specified by:

openWorkbook in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

createSheet

protected void createSheet(CutsInfo xCuts,
 JRXlsAbstractExporter.SheetInfo sheetInfo)

Specified by:

createSheet in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

closeSheet

protected void closeSheet()

Specified by:

closeSheet in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

closeWorkbook

protected void closeWorkbook(OutputStream os)
                      throws JRException

Specified by:

closeWorkbook in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Throws:

JRException

setColumnWidth

protected void setColumnWidth(int col,
 int width,
 boolean autoFit)

Specified by:

setColumnWidth in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

setRowHeight

protected void setRowHeight(int rowIndex,
 int lastRowHeight,
 Cut yCut,
 XlsRowLevelInfo levelInfo)

Specified by:

setRowHeight in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

addRowBreak

protected void addRowBreak(int rowIndex)

Specified by:

addRowBreak in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

addBlankCell

protected void addBlankCell(JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex)

Specified by:

addBlankCell in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

addOccupiedCell

protected void addOccupiedCell(OccupiedGridCell occupiedGridCell,
 int colIndex,
 int rowIndex)

Specified by:

addOccupiedCell in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

exportLine

protected void exportLine(JRPrintLine line,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex)

Specified by:

exportLine in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

exportRectangle

protected void exportRectangle(JRPrintGraphicElement element,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex)

Specified by:

exportRectangle in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

exportText

public void exportText(JRPrintText textElement,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex)
                throws JRException

Specified by:

exportText in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Throws:

JRException

createTextCell

protected void createTextCell(JRPrintText textElement,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex,
 JRStyledText styledText,
 JRXlsExporter.StyleInfo baseStyle,
 short forecolor)
                       throws JRException

Throws:

JRException

initCreateCell

protected org.apache.poi.hssf.usermodel.HSSFCellStyle initCreateCell(JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex,
 JRXlsExporter.StyleInfo baseStyle)

endCreateCell

protected void endCreateCell(org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)

setStringCellValue

protected final void setStringCellValue(String textStr)

setRichTextStringCellValue

protected final void setRichTextStringCellValue(JRStyledText styledText,
 short forecolor,
 JRFont defaultFont,
 Locale locale)

getRichTextString

protected org.apache.poi.hssf.usermodel.HSSFRichTextString getRichTextString(JRStyledText styledText,
 short forecolor,
 JRFont defaultFont,
 Locale locale)

createMergeRegion

protected void createMergeRegion(JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex,
 org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)

getWorkbookColor

protected org.apache.poi.hssf.util.HSSFColor getWorkbookColor(Color awtColor)

getNearestColor

protected org.apache.poi.hssf.util.HSSFColor getNearestColor(Color awtColor)

getLoadedFont

protected org.apache.poi.hssf.usermodel.HSSFFont getLoadedFont(JRFont font,
 short forecolor,
 Map<AttributedCharacterIterator.Attribute,Object> attributes,
 Locale locale)

getLoadedCellStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(JRXlsExporter.StyleInfo style)

getLoadedCellStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(org.apache.poi.ss.usermodel.FillPatternType mode,
 short backcolor,
 org.apache.poi.ss.usermodel.HorizontalAlignment horizontalAlignment,
 org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment,
 short rotation,
 org.apache.poi.hssf.usermodel.HSSFFont font,
 JRExporterGridCell gridCell,
 boolean isWrapText,
 boolean isCellLocked,
 boolean isCellHidden,
 boolean isShrinkToFit)

getLoadedCellStyle

protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(org.apache.poi.ss.usermodel.FillPatternType mode,
 short backcolor,
 org.apache.poi.ss.usermodel.HorizontalAlignment horizontalAlignment,
 org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment,
 short rotation,
 org.apache.poi.hssf.usermodel.HSSFFont font,
 net.sf.jasperreports.poi.export.JRXlsExporter.BoxStyle box,
 boolean isWrapText,
 boolean isCellLocked,
 boolean isCellHidden,
 boolean isShrinkToFit)

getBorderStyle

protected static org.apache.poi.ss.usermodel.BorderStyle getBorderStyle(JRPen pen)

exportImage

public void exportImage(JRPrintImage element,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex,
 int emptyCols,
 int yCutsRow,
 JRGridLayout layout)
                 throws JRException

Specified by:

exportImage in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Throws:

JRException

getColumnRelativePosition

protected double getColumnRelativePosition(JRGridLayout layout,
 int col,
 int offset)

getRowRelativePosition

protected double getRowRelativePosition(JRGridLayout layout,
 int row,
 int offset)

exportFrame

protected void exportFrame(JRPrintFrame frame,
 JRExporterGridCell gridCell,
 int x,
 int y)

Specified by:

exportFrame in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

exportGenericElement

protected void exportGenericElement(JRGenericPrintElement element,
 JRExporterGridCell gridCell,
 int colIndex,
 int rowIndex,
 int emptyCols,
 int yCutsRow,
 JRGridLayout layout)
                             throws JRException

Specified by:

exportGenericElement in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Throws:

JRException

setHyperlinkCell

protected void setHyperlinkCell(JRPrintHyperlink hyperlink)

getMaxRowsPerSheet

protected Integer getMaxRowsPerSheet()

Overrides:

getMaxRowsPerSheet in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

getExporterKey

public String getExporterKey()

Specified by:

getExporterKey in class JRAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput,JRXlsExporterContext>

getExporterPropertiesPrefix

public String getExporterPropertiesPrefix()

Description copied from class: JRAbstractExporter

Returns the properties prefix for the current exporter.

Specified by:

getExporterPropertiesPrefix in class JRAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput,JRXlsExporterContext>

Returns:

the properties prefix for the current exporter

setFreezePane

protected void setFreezePane(int rowIndex,
 int colIndex)

Creates a freeze pane for the current sheet. Freeze pane row and column indexes defined at element level override indexes defined at report level. If multiple row freeze indexes are found in the same sheet, their maximum value is considered.

Specified by:

setFreezePane in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Parameters:

rowIndex - the freeze 0-based row index

colIndex - the freeze 0-based column index

setSheetName

protected void setSheetName(String sheetName)

Specified by:

setSheetName in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

setAutoFilter

protected void setAutoFilter(String autoFilterRange)

Specified by:

setAutoFilter in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

setRowLevels

protected void setRowLevels(XlsRowLevelInfo levelInfo,
 String level)

Specified by:

setRowLevels in class ExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

getAnchorType

public static org.apache.poi.ss.usermodel.ClientAnchor.AnchorType getAnchorType(ImageAnchorTypeEnum anchorType)