public class JExcelApiMetadataExporter extends JRXlsAbstractMetadataExporter
Modifier and Type | Class and Description |
---|---|
protected class |
JExcelApiMetadataExporter.BoxStyle |
protected class |
JExcelApiMetadataExporter.CellTextValueHandler |
protected class |
JExcelApiMetadataExporter.ExporterContext |
protected class |
JExcelApiMetadataExporter.FormulaTextValueHandler |
protected class |
JExcelApiMetadataExporter.StyleInfo |
JRXlsAbstractExporter.TextAlignHolder
JRAbstractExporter.BaseExporterContext, JRAbstractExporter.ParameterOverriddenResolver, JRAbstractExporter.ParameterOverrideResolver, JRAbstractExporter.ParameterResolver
Modifier and Type | Field and Description |
---|---|
protected static 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 JExcelApiMetadataExporter to use temporary files when creating large documents.
|
protected java.util.Map<Colour,RGB> |
usedColours |
protected boolean |
useTempFile |
protected static Colour |
WHITE |
protected java.util.Map<java.awt.Color,Colour> |
workbookColours |
columnNames, columnNamesMap, rowIndex, writeHeader
autoFilterEnd, autoFilterStart, cellHidden, cellLocked, columnWidthRatio, createCustomPalette, defaultFont, fontMap, formatPatternsMap, gridColumnFreezeIndex, gridRowFreezeIndex, isCollapseRowSpan, isDetectCellType, isFontSizeFixEnabled, isFreezeColumnEdge, isFreezeRowEdge, isIgnoreCellBackground, isIgnoreCellBorder, isIgnoreGraphics, isIgnorePageMargins, isImageBorderFixEnabled, isOnePagePerSheet, isRemoveEmptySpaceBetweenColumns, isRemoveEmptySpaceBetweenRows, isWhitePageBackground, loadedFonts, MAX_COLUMN_INDEX, MAX_ROW_INDEX, maxColumnFreezeIndex, maxRowFreezeIndex, maxRowsPerSheet, pageIndex, progressMonitor, PROPERTY_AUTO_FILTER, PROPERTY_AUTO_FIT_COLUMN, PROPERTY_AUTO_FIT_ROW, PROPERTY_CELL_FORMULA, PROPERTY_CELL_HIDDEN, PROPERTY_CELL_LOCKED, PROPERTY_CELL_PATTERN, PROPERTY_COLUMN_WIDTH, PROPERTY_COLUMN_WIDTH_RATIO, PROPERTY_FIT_HEIGHT, PROPERTY_FIT_WIDTH, PROPERTY_FREEZE_COLUMN, PROPERTY_FREEZE_COLUMN_EDGE, PROPERTY_FREEZE_ROW, PROPERTY_FREEZE_ROW_EDGE, 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_WRAP_TEXT, reportIndex, sheetDirection, sheetFooterCenter, sheetFooterLeft, sheetFooterRight, sheetHeaderCenter, sheetHeaderLeft, sheetHeaderRight, sheetIndex, sheetNames, sheetNamesIndex, sheetNamesMap, wrapText, XLS_EXPORTER_PROPERTIES_PREFIX
dateFormatCache, endPageIndex, filter, globalOffsetX, globalOffsetY, hyperlinkProducerFactory, isModeBatch, jasperPrint, jasperPrintList, numberFormatCache, parameters, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, startPageIndex
Constructor and Description |
---|
JExcelApiMetadataExporter() |
Modifier and Type | Method and Description |
---|---|
protected void |
addBlankCell(WritableCellFormat baseStyleFormat,
java.util.Map<java.lang.String,java.lang.Object> cellValueMap,
java.lang.String currentColumnName) |
protected void |
addBlankElement(WritableCellFormat baseCellFormat,
boolean repeatValue,
java.lang.String currentColumnName) |
protected void |
addCell(JRPrintText text,
java.lang.String textStr,
JExcelApiMetadataExporter.StyleInfo baseStyle,
java.util.Map<java.lang.String,java.lang.Object> cellValueMap,
java.lang.String currentColumnName) |
protected void |
addTextElement(JRPrintText textElement,
java.lang.String textStr,
JExcelApiMetadataExporter.StyleInfo baseStyle,
boolean repeatValue,
java.lang.String currentColumnName) |
protected void |
closeWorkbook(java.io.OutputStream os) |
protected void |
createSheet(java.lang.String name) |
protected Colour |
determineWorkbookColour(java.awt.Color awtColor) |
protected void |
exportFrame(JRPrintFrame frame) |
protected void |
exportGenericElement(JRGenericPrintElement element) |
void |
exportImage(JRPrintImage element) |
protected void |
exportLine(JRPrintLine line) |
protected void |
exportRectangle(JRPrintGraphicElement element) |
protected void |
exportText(JRPrintText textElement) |
protected static BorderLineStyle |
getBorderLineStyle(JRPen pen) |
protected DateFormat |
getDateFormat(java.lang.String convertedPattern) |
protected CellValue |
getDetectedCellValue(int x,
int y,
JRPrintText textElement,
TextValue textValue,
JExcelApiMetadataExporter.StyleInfo baseStyle,
boolean complexFormat) |
protected java.lang.String |
getExporterKey() |
protected CellValue |
getFormulaCellValue(int x,
int y,
JRPrintText textElement,
TextValue textValue,
java.lang.String formula,
JExcelApiMetadataExporter.StyleInfo baseStyle,
boolean complexFormat) |
protected CellValue |
getLabelCell(int x,
int y,
java.lang.String textStr,
JExcelApiMetadataExporter.StyleInfo baseStyle) |
protected WritableCellFormat |
getLoadedCellStyle(JExcelApiMetadataExporter.StyleInfo styleKey) |
protected ExporterNature |
getNature() |
protected static Colour |
getNearestColour(java.awt.Color awtColor) |
protected NumberFormat |
getNumberFormat(java.lang.String convertedPattern,
boolean isComplexFormat) |
static JRXlsAbstractExporter.TextAlignHolder |
getTextAlignHolder(JRPrintText textElement) |
protected Colour |
getWorkbookColour(java.awt.Color awtColor) |
protected 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,
RGB rgb) |
protected void |
setAutoFilter(java.lang.String autoFilterRange) |
protected void |
setBackground() |
protected void |
setColourUsed(Colour colour) |
protected void |
setColourUsed(Colour colour,
java.awt.Color reportColour) |
protected void |
setColumnName(java.lang.String currentColumnName) |
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 |
setParameters() |
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 |
updateColumn(int col,
boolean autoFit) |
protected void |
writeCurrentRow(java.util.Map<java.lang.String,java.lang.Object> currentRow,
java.util.Map<java.lang.String,java.lang.Object> repeatedValues) |
protected void |
writeReportHeader()
Writes the header column names
|
addBlankCell, addOccupiedCell, exportFrame, exportGenericElement, exportImage, exportLine, exportPage, exportRectangle, exportReportToStream, exportText, getFormula, getImageBorderCorrection, getStyledText, isCellHidden, isCellLocked, isColumnReadOnTime, isWrapText, setCell, setColumnNames, setColumnWidth, setRowHeight, setSheetNames
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, exportPage, exportReport, getColumnIndex, getColumnName, getConvertedPattern, getDefaultFont, mergeAndSetRowLevels, resetAutoFilters, setColumnWidths, setExporterHints, setFreezePane, updateColumns
createFilter, defaultParseNumber, getBooleanCellValue, getBooleanParameter, getCharacterParameter, getCustomHandler, getDateCellValue, getDateFormat, getFloatParameter, getHyperlinkProducer, getIntegerParameter, getLocale, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getParameter, getParameterResolver, getParameters, getReportContext, 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, setReportContext
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 Colour WHITE
protected static final Colour BLACK
protected static final java.lang.String EMPTY_SHEET_NAME
protected java.util.Map<java.awt.Color,Colour> workbookColours
protected java.util.Map<Colour,RGB> usedColours
protected java.lang.String password
protected ExporterNature nature
protected boolean useTempFile
protected boolean complexFormat
protected JExcelApiExporterContext exporterContext
protected void setParameters()
setParameters
in class JRXlsAbstractMetadataExporter
protected void initCustomPalette()
protected void setColourUsed(Colour colour)
protected void setColourUsed(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 JRXlsAbstractMetadataExporter
JRException
protected void createSheet(java.lang.String name)
createSheet
in class JRXlsAbstractMetadataExporter
protected void closeWorkbook(java.io.OutputStream os) throws JRException
closeWorkbook
in class JRXlsAbstractMetadataExporter
JRException
protected void setColumnWidth(int col, int width, boolean autoFit)
setColumnWidth
in class JRXlsAbstractMetadataExporter
protected void updateColumn(int col, boolean autoFit)
updateColumn
in class JRXlsAbstractExporter
protected void setRowHeight(int rowIndex, int lastRowHeight, Cut yCut, XlsRowLevelInfo levelInfo) throws JRException
setRowHeight
in class JRXlsAbstractMetadataExporter
JRException
protected void removeColumn(int col)
removeColumn
in class JRXlsAbstractMetadataExporter
protected void addBlankCell(WritableCellFormat baseStyleFormat, java.util.Map<java.lang.String,java.lang.Object> cellValueMap, java.lang.String currentColumnName) throws JRException
JRException
protected void writeCurrentRow(java.util.Map<java.lang.String,java.lang.Object> currentRow, java.util.Map<java.lang.String,java.lang.Object> repeatedValues) throws JRException
writeCurrentRow
in class JRXlsAbstractMetadataExporter
JRException
protected void exportLine(JRPrintLine line) throws JRException
exportLine
in class JRXlsAbstractMetadataExporter
JRException
protected void exportRectangle(JRPrintGraphicElement element) throws JRException
exportRectangle
in class JRXlsAbstractMetadataExporter
JRException
protected void exportText(JRPrintText textElement) throws JRException
exportText
in class JRXlsAbstractMetadataExporter
JRException
protected void addTextElement(JRPrintText textElement, java.lang.String textStr, JExcelApiMetadataExporter.StyleInfo baseStyle, boolean repeatValue, java.lang.String currentColumnName) throws JRException
JRException
protected void addBlankElement(WritableCellFormat baseCellFormat, boolean repeatValue, java.lang.String currentColumnName) throws JRException
JRException
protected void addCell(JRPrintText text, java.lang.String textStr, JExcelApiMetadataExporter.StyleInfo baseStyle, java.util.Map<java.lang.String,java.lang.Object> cellValueMap, java.lang.String currentColumnName) throws JRException
JRException
protected CellValue getFormulaCellValue(int x, int y, JRPrintText textElement, TextValue textValue, java.lang.String formula, JExcelApiMetadataExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected CellValue getDetectedCellValue(int x, int y, JRPrintText textElement, TextValue textValue, JExcelApiMetadataExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected NumberFormat getNumberFormat(java.lang.String convertedPattern, boolean isComplexFormat)
protected DateFormat getDateFormat(java.lang.String convertedPattern)
protected CellValue getLabelCell(int x, int y, java.lang.String textStr, JExcelApiMetadataExporter.StyleInfo baseStyle) throws JRException
JRException
public void exportImage(JRPrintImage element) throws JRException
exportImage
in class JRXlsAbstractMetadataExporter
JRException
protected Colour getWorkbookColour(java.awt.Color awtColor, boolean isBackcolor)
protected Colour getWorkbookColour(java.awt.Color awtColor)
protected Colour determineWorkbookColour(java.awt.Color awtColor)
protected static Colour getNearestColour(java.awt.Color awtColor)
protected static int rgbDistance(java.awt.Color awtColor, RGB rgb)
protected WritableCellFormat getLoadedCellStyle(JExcelApiMetadataExporter.StyleInfo styleKey) throws JRException
JRException
protected static BorderLineStyle getBorderLineStyle(JRPen pen)
public static JRXlsAbstractExporter.TextAlignHolder getTextAlignHolder(JRPrintText textElement)
protected void exportFrame(JRPrintFrame frame) throws JRException
exportFrame
in class JRXlsAbstractMetadataExporter
JRException
protected void exportGenericElement(JRGenericPrintElement element) throws JRException
exportGenericElement
in class JRXlsAbstractMetadataExporter
JRException
protected ExporterNature getNature()
getNature
in class JRXlsAbstractMetadataExporter
protected java.lang.String getExporterKey()
getExporterKey
in class JRAbstractExporter
protected boolean isComplexFormat(JRPrintElement element)
protected void setColumnName(java.lang.String currentColumnName)
protected void writeReportHeader() throws JRException
JRException
protected void setFreezePane(int rowIndex, int colIndex, boolean isRowEdge, boolean isColumnEdge)
setFreezePane
in class JRXlsAbstractExporter
rowIndex
- the freeze 0-based row indexcolIndex
- the freeze 0-based column indexisRowEdge
- specifies if the freeze row index is set at element levelisColumnEdge
- specifies if the freeze column index is set at element levelprotected void setSheetName(java.lang.String sheetName)
setSheetName
in class JRXlsAbstractExporter
protected void setAutoFilter(java.lang.String autoFilterRange)
setAutoFilter
in class JRXlsAbstractExporter
protected void setRowLevels(XlsRowLevelInfo levelInfo, java.lang.String level)
setRowLevels
in class JRXlsAbstractExporter
© 2001-2010 Jaspersoft Corporation www.jaspersoft.com