public class JRXlsExporter extends JRXlsAbstractExporter
Modifier and Type | Class and Description |
---|---|
protected class |
JRXlsExporter.ExporterContext |
JRXlsAbstractExporter.TextAlignHolder
JRAbstractExporter.BaseExporterContext, JRAbstractExporter.ParameterOverriddenResolver, JRAbstractExporter.ParameterOverrideResolver, JRAbstractExporter.ParameterResolver
Modifier and Type | Field and Description |
---|---|
protected java.util.Map |
anchorLinks |
protected java.util.Map |
anchorNames |
protected short |
backgroundMode |
protected short |
blackIndex |
protected org.apache.poi.hssf.usermodel.HSSFCell |
cell |
protected org.apache.poi.ss.usermodel.CreationHelper |
createHelper |
protected org.apache.poi.hssf.usermodel.HSSFDataFormat |
dataFormat |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
emptyCellStyle |
protected JRXlsExporterContext |
exporterContext |
protected java.util.Map |
loadedCellStyles |
protected ExporterNature |
nature |
protected java.util.Map |
pageLinks |
protected java.lang.String |
password |
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 java.lang.String |
XLS_EXPORTER_KEY
The exporter key, as used in
GenericElementHandlerEnviroment.getHandler(net.sf.jasperreports.engine.JRGenericElementType, String) . |
cellHidden, cellLocked, createCustomPalette, defaultFont, fontMap, formatPatternsMap, isAutoDetectCellType, isCollapseRowSpan, isDetectCellType, isFontSizeFixEnabled, isIgnoreCellBackground, isIgnoreCellBorder, isIgnoreGraphics, isIgnorePageMargins, isImageBorderFixEnabled, isOnePagePerSheet, isRemoveEmptySpaceBetweenColumns, isRemoveEmptySpaceBetweenRows, isWhitePageBackground, loadedFonts, maxRowsPerSheet, pageIndex, progressMonitor, PROPERTY_CELL_HIDDEN, PROPERTY_CELL_LOCKED, PROPERTY_FIT_HEIGHT, PROPERTY_FIT_WIDTH, 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_WRAP_TEXT, reportIndex, sheetDirection, sheetFooterCenter, sheetFooterLeft, sheetFooterRight, sheetHeaderCenter, sheetHeaderLeft, sheetHeaderRight, sheetIndex, sheetNames, sheetNamesIndex, sheetNamesMap, wrapText, XLS_EXPORTER_PROPERTIES_PREFIX
classLoader, classLoaderSet, dateFormatCache, endPageIndex, fileResolver, fileResolverSet, filter, globalOffsetX, globalOffsetY, hyperlinkProducerFactory, isModeBatch, jasperPrint, jasperPrintList, numberFormatCache, parameters, PROPERTY_CELL_FORMULA, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, startPageIndex, urlHandlerFactory, urlHandlerFactorySet
Constructor and Description |
---|
JRXlsExporter() |
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 |
closeWorkbook(java.io.OutputStream os) |
protected void |
createMergeRegion(JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle) |
protected void |
createSheet(java.lang.String name) |
protected void |
createTextCell(JRPrintText textElement,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
JRStyledText styledText,
net.sf.jasperreports.engine.export.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) |
protected 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.String |
getExporterKey() |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
getLoadedCellStyle(short mode,
short backcolor,
short horizontalAlignment,
short verticalAlignment,
short rotation,
org.apache.poi.hssf.usermodel.HSSFFont font,
net.sf.jasperreports.engine.export.BoxStyle box) |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
getLoadedCellStyle(short mode,
short backcolor,
short horizontalAlignment,
short verticalAlignment,
short rotation,
org.apache.poi.hssf.usermodel.HSSFFont font,
net.sf.jasperreports.engine.export.BoxStyle box,
boolean isCellLocked,
boolean isCellHidden) |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
getLoadedCellStyle(short mode,
short backcolor,
short horizontalAlignment,
short verticalAlignment,
short rotation,
org.apache.poi.hssf.usermodel.HSSFFont font,
JRExporterGridCell gridCell) |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
getLoadedCellStyle(short mode,
short backcolor,
short horizontalAlignment,
short verticalAlignment,
short rotation,
org.apache.poi.hssf.usermodel.HSSFFont font,
JRExporterGridCell gridCell,
boolean isCellLocked,
boolean isCellHidden) |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
getLoadedCellStyle(net.sf.jasperreports.engine.export.StyleInfo style) |
protected org.apache.poi.hssf.usermodel.HSSFFont |
getLoadedFont(JRFont font,
short forecolor,
java.util.Map attributes,
java.util.Locale locale) |
protected ExporterNature |
getNature() |
protected static org.apache.poi.hssf.util.HSSFColor |
getNearestColor(java.awt.Color awtColor) |
protected org.apache.poi.hssf.usermodel.HSSFRichTextString |
getRichTextString(JRStyledText styledText,
short forecolor,
JRFont defaultFont,
java.util.Locale locale) |
protected double |
getRowRelativePosition(JRGridLayout layout,
int row,
int offset) |
protected static org.apache.poi.hssf.util.HSSFColor |
getWorkbookColor(java.awt.Color awtColor) |
protected org.apache.poi.hssf.usermodel.HSSFCellStyle |
initCreateCell(JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
net.sf.jasperreports.engine.export.StyleInfo baseStyle) |
protected void |
openWorkbook(java.io.OutputStream os) |
protected void |
removeColumn(int colIndex) |
protected void |
setBackground() |
protected void |
setCell(JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
setColumnWidth(int col,
int width) |
protected void |
setHyperlinkCell(JRPrintHyperlink hyperlink) |
protected void |
setParameters() |
protected void |
setRichTextStringCellValue(JRStyledText styledText,
short forecolor,
JRFont defaultFont,
java.util.Locale locale) |
protected void |
setRowHeight(int rowIndex,
int lastRowHeight) |
protected void |
setStringCellValue(java.lang.String textStr) |
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, exportPage, exportReport, exportReportToStream, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getStyledText, getTextAlignHolder, isCellHidden, isCellLocked, isWrapText, removeEmptyColumns, setColumnWidths, setSheetNames
createFilter, defaultParseNumber, getBooleanCellValue, getBooleanParameter, getCharacterParameter, getCustomHandler, getDateCellValue, getDateFormat, getFloatParameter, getHyperlinkProducer, getIntegerParameter, getLocale, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getParameter, getParameterResolver, getParameters, getStringArrayParameter, getStringParameter, getStringParameterOrDefault, getStyledText, getTextFormatFactoryClass, getTextLocale, getTextTimeZone, getTextValue, getTextValueString, reset, resetClassLoader, resetExportContext, restoreElementOffsets, setClassLoader, setExportContext, setFrameElementsOffset, setHyperlinkProducerFactory, setInput, setJasperPrint, setOffset, setOffset, setOutput, setPageRange, setParameter, setParameters
public static final java.lang.String XLS_EXPORTER_KEY
GenericElementHandlerEnviroment.getHandler(net.sf.jasperreports.engine.JRGenericElementType, String)
.protected java.util.Map loadedCellStyles
protected java.util.Map anchorLinks
protected java.util.Map pageLinks
protected java.util.Map anchorNames
protected org.apache.poi.hssf.usermodel.HSSFWorkbook workbook
protected org.apache.poi.hssf.usermodel.HSSFSheet sheet
protected org.apache.poi.hssf.usermodel.HSSFRow row
protected org.apache.poi.hssf.usermodel.HSSFCell cell
protected org.apache.poi.hssf.usermodel.HSSFCellStyle emptyCellStyle
protected org.apache.poi.ss.usermodel.CreationHelper createHelper
protected short whiteIndex
protected short blackIndex
protected short backgroundMode
protected org.apache.poi.hssf.usermodel.HSSFDataFormat dataFormat
protected ExporterNature nature
protected org.apache.poi.hssf.usermodel.HSSFPatriarch patriarch
protected java.lang.String password
protected JRXlsExporterContext exporterContext
protected void setParameters()
setParameters
in class JRXlsAbstractExporter
protected void setBackground()
setBackground
in class JRXlsAbstractExporter
protected void openWorkbook(java.io.OutputStream os)
openWorkbook
in class JRXlsAbstractExporter
protected void createSheet(java.lang.String name)
createSheet
in class JRXlsAbstractExporter
protected void closeWorkbook(java.io.OutputStream os) throws JRException
closeWorkbook
in class JRXlsAbstractExporter
JRException
protected void setColumnWidth(int col, int width)
setColumnWidth
in class JRXlsAbstractExporter
protected void setRowHeight(int rowIndex, int lastRowHeight)
setRowHeight
in class JRXlsAbstractExporter
protected void setCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
setCell
in class JRXlsAbstractExporter
protected void removeColumn(int colIndex)
removeColumn
in class JRXlsAbstractExporter
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
addBlankCell
in class JRXlsAbstractExporter
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
addOccupiedCell
in class JRXlsAbstractExporter
protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int colIndex, int rowIndex)
exportLine
in class JRXlsAbstractExporter
protected void exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex)
exportRectangle
in class JRXlsAbstractExporter
public void exportText(JRPrintText textElement, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportText
in class JRXlsAbstractExporter
JRException
protected void createTextCell(JRPrintText textElement, JRExporterGridCell gridCell, int colIndex, int rowIndex, JRStyledText styledText, net.sf.jasperreports.engine.export.StyleInfo baseStyle, short forecolor) throws JRException
JRException
protected org.apache.poi.hssf.usermodel.HSSFCellStyle initCreateCell(JRExporterGridCell gridCell, int colIndex, int rowIndex, net.sf.jasperreports.engine.export.StyleInfo baseStyle)
protected void endCreateCell(org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)
protected final void setStringCellValue(java.lang.String textStr)
protected final void setRichTextStringCellValue(JRStyledText styledText, short forecolor, JRFont defaultFont, java.util.Locale locale)
protected org.apache.poi.hssf.usermodel.HSSFRichTextString getRichTextString(JRStyledText styledText, short forecolor, JRFont defaultFont, java.util.Locale locale)
protected void createMergeRegion(JRExporterGridCell gridCell, int colIndex, int rowIndex, org.apache.poi.hssf.usermodel.HSSFCellStyle cellStyle)
protected static org.apache.poi.hssf.util.HSSFColor getWorkbookColor(java.awt.Color awtColor)
protected static org.apache.poi.hssf.util.HSSFColor getNearestColor(java.awt.Color awtColor)
protected org.apache.poi.hssf.usermodel.HSSFFont getLoadedFont(JRFont font, short forecolor, java.util.Map attributes, java.util.Locale locale)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(net.sf.jasperreports.engine.export.StyleInfo style)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, JRExporterGridCell gridCell)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, JRExporterGridCell gridCell, boolean isCellLocked, boolean isCellHidden)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, net.sf.jasperreports.engine.export.BoxStyle box)
protected org.apache.poi.hssf.usermodel.HSSFCellStyle getLoadedCellStyle(short mode, short backcolor, short horizontalAlignment, short verticalAlignment, short rotation, org.apache.poi.hssf.usermodel.HSSFFont font, net.sf.jasperreports.engine.export.BoxStyle box, boolean isCellLocked, boolean isCellHidden)
protected static short getBorderStyle(JRPen pen)
protected void exportImage(JRPrintImage element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportImage
in class JRXlsAbstractExporter
JRException
protected double getColumnRelativePosition(JRGridLayout layout, int col, int offset)
protected double getRowRelativePosition(JRGridLayout layout, int row, int offset)
protected void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int x, int y)
exportFrame
in class JRXlsAbstractExporter
protected void exportGenericElement(JRGenericPrintElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportGenericElement
in class JRXlsAbstractExporter
JRException
protected ExporterNature getNature()
getNature
in class JRXlsAbstractExporter
protected void setHyperlinkCell(JRPrintHyperlink hyperlink)
protected java.lang.String getExporterKey()
getExporterKey
in class JRAbstractExporter
© 2001-2010 Jaspersoft Corporation www.jaspersoft.com