JRXlsExporter
or JRXlsxExporter
instead.public class JExcelApiExporter extends JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
Modifier and Type | Class and Description |
---|---|
protected class |
JExcelApiExporter.BoxStyle
Deprecated.
|
protected class |
JExcelApiExporter.CellTextValueHandler
Deprecated.
|
protected class |
JExcelApiExporter.ExporterContext
Deprecated.
|
protected class |
JExcelApiExporter.FormulaTextValueHandler
Deprecated.
|
protected class |
JExcelApiExporter.StyleInfo
Deprecated.
|
JRXlsAbstractExporter.SheetInfo, JRXlsAbstractExporter.TextAlignHolder
JRAbstractExporter.BaseExporterContext, JRAbstractExporter.PageRange
Modifier and Type | Field and Description |
---|---|
protected java.util.Map<java.lang.String,java.util.List<JExcelApiLocalHyperlinkInfo>> |
anchorLinks
Deprecated.
|
protected static jxl.format.Colour |
BLACK
Deprecated.
|
protected static java.lang.String |
EMPTY_SHEET_NAME
Deprecated.
|
static java.lang.String |
JXL_EXPORTER_KEY
Deprecated.
The exporter key, as used in
GenericElementHandlerEnviroment.getElementHandler(net.sf.jasperreports.engine.JRGenericElementType, String) . |
protected java.util.Map<java.lang.Integer,java.util.List<JExcelApiLocalHyperlinkInfo>> |
pageLinks
Deprecated.
|
static java.lang.String |
PROPERTY_COMPLEX_FORMAT
Deprecated.
Replaced by
JxlReportConfiguration.PROPERTY_COMPLEX_FORMAT . |
static java.lang.String |
PROPERTY_USE_TEMP_FILE
Deprecated.
Replaced by
JxlExporterConfiguration.PROPERTY_USE_TEMP_FILE . |
protected java.util.Map<jxl.format.Colour,jxl.format.RGB> |
usedColours
Deprecated.
|
protected static jxl.format.Colour |
WHITE
Deprecated.
|
protected java.util.Map<java.awt.Color,jxl.format.Colour> |
workbookColours
Deprecated.
|
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, invalidCharReplacement, keepTemplateSheets, loadedFonts, maxColumnIndex, 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, renderersCache, reportIndex, sheetIndex, sheetInfo, sheetNames, sheetNamesIndex, sheetNamesMap, sheetsBeforeCurrentReport, sheetsBeforeCurrentReportMap, workbookTemplate, XLS_EXPORTER_PROPERTIES_PREFIX
allSelector, crtCompositeConfiguration, crtCompositeItemConfiguration, crtItem, dateFormatCache, EXCEPTION_MESSAGE_KEY_END_PAGE_INDEX_OUT_OF_RANGE, EXCEPTION_MESSAGE_KEY_INVALID_IMAGE_NAME, EXCEPTION_MESSAGE_KEY_INVALID_ZOOM_RATIO, EXCEPTION_MESSAGE_KEY_MIXED_CALLS_NOT_ALLOWED, 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, parameters, propertiesUtil, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, rendererUtil, styledTextUtil, textValueClasses
Constructor and Description |
---|
JExcelApiExporter()
Deprecated.
|
JExcelApiExporter(JasperReportsContext jasperReportsContext)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
protected void |
addBlankCell(JRExporterGridCell gridCell,
int colIndex,
int rowIndex)
Deprecated.
|
protected void |
addCell(int x,
int y,
JRPrintText text,
java.lang.String textStr,
JExcelApiExporter.StyleInfo baseStyle)
Deprecated.
|
protected void |
addMergeRegion(JRExporterGridCell gridCell,
int x,
int y)
Deprecated.
|
protected void |
addOccupiedCell(OccupiedGridCell occupiedGridCell,
int colIndex,
int rowIndex)
Deprecated.
|
protected void |
addRowBreak(int rowIndex)
Deprecated.
|
protected void |
closeSheet()
Deprecated.
|
protected void |
closeWorkbook(java.io.OutputStream os)
Deprecated.
|
protected void |
createSheet(CutsInfo xCuts,
JRXlsAbstractExporter.SheetInfo sheetInfo)
Deprecated.
|
protected jxl.format.Colour |
determineWorkbookColour(java.awt.Color awtColor)
Deprecated.
|
protected void |
exportFrame(JRPrintFrame frame,
JRExporterGridCell gridCell,
int col,
int row)
Deprecated.
|
protected void |
exportGenericElement(JRGenericPrintElement element,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
int emptyCols,
int yCutsRow,
JRGridLayout layout)
Deprecated.
|
void |
exportHyperlink(JRPrintHyperlink link,
java.lang.String description,
JRExporterGridCell gridCell,
int col,
int row)
Deprecated.
|
protected void |
exportHyperlink(java.lang.String href,
int col,
int row,
int lastCol,
int lastRow)
Deprecated.
|
void |
exportImage(JRPrintImage element,
JRExporterGridCell gridCell,
int col,
int row,
int emptyCols,
int yCutsRow,
JRGridLayout layout)
Deprecated.
|
protected void |
exportLine(JRPrintLine line,
JRExporterGridCell gridCell,
int col,
int row)
Deprecated.
|
protected void |
exportRectangle(JRPrintGraphicElement element,
JRExporterGridCell gridCell,
int col,
int row)
Deprecated.
|
void |
exportText(JRPrintText text,
JRExporterGridCell gridCell,
int col,
int row)
Deprecated.
|
protected static jxl.format.BorderLineStyle |
getBorderLineStyle(JRPen pen)
Deprecated.
|
protected double |
getColumnRelativePosition(JRGridLayout layout,
int col,
int offset)
Deprecated.
|
protected java.lang.Class<JxlExporterConfiguration> |
getConfigurationInterface()
Deprecated.
|
protected jxl.write.DateFormat |
getDateFormat(java.lang.String convertedPattern)
Deprecated.
|
protected jxl.write.biff.CellValue |
getDetectedCellValue(int x,
int y,
JRPrintText textElement,
TextValue textValue,
JExcelApiExporter.StyleInfo baseStyle,
boolean complexFormat)
Deprecated.
|
java.lang.String |
getExporterKey()
Deprecated.
|
java.lang.String |
getExporterPropertiesPrefix()
Deprecated.
Returns the properties prefix for the current exporter.
|
protected jxl.write.biff.CellValue |
getFormulaCellValue(int x,
int y,
JRPrintText textElement,
TextValue textValue,
java.lang.String formula,
JExcelApiExporter.StyleInfo baseStyle,
boolean complexFormat)
Deprecated.
|
protected java.lang.Class<JxlReportConfiguration> |
getItemConfigurationInterface()
Deprecated.
|
protected jxl.write.biff.CellValue |
getLabelCell(int x,
int y,
java.lang.String textStr,
JExcelApiExporter.StyleInfo baseStyle)
Deprecated.
|
protected jxl.write.WritableCellFormat |
getLoadedCellStyle(JExcelApiExporter.StyleInfo styleKey)
Deprecated.
|
protected java.lang.Integer |
getMaxRowsPerSheet()
Deprecated.
|
protected static jxl.format.Colour |
getNearestColour(java.awt.Color awtColor)
Deprecated.
|
protected jxl.write.NumberFormat |
getNumberFormat(java.lang.String convertedPattern,
boolean isComplexFormat)
Deprecated.
|
protected double |
getRowRelativePosition(JRGridLayout layout,
int row,
int offset)
Deprecated.
|
protected jxl.format.Colour |
getWorkbookColour(java.awt.Color awtColor)
Deprecated.
|
protected jxl.format.Colour |
getWorkbookColour(java.awt.Color awtColor,
boolean isBackcolor)
Deprecated.
|
protected void |
initCustomPalette()
Deprecated.
|
protected void |
initExport()
Deprecated.
|
protected void |
initReport()
Deprecated.
|
protected boolean |
isComplexFormat(JRPrintElement element)
Deprecated.
|
protected void |
openWorkbook(java.io.OutputStream os)
Deprecated.
|
protected static int |
rgbDistance(java.awt.Color awtColor,
jxl.format.RGB rgb)
Deprecated.
|
protected void |
setAnchorType(jxl.write.WritableImage image,
ImageAnchorTypeEnum anchorType)
Deprecated.
|
protected void |
setAutoFilter(java.lang.String autoFilterRange)
Deprecated.
|
protected void |
setColourUsed(jxl.format.Colour colour)
Deprecated.
|
protected void |
setColourUsed(jxl.format.Colour colour,
java.awt.Color reportColour)
Deprecated.
|
protected void |
setColumnWidth(int col,
int width,
boolean autoFit)
Deprecated.
|
protected void |
setFreezePane(int rowIndex,
int colIndex)
Deprecated.
Creates a freeze pane for the current sheet.
|
protected void |
setFreezePane(int rowIndex,
int colIndex,
boolean isRowEdge,
boolean isColumnEdge)
Deprecated.
to be removed; replaced by
setFreezePane(int, int) |
protected void |
setRowHeight(int rowIndex,
int lastRowHeight,
Cut yCut,
XlsRowLevelInfo levelInfo)
Deprecated.
|
protected void |
setRowLevels(XlsRowLevelInfo levelInfo,
java.lang.String level)
Deprecated.
|
protected void |
setSheetName(java.lang.String sheetName)
Deprecated.
|
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, ensureInput, ensureOutput, exportEmptyReport, 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, setSheetNames, setWorkbookTemplate, setWorkbookTemplateKeepSheets, translateDateValue
createFilter, defaultParseNumber, ensureJasperReportsContext, getBooleanCellValue, getCurrentConfiguration, getCurrentItemConfiguration, getCurrentJasperPrint, getCustomHandler, getDateCellValue, getDateFormat, getExporterContext, getExporterInput, getExporterOutput, getHyperlinkProducer, getJasperReportsContext, getLocale, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getPageRange, getParameter, getParameters, getPropertiesUtil, getRendererUtil, 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
public static final java.lang.String PROPERTY_USE_TEMP_FILE
JxlExporterConfiguration.PROPERTY_USE_TEMP_FILE
.public static final java.lang.String PROPERTY_COMPLEX_FORMAT
JxlReportConfiguration.PROPERTY_COMPLEX_FORMAT
.public static final java.lang.String JXL_EXPORTER_KEY
GenericElementHandlerEnviroment.getElementHandler(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<java.awt.Color,jxl.format.Colour> workbookColours
protected java.util.Map<jxl.format.Colour,jxl.format.RGB> usedColours
protected java.util.Map<java.lang.String,java.util.List<JExcelApiLocalHyperlinkInfo>> anchorLinks
protected java.util.Map<java.lang.Integer,java.util.List<JExcelApiLocalHyperlinkInfo>> pageLinks
public JExcelApiExporter()
JExcelApiExporter(JasperReportsContext)
public JExcelApiExporter(JasperReportsContext jasperReportsContext)
protected java.lang.Class<JxlExporterConfiguration> getConfigurationInterface()
protected java.lang.Class<JxlReportConfiguration> getItemConfigurationInterface()
protected void initExport()
protected void initReport()
protected void initCustomPalette()
protected void setColourUsed(jxl.format.Colour colour)
protected void setColourUsed(jxl.format.Colour colour, java.awt.Color reportColour)
protected void openWorkbook(java.io.OutputStream os) throws JRException
openWorkbook
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void createSheet(CutsInfo xCuts, JRXlsAbstractExporter.SheetInfo sheetInfo)
createSheet
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void closeSheet()
closeSheet
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void closeWorkbook(java.io.OutputStream os) throws JRException
closeWorkbook
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void setColumnWidth(int col, int width, boolean autoFit)
setColumnWidth
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void setRowHeight(int rowIndex, int lastRowHeight, Cut yCut, XlsRowLevelInfo levelInfo) throws JRException
setRowHeight
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void addRowBreak(int rowIndex)
addRowBreak
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
addBlankCell
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex) throws JRException
addOccupiedCell
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int col, int row) throws JRException
exportLine
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int col, int row) throws JRException
exportRectangle
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
public void exportText(JRPrintText text, JRExporterGridCell gridCell, int col, int row) throws JRException
exportText
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
public void exportHyperlink(JRPrintHyperlink link, java.lang.String description, JRExporterGridCell gridCell, int col, int row) throws JRException
JRException
protected void exportHyperlink(java.lang.String href, int col, int row, int lastCol, int lastRow) throws JRException
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, JRPrintText textElement, TextValue textValue, java.lang.String formula, JExcelApiExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected jxl.write.biff.CellValue getDetectedCellValue(int x, int y, JRPrintText textElement, TextValue textValue, JExcelApiExporter.StyleInfo baseStyle, boolean complexFormat) throws JRException
JRException
protected jxl.write.NumberFormat getNumberFormat(java.lang.String convertedPattern, boolean isComplexFormat)
protected jxl.write.DateFormat getDateFormat(java.lang.String convertedPattern)
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
public void exportImage(JRPrintImage element, JRExporterGridCell gridCell, int col, int row, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportImage
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
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)
protected void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int col, int row) throws JRException
exportFrame
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected void exportGenericElement(JRGenericPrintElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportGenericElement
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
JRException
protected java.lang.Integer getMaxRowsPerSheet()
public java.lang.String getExporterKey()
public java.lang.String getExporterPropertiesPrefix()
JRAbstractExporter
getExporterPropertiesPrefix
in class JRAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,OutputStreamExporterOutput,JExcelApiExporterContext>
protected boolean isComplexFormat(JRPrintElement element)
protected void setFreezePane(int rowIndex, int colIndex)
setFreezePane
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
rowIndex
- the freeze 0-based row indexcolIndex
- the freeze 0-based column indexprotected void setFreezePane(int rowIndex, int colIndex, boolean isRowEdge, boolean isColumnEdge)
setFreezePane(int, int)
setFreezePane
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void setSheetName(java.lang.String sheetName)
setSheetName
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void setAutoFilter(java.lang.String autoFilterRange)
setAutoFilter
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void setRowLevels(XlsRowLevelInfo levelInfo, java.lang.String level)
setRowLevels
in class JRXlsAbstractExporter<JxlReportConfiguration,JxlExporterConfiguration,JExcelApiExporterContext>
protected void setAnchorType(jxl.write.WritableImage image, ImageAnchorTypeEnum anchorType)
© 2001 - 2017 TIBCO Software Inc. www.jaspersoft.com