public class JExcelApiExporter extends JRXlsAbstractExporter
Modifier and Type | Class and Description |
---|---|
protected class |
JExcelApiExporter.BoxStyle |
protected class |
JExcelApiExporter.CellTextValueHandler |
protected class |
JExcelApiExporter.ExporterContext |
protected class |
JExcelApiExporter.FormulaTextValueHandler |
protected class |
JExcelApiExporter.StyleInfo |
JRXlsAbstractExporter.TextAlignHolder
JRAbstractExporter.BaseExporterContext, JRAbstractExporter.ParameterOverriddenResolver, JRAbstractExporter.ParameterOverrideResolver, JRAbstractExporter.ParameterResolver
Modifier and Type | Field and Description |
---|---|
protected static jxl.format.Colour |
BLACK |
protected boolean |
complexFormat |
protected static java.lang.String |
EMPTY_SHEET_NAME |
protected JExcelApiExporterContext |
exporterContext |
static java.lang.String |
JXL_EXPORTER_KEY
The exporter key, as used in
GenericElementHandlerEnviroment.getHandler(net.sf.jasperreports.engine.JRGenericElementType, String) . |
protected ExporterNature |
nature |
protected java.lang.String |
password |
static java.lang.String |
PROPERTY_COMPLEX_FORMAT
Boolean property specifying whether the cell format pattern is user-defined.
|
static java.lang.String |
PROPERTY_USE_TEMP_FILE
Boolean property enabling the JExcelApiExporter to use temporary files when creating large documents.
|
protected java.util.Map |
usedColours |
protected boolean |
useTempFile |
protected static jxl.format.Colour |
WHITE |
protected java.util.Map |
workbookColours |
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 |
---|
JExcelApiExporter() |
Modifier and Type | Method and Description |
---|---|
protected void |
addBlankCell(JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
addCell(int x,
int y,
JRPrintText text,
java.lang.String textStr,
JExcelApiExporter.StyleInfo baseStyle) |
protected void |
addMergeRegion(JRExporterGridCell gridCell,
int x,
int y) |
protected void |
addOccupiedCell(OccupiedGridCell occupiedGridCell,
int colIndex,
int rowIndex) |
protected void |
closeWorkbook(java.io.OutputStream os) |
protected void |
createSheet(java.lang.String name) |
protected jxl.format.Colour |
determineWorkbookColour(java.awt.Color awtColor) |
protected void |
exportFrame(JRPrintFrame frame,
JRExporterGridCell gridCell,
int col,
int row) |
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 col,
int row,
int emptyCols,
int yCutsRow,
JRGridLayout layout) |
protected void |
exportLine(JRPrintLine line,
JRExporterGridCell gridCell,
int col,
int row) |
protected void |
exportRectangle(JRPrintGraphicElement element,
JRExporterGridCell gridCell,
int col,
int row) |
void |
exportText(JRPrintText text,
JRExporterGridCell gridCell,
int col,
int row) |
protected jxl.write.biff.CellValue |
getAutoDetectedCellValue(int x,
int y,
java.lang.String textStr,
JExcelApiExporter.StyleInfo baseStyle) |
protected static jxl.format.BorderLineStyle |
getBorderLineStyle(JRPen pen) |
protected double |
getColumnRelativePosition(JRGridLayout layout,
int col,
int offset) |
protected jxl.write.DateFormat |
getDateFormat(java.lang.String pattern) |
protected jxl.write.biff.CellValue |
getDetectedCellValue(int x,
int y,
TextValue textValue,
JExcelApiExporter.StyleInfo baseStyle,
boolean complexFormat) |
protected java.lang.String |
getExporterKey() |
protected jxl.write.biff.CellValue |
getFormulaCellValue(int x,
int y,
TextValue textValue,
java.lang.String formula,
JExcelApiExporter.StyleInfo baseStyle,
boolean complexFormat) |
protected jxl.write.biff.CellValue |
getLabelCell(int x,
int y,
java.lang.String textStr,
JExcelApiExporter.StyleInfo baseStyle) |
protected jxl.write.WritableCellFormat |
getLoadedCellStyle(JExcelApiExporter.StyleInfo styleKey) |
protected ExporterNature |
getNature() |
protected static jxl.format.Colour |
getNearestColour(java.awt.Color awtColor) |
protected jxl.write.NumberFormat |
getNumberFormat(java.lang.String pattern,
boolean isComplexFormat) |
protected double |
getRowRelativePosition(JRGridLayout layout,
int row,
int offset) |
static JRXlsAbstractExporter.TextAlignHolder |
getTextAlignHolder(JRPrintText textElement) |
protected jxl.format.Colour |
getWorkbookColour(java.awt.Color awtColor) |
protected jxl.format.Colour |
getWorkbookColour(java.awt.Color awtColor,
boolean isBackcolor) |
protected void |
initCustomPalette() |
protected boolean |
isComplexFormat(JRPrintElement element) |
protected void |
openWorkbook(java.io.OutputStream os) |
protected void |
removeColumn(int col) |
protected static int |
rgbDistance(java.awt.Color awtColor,
jxl.format.RGB rgb) |
protected void |
setBackground() |
protected void |
setCell(JRExporterGridCell gridCell,
int x,
int y) |
protected void |
setColourUsed(jxl.format.Colour colour) |
protected void |
setColourUsed(jxl.format.Colour colour,
java.awt.Color reportColour) |
protected void |
setColumnWidth(int col,
int width) |
protected void |
setParameters() |
protected void |
setRowHeight(int y,
int lastRowHeight) |
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, exportPage, exportReport, exportReportToStream, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getStyledText, 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 PROPERTY_USE_TEMP_FILE
false
).JRProperties
,
Constant Field Valuespublic static final java.lang.String PROPERTY_COMPLEX_FORMAT
JRProperties
,
Constant Field Valuespublic static final java.lang.String JXL_EXPORTER_KEY
GenericElementHandlerEnviroment.getHandler(net.sf.jasperreports.engine.JRGenericElementType, String)
.protected static final jxl.format.Colour WHITE
protected static final jxl.format.Colour BLACK
protected static final java.lang.String EMPTY_SHEET_NAME
protected java.util.Map workbookColours
protected java.util.Map usedColours
protected java.lang.String password
protected ExporterNature nature
protected boolean useTempFile
protected boolean complexFormat
protected JExcelApiExporterContext exporterContext
protected void setParameters()
setParameters
in class JRXlsAbstractExporter
protected void initCustomPalette()
protected void setColourUsed(jxl.format.Colour colour)
protected void setColourUsed(jxl.format.Colour colour, java.awt.Color reportColour)
protected void setBackground()
setBackground
in class JRXlsAbstractExporter
protected void openWorkbook(java.io.OutputStream os) throws JRException
openWorkbook
in class JRXlsAbstractExporter
JRException
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 y, int lastRowHeight) throws JRException
setRowHeight
in class JRXlsAbstractExporter
JRException
protected void setCell(JRExporterGridCell gridCell, int x, int y)
setCell
in class JRXlsAbstractExporter
protected void removeColumn(int col)
removeColumn
in class JRXlsAbstractExporter
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
addBlankCell
in class JRXlsAbstractExporter
JRException
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex) throws JRException
addOccupiedCell
in class JRXlsAbstractExporter
JRException
protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int col, int row) throws JRException
exportLine
in class JRXlsAbstractExporter
JRException
protected void exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int col, int row) throws JRException
exportRectangle
in class JRXlsAbstractExporter
JRException
public void exportText(JRPrintText text, JRExporterGridCell gridCell, int col, int row) throws JRException
exportText
in class JRXlsAbstractExporter
JRException
protected void addCell(int x, int y, JRPrintText text, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle) throws jxl.write.WriteException, jxl.write.biff.RowsExceededException, JRException
jxl.write.WriteException
jxl.write.biff.RowsExceededException
JRException
protected jxl.write.biff.CellValue getFormulaCellValue(int x, int y, TextValue textValue, java.lang.String formula, JExcelApiExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected jxl.write.biff.CellValue getDetectedCellValue(int x, int y, TextValue textValue, JExcelApiExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected jxl.write.NumberFormat getNumberFormat(java.lang.String pattern, boolean isComplexFormat)
protected jxl.write.DateFormat getDateFormat(java.lang.String pattern)
protected jxl.write.biff.CellValue getAutoDetectedCellValue(int x, int y, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle) throws JRException
JRException
protected jxl.write.biff.CellValue getLabelCell(int x, int y, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle) throws JRException
JRException
protected void addMergeRegion(JRExporterGridCell gridCell, int x, int y) throws JRException
JRException
protected void exportImage(JRPrintImage element, JRExporterGridCell gridCell, int col, int row, 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 jxl.format.Colour getWorkbookColour(java.awt.Color awtColor, boolean isBackcolor)
protected jxl.format.Colour getWorkbookColour(java.awt.Color awtColor)
protected jxl.format.Colour determineWorkbookColour(java.awt.Color awtColor)
protected static jxl.format.Colour getNearestColour(java.awt.Color awtColor)
protected static int rgbDistance(java.awt.Color awtColor, jxl.format.RGB rgb)
protected jxl.write.WritableCellFormat getLoadedCellStyle(JExcelApiExporter.StyleInfo styleKey) throws JRException
JRException
protected static jxl.format.BorderLineStyle getBorderLineStyle(JRPen pen)
public static JRXlsAbstractExporter.TextAlignHolder getTextAlignHolder(JRPrintText textElement)
protected void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int col, int row) throws JRException
exportFrame
in class JRXlsAbstractExporter
JRException
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 java.lang.String getExporterKey()
getExporterKey
in class JRAbstractExporter
protected boolean isComplexFormat(JRPrintElement element)
© 2001-2010 Jaspersoft Corporation www.jaspersoft.com