JRXlsExporter (JasperReports 6.1.1 API)

java.lang.Object
- net.sf.jasperreports.engine.JRAbstractExporter<RC,C,OutputStreamExporterOutput,E>
- - net.sf.jasperreports.engine.export.JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>
  - - net.sf.jasperreports.engine.export.JRXlsExporter

All Implemented Interfaces:

JRExporter<ExporterInput,XlsReportConfiguration,XlsExporterConfiguration,OutputStreamExporterOutput>, 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 and Description

protected class JRXlsExporter.ExporterContext

protected class JRXlsExporter.StyleInfo
- Nested classes/interfaces inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
  JRXlsAbstractExporter.SheetInfo, JRXlsAbstractExporter.TextAlignHolder
- Nested classes/interfaces inherited from class net.sf.jasperreports.engine.JRAbstractExporter
  JRAbstractExporter.BaseExporterContext, JRAbstractExporter.PageRange

Nested Classes
Modifier and Type	Class and Description
`protected class`	`JRXlsExporter.ExporterContext`
`protected class`	`JRXlsExporter.StyleInfo`

Field Summary

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

Fields inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
autoFilterEnd, autoFilterStart, DEFAULT_SHEET_NAME_PREFIX, defaultFont, 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, gridColumnFreezeIndex, gridRowFreezeIndex, invalidCharReplacement, isFreezeColumnEdge, isFreezeRowEdge, keepTemplateSheets, loadedFonts, maxColumnFreezeIndex, maxColumnIndex, maxRowFreezeIndex, nature, onePagePerSheetMap, pageFormat, pageIndex, PROPERTY_AUTO_FILTER, PROPERTY_AUTO_FIT_COLUMN, PROPERTY_AUTO_FIT_ROW, PROPERTY_BREAK_AFTER_ROW, PROPERTY_BREAK_BEFORE_ROW, PROPERTY_CELL_FORMULA, PROPERTY_CELL_HIDDEN, PROPERTY_CELL_LOCKED, PROPERTY_CELL_PATTERN, PROPERTY_COLUMN_WIDTH, PROPERTY_COLUMN_WIDTH_RATIO, PROPERTY_FIRST_PAGE_NUMBER, PROPERTY_FIT_HEIGHT, PROPERTY_FIT_WIDTH, PROPERTY_FREEZE_COLUMN, PROPERTY_FREEZE_COLUMN_EDGE, PROPERTY_FREEZE_ROW, PROPERTY_FREEZE_ROW_EDGE, PROPERTY_IGNORE_ANCHORS, PROPERTY_IGNORE_HYPERLINK, PROPERTY_IMAGE_ANCHOR_TYPE, PROPERTY_PAGE_SCALE, PROPERTY_ROW_OUTLINE_LEVEL_PREFIX, PROPERTY_SHEET_DIRECTION, PROPERTY_SHEET_FOOTER_CENTER, PROPERTY_SHEET_FOOTER_LEFT, PROPERTY_SHEET_FOOTER_RIGHT, PROPERTY_SHEET_HEADER_CENTER, PROPERTY_SHEET_HEADER_LEFT, PROPERTY_SHEET_HEADER_RIGHT, PROPERTY_SHEET_NAME, PROPERTY_SHOW_GRIDLINES, PROPERTY_USE_TIMEZONE, PROPERTY_WORKBOOK_TEMPLATE, PROPERTY_WORKBOOK_TEMPLATE_KEEP_SHEETS, PROPERTY_WRAP_TEXT, reportIndex, sheetIndex, sheetInfo, sheetNames, sheetNamesIndex, sheetNamesMap, sheetsBeforeCurrentReport, sheetsBeforeCurrentReportMap, workbookTemplate, XLS_EXPORTER_PROPERTIES_PREFIX

Constructor Summary

Constructors
Constructor and Description

JRXlsExporter()

JRXlsExporter(JasperReportsContext jasperReportsContext)

Constructors
Constructor and Description
`JRXlsExporter()`
`JRXlsExporter(JasperReportsContext jasperReportsContext)`

Method Summary

Methods
Modifier and Type	Method and 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(java.io.OutputStream os)`
`protected void`	`createMergeRegion(JRExporterGridCell gridCell, int colIndex, int rowIndex, 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(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)`
`protected static short`	`getBorderStyle(JRPen pen)`
`protected double`	`getColumnRelativePosition(JRGridLayout layout, int col, int offset)`
`protected java.lang.Class<XlsExporterConfiguration>`	`getConfigurationInterface()`
`java.lang.String`	`getExporterKey()`
`java.lang.String`	`getExporterPropertiesPrefix()` Returns the properties prefix for the current exporter.
`protected java.lang.Class<XlsReportConfiguration>`	`getItemConfigurationInterface()`
`protected HSSFCellStyle`	`getLoadedCellStyle(JRXlsExporter.StyleInfo style)`
`protected HSSFCellStyle`	`getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, HSSFFont font, JRExporterGridCell gridCell, boolean isWrapText, boolean isCellLocked, boolean isCellHidden, boolean isShrinkToFit)`
`protected HSSFCellStyle`	`getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, HSSFFont font, net.sf.jasperreports.engine.export.JRXlsExporter.BoxStyle box, boolean isWrapText, boolean isCellLocked, boolean isCellHidden, boolean isShrinkToFit)`
`protected HSSFFont`	`getLoadedFont(JRFont font, short forecolor, java.util.Map<java.text.AttributedCharacterIterator.Attribute,java.lang.Object> attributes, java.util.Locale locale)`
`protected java.lang.Integer`	`getMaxRowsPerSheet()`
`protected HSSFColor`	`getNearestColor(java.awt.Color awtColor)`
`protected HSSFRichTextString`	`getRichTextString(JRStyledText styledText, short forecolor, JRFont defaultFont, java.util.Locale locale)`
`protected double`	`getRowRelativePosition(JRGridLayout layout, int row, int offset)`
`protected HSSFColor`	`getWorkbookColor(java.awt.Color awtColor)`
`protected HSSFCellStyle`	`initCreateCell(JRExporterGridCell gridCell, int colIndex, int rowIndex, JRXlsExporter.StyleInfo baseStyle)`
`protected void`	`initExport()`
`protected void`	`initReport()`
`protected void`	`openWorkbook(java.io.OutputStream os)`
`protected void`	`setAutoFilter(java.lang.String autoFilterRange)`
`protected void`	`setColumnWidth(int col, int width, boolean autoFit)`
`protected void`	`setFreezePane(int rowIndex, int colIndex, boolean isRowEdge, boolean isColumnEdge)` Creates a freeze pane for the current sheet.
`protected void`	`setHyperlinkCell(JRPrintHyperlink hyperlink)`
`protected void`	`setRichTextStringCellValue(JRStyledText styledText, short forecolor, JRFont defaultFont, java.util.Locale locale)`
`protected void`	`setRowHeight(int rowIndex, int lastRowHeight, Cut yCut, XlsRowLevelInfo levelInfo)`
`protected void`	`setRowLevels(XlsRowLevelInfo levelInfo, java.lang.String level)`
`protected void`	`setSheetName(java.lang.String sheetName)`
`protected void`	`setStringCellValue(java.lang.String textStr)`

Methods inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, ensureInput, ensureOutput, exportPage, exportReport, exportReportToStream, exportSheet, getColumIndexName, getColumnIndex, getColumnName, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getNature, getSheetProps, getStyledText, getTextAlignHolder, getWorkbookTemplate, hasGlobalSheetNames, isCellHidden, isCellLocked, isIgnoreTextFormatting, isShrinkToFit, isUseTimeZone, isValidScale, isWorkbookTemplateKeepSheets, isWrapText, mergeAndSetRowLevels, resetAutoFilters, setColumnWidths, setFreezePane, setSheetNames, setWorkbookTemplate, setWorkbookTemplateKeepSheets, translateDateValue

Methods inherited from class net.sf.jasperreports.engine.JRAbstractExporter
createFilter, defaultParseNumber, ensureJasperReportsContext, getBooleanCellValue, getCurrentConfiguration, getCurrentItemConfiguration, getCurrentJasperPrint, getCustomHandler, getDateCellValue, getDateFormat, getExporterContext, getExporterInput, getExporterOutput, getHyperlinkProducer, getJasperReportsContext, getLocale, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getPageRange, getParameter, getParameters, getPropertiesUtil, getReportContext, getStyledText, getTextFormatFactoryClass, getTextLocale, getTextTimeZone, getTextValue, getTextValueString, insideFrame, reset, resetClassLoader, resetExportContext, restoreElementOffsets, setClassLoader, setConfiguration, setConfiguration, setCurrentExporterInputItem, setExporterInput, setExporterOutput, setFrameElementsOffset, setJasperPrint, setJasperReportsContext, setOffset, setOffset, setParameter, setParameters, setReportContext

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

XLS_EXPORTER_KEY
```
public static final java.lang.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 java.util.Map<JRXlsExporter.StyleInfo,HSSFCellStyle> loadedCellStyles

anchorLinks

protected java.util.Map<java.lang.String,java.util.List<Hyperlink>> anchorLinks

pageLinks

protected java.util.Map<java.lang.Integer,java.util.List<Hyperlink>> pageLinks

anchorNames

protected java.util.Map<java.lang.String,HSSFName> anchorNames

autofitColumns

protected java.util.Map<HSSFSheet,java.util.List<java.lang.Integer>> autofitColumns

workbook
```
protected HSSFWorkbook workbook
```

sheet
```
protected HSSFSheet sheet
```

row
```
protected HSSFRow row
```

cell
```
protected HSSFCell cell
```

emptyCellStyle
```
protected HSSFCellStyle emptyCellStyle
```

createHelper
```
protected CreationHelper createHelper
```

whiteIndex
```
protected short whiteIndex
```

blackIndex
```
protected short blackIndex
```

customColorIndex
```
protected short customColorIndex
```

backgroundMode
```
protected short backgroundMode
```

dataFormat
```
protected HSSFDataFormat dataFormat
```

patriarch
```
protected HSSFPatriarch patriarch
```

Constructor Detail

JRXlsExporter
```
public JRXlsExporter()
```
See Also:
JRXlsExporter(JasperReportsContext)

JRXlsExporter

public JRXlsExporter(JasperReportsContext jasperReportsContext)

Method Detail

getConfigurationInterface
```
protected java.lang.Class<XlsExporterConfiguration> getConfigurationInterface()
```
Specified by:

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

getItemConfigurationInterface
```
protected java.lang.Class<XlsReportConfiguration> getItemConfigurationInterface()
```
Specified by:

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

initExport
```
protected void initExport()
```
Overrides:

initExport in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

initReport
```
protected void initReport()
```
Overrides:

initReport in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

openWorkbook
```
protected void openWorkbook(java.io.OutputStream os)
```
Specified by:

openWorkbook in class JRXlsAbstractExporter<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 JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

closeWorkbook
```
protected void closeWorkbook(java.io.OutputStream os)
                      throws JRException
```
Specified by:

closeWorkbook in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Throws:

JRException

setColumnWidth
```
protected void setColumnWidth(int col,
                  int width,
                  boolean autoFit)
```
Specified by:

setColumnWidth in class JRXlsAbstractExporter<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 JRXlsAbstractExporter<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 HSSFCellStyle initCreateCell(JRExporterGridCell gridCell,
                           int colIndex,
                           int rowIndex,
                           JRXlsExporter.StyleInfo baseStyle)

endCreateCell

protected void endCreateCell(HSSFCellStyle cellStyle)

setStringCellValue

protected final void setStringCellValue(java.lang.String textStr)

setRichTextStringCellValue

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

getRichTextString

protected HSSFRichTextString getRichTextString(JRStyledText styledText,
                                   short forecolor,
                                   JRFont defaultFont,
                                   java.util.Locale locale)

createMergeRegion

protected void createMergeRegion(JRExporterGridCell gridCell,
                     int colIndex,
                     int rowIndex,
                     HSSFCellStyle cellStyle)

getWorkbookColor

protected HSSFColor getWorkbookColor(java.awt.Color awtColor)

getNearestColor

protected HSSFColor getNearestColor(java.awt.Color awtColor)

getLoadedFont

protected HSSFFont getLoadedFont(JRFont font,
                     short forecolor,
                     java.util.Map<java.text.AttributedCharacterIterator.Attribute,java.lang.Object> attributes,
                     java.util.Locale locale)

getLoadedCellStyle

protected HSSFCellStyle getLoadedCellStyle(JRXlsExporter.StyleInfo style)

getLoadedCellStyle

protected HSSFCellStyle getLoadedCellStyle(short mode,
                               short backcolor,
                               short horizontalAlignment,
                               short verticalAlignment,
                               short rotation,
                               HSSFFont font,
                               JRExporterGridCell gridCell,
                               boolean isWrapText,
                               boolean isCellLocked,
                               boolean isCellHidden,
                               boolean isShrinkToFit)

getLoadedCellStyle

protected HSSFCellStyle getLoadedCellStyle(short mode,
                               short backcolor,
                               short horizontalAlignment,
                               short verticalAlignment,
                               short rotation,
                               HSSFFont font,
                               net.sf.jasperreports.engine.export.JRXlsExporter.BoxStyle box,
                               boolean isWrapText,
                               boolean isCellLocked,
                               boolean isCellHidden,
                               boolean isShrinkToFit)

getBorderStyle

protected static short 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 java.lang.Integer getMaxRowsPerSheet()
```
Overrides:

getMaxRowsPerSheet in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

getExporterKey
```
public java.lang.String getExporterKey()
```
Specified by:

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

getExporterPropertiesPrefix
```
public java.lang.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,
                 boolean isRowEdge,
                 boolean isColumnEdge)
```
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 JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Parameters:
rowIndex - the freeze 0-based row index
colIndex - the freeze 0-based column index
isRowEdge - specifies if the freeze row index is set at element level
isColumnEdge - specifies if the freeze column index is set at element level

setSheetName
```
protected void setSheetName(java.lang.String sheetName)
```
Specified by:

setSheetName in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

setAutoFilter
```
protected void setAutoFilter(java.lang.String autoFilterRange)
```
Specified by:

setAutoFilter in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

setRowLevels
```
protected void setRowLevels(XlsRowLevelInfo levelInfo,
                java.lang.String level)
```
Specified by:

setRowLevels in class JRXlsAbstractExporter<XlsReportConfiguration,XlsExporterConfiguration,JRXlsExporterContext>

Class JRXlsExporter

Nested Class Summary

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

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

Field Summary

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

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

Constructor Summary

Method Summary

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

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

Methods inherited from class java.lang.Object

Field Detail

XLS_EXPORTER_KEY

MAX_COLOR_INDEX

MIN_COLOR_INDEX

loadedCellStyles

anchorLinks

pageLinks

anchorNames

autofitColumns

workbook

sheet

row

cell

emptyCellStyle

createHelper

whiteIndex

blackIndex

customColorIndex

backgroundMode

dataFormat

patriarch

Constructor Detail

JRXlsExporter

JRXlsExporter

Method Detail

getConfigurationInterface

getItemConfigurationInterface

initExport

initReport

openWorkbook

createSheet

closeSheet

closeWorkbook

setColumnWidth

setRowHeight

addRowBreak

addBlankCell

addOccupiedCell

exportLine

exportRectangle

exportText

createTextCell

initCreateCell

endCreateCell

setStringCellValue

setRichTextStringCellValue

getRichTextString

createMergeRegion

getWorkbookColor

getNearestColor

getLoadedFont

getLoadedCellStyle

getLoadedCellStyle

getLoadedCellStyle

getBorderStyle

exportImage

getColumnRelativePosition

getRowRelativePosition

exportFrame

exportGenericElement

setHyperlinkCell

getMaxRowsPerSheet

getExporterKey

getExporterPropertiesPrefix

setFreezePane

setSheetName

setAutoFilter

setRowLevels