Package net.sf.jasperreports.poi.export
Class JRXlsExporter
- java.lang.Object
-
- net.sf.jasperreports.engine.JRAbstractExporter<RC,C,OutputStreamExporterOutput,E>
-
- net.sf.jasperreports.engine.export.ExcelAbstractExporter<RC,C,E>
-
- 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 String
XLS_EXPORTER_KEY
The exporter key, as used inGenericElementHandlerEnviroment.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
All Methods Static Methods Instance Methods Concrete Methods 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 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 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
-
-
-
-
Field Detail
-
XLS_EXPORTER_KEY
public static final String XLS_EXPORTER_KEY
The exporter key, as used inGenericElementHandlerEnviroment.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
-
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
-
-
Constructor Detail
-
JRXlsExporter
public JRXlsExporter()
- See Also:
JRXlsExporter(JasperReportsContext)
-
JRXlsExporter
public JRXlsExporter(JasperReportsContext jasperReportsContext)
-
-
Method Detail
-
getConfigurationInterface
protected Class<XlsExporterConfiguration> getConfigurationInterface()
-
getItemConfigurationInterface
protected Class<XlsReportConfiguration> getItemConfigurationInterface()
-
initExport
protected void initExport()
- Overrides:
initExport
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
initReport
protected void initReport()
- Overrides:
initReport
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
openWorkbook
protected void openWorkbook(OutputStream os)
- Specified by:
openWorkbook
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
createSheet
protected void createSheet(CutsInfo xCuts, JRXlsAbstractExporter.SheetInfo sheetInfo)
- Specified by:
createSheet
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
closeSheet
protected void closeSheet()
- Specified by:
closeSheet
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
closeWorkbook
protected void closeWorkbook(OutputStream os) throws JRException
- Specified by:
closeWorkbook
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
- Throws:
JRException
-
setColumnWidth
protected void setColumnWidth(int col, int width, boolean autoFit)
- Specified by:
setColumnWidth
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
setRowHeight
protected void setRowHeight(int rowIndex, int lastRowHeight, Cut yCut, XlsRowLevelInfo levelInfo)
- Specified by:
setRowHeight
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
addRowBreak
protected void addRowBreak(int rowIndex)
- Specified by:
addRowBreak
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
addBlankCell
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
- Specified by:
addBlankCell
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
addOccupiedCell
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
- Specified by:
addOccupiedCell
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
exportLine
protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int colIndex, int rowIndex)
- Specified by:
exportLine
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
exportRectangle
protected void exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex)
- Specified by:
exportRectangle
in classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
exportText
public void exportText(JRPrintText textElement, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
- Specified by:
exportText
in classJRXlsAbstractExporter<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 classJRXlsAbstractExporter<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 classJRXlsAbstractExporter<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 classJRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
- Throws:
JRException
-
setHyperlinkCell
protected void setHyperlinkCell(JRPrintHyperlink hyperlink)
-
getMaxRowsPerSheet
protected Integer getMaxRowsPerSheet()
- Overrides:
getMaxRowsPerSheet
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
getExporterKey
public String getExporterKey()
- Specified by:
getExporterKey
in classJRAbstractExporter<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 classJRAbstractExporter<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 classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
- Parameters:
rowIndex
- the freeze 0-based row indexcolIndex
- the freeze 0-based column index
-
setSheetName
protected void setSheetName(String sheetName)
- Specified by:
setSheetName
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
setAutoFilter
protected void setAutoFilter(String autoFilterRange)
- Specified by:
setAutoFilter
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
setRowLevels
protected void setRowLevels(XlsRowLevelInfo levelInfo, String level)
- Specified by:
setRowLevels
in classExcelAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
-
getAnchorType
public static org.apache.poi.ss.usermodel.ClientAnchor.AnchorType getAnchorType(ImageAnchorTypeEnum anchorType)
-
-