public class JRXlsxExporter extends JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRXlsAbstractExporter
,
XlsExporterConfiguration
,
XlsReportConfiguration
Modifier and Type | Class and Description |
---|---|
protected class |
JRXlsxExporter.ExporterContext |
JRXlsAbstractExporter.SheetInfo, JRXlsAbstractExporter.TextAlignHolder
JRAbstractExporter.BaseExporterContext, JRAbstractExporter.PageRange
Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
ABSOLUTE |
protected java.awt.Color |
backcolor |
protected java.util.LinkedList<java.awt.Color> |
backcolorStack |
protected XlsxCellHelper |
cellHelper |
protected XlsxContentTypesHelper |
ctHelper |
protected java.lang.Integer |
currentSheetFirstPageNumber |
protected java.lang.String |
currentSheetName |
protected java.lang.Integer |
currentSheetPageScale |
protected java.lang.StringBuffer |
definedNames |
protected XlsxDrawingHelper |
drawingHelper |
protected XlsxDrawingRelsHelper |
drawingRelsHelper |
protected java.lang.String |
firstSheetName |
static java.lang.String |
IMAGE_NAME_PREFIX |
protected static int |
IMAGE_NAME_PREFIX_LEGTH |
protected java.util.List<JRPrintElementIndex> |
imagesToProcess |
protected static java.lang.String |
JR_PAGE_ANCHOR_PREFIX |
protected java.lang.String |
macroTemplate |
protected PrintPageFormat |
oldPageFormat |
protected static java.lang.String |
ONE_CELL |
static java.lang.String |
PROPERTY_MACRO_TEMPLATE
Deprecated.
Replaced by
XlsxExporterConfiguration.PROPERTY_MACRO_TEMPLATE . |
protected XlsxRelsHelper |
relsHelper |
protected java.util.Map<java.lang.String,java.lang.String> |
rendererToImagePathMap |
protected java.lang.String |
sheetAutoFilter |
protected XlsxSheetHelper |
sheetHelper |
protected XlsxSheetRelsHelper |
sheetRelsHelper |
protected boolean |
startPage |
protected XlsxStyleHelper |
styleHelper |
protected int |
tableIndex |
protected static java.lang.String |
TWO_CELL |
protected XlsxWorkbookHelper |
wbHelper |
static java.lang.String |
XLSX_EXPORTER_KEY
The exporter key, as used in
GenericElementHandlerEnviroment.getElementHandler(JRGenericElementType, String) . |
protected static java.lang.String |
XLSX_EXPORTER_PROPERTIES_PREFIX |
protected XlsxZip |
xlsxZip |
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
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, itemConfiguration, jasperPrint, jasperReportsContext, noBackcolorSelector, noneSelector, numberFormatCache, parameters, propertiesUtil, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, styledTextUtil, textValueClasses
Constructor and Description |
---|
JRXlsxExporter() |
JRXlsxExporter(JasperReportsContext jasperReportsContext) |
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 |
createSheet(CutsInfo xCuts,
JRXlsAbstractExporter.SheetInfo sheetInfo) |
protected void |
exportFrame(JRPrintFrame frame,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
exportGenericElement(JRGenericPrintElement element,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
int emptyCols,
int yCutsRow,
JRGridLayout layout) |
void |
exportImage(JRPrintImage image,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
int emptyCols,
int yCutsRow,
JRGridLayout layout) |
protected void |
exportLine(JRPrintLine line,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected int |
exportPage(JRPrintPage page,
CutsInfo xCuts,
int startRow,
java.lang.String defaultSheetName) |
protected void |
exportRectangle(JRPrintGraphicElement rectangle,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
exportStyledText(JRStyle style,
JRStyledText styledText,
java.util.Locale locale,
boolean isStyledText) |
void |
exportText(JRPrintText text,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected java.lang.String |
getAnchorType(ImageAnchorTypeEnum anchorType) |
protected java.lang.Class<XlsxExporterConfiguration> |
getConfigurationInterface() |
protected java.lang.String |
getDefinedName(java.lang.String name) |
protected JRPrintElementIndex |
getElementIndex(JRExporterGridCell gridCell) |
java.lang.String |
getExporterKey() |
java.lang.String |
getExporterPropertiesPrefix()
Returns the properties prefix for the current exporter.
|
protected java.lang.String |
getHyperlinkTarget(JRPrintHyperlink link) |
protected java.lang.String |
getHyperlinkURL(JRPrintHyperlink link) |
JRPrintImage |
getImage(ExporterInput exporterInput,
JRPrintElementIndex imageIndex) |
protected java.lang.String |
getImagePath(Renderable renderer,
boolean isLazy,
JRExporterGridCell gridCell) |
protected java.lang.Class<XlsxReportConfiguration> |
getItemConfigurationInterface() |
java.lang.String |
getMacroTemplatePath()
Deprecated.
Replaced by
XlsxExporterConfiguration.getMacroTemplate() . |
static JRPrintElementIndex |
getPrintElementIndex(java.lang.String imageName)
protected void writeImageMap(String imageMapName, JRPrintHyperlink mainHyperlink, List imageMapAreas) throws IOException
{
writer.write("\n");
}
protected void writeImageAreaCoordinates(JRPrintImageArea area) throws IOException
{
int[] coords = area.getCoordinates();
if (coords != null && coords.length > 0)
{
StringBuffer coordsEnum = new StringBuffer(coords.length * 4);
coordsEnum.append(coords[0]);
for (int i = 1; i < coords.length; i++)
{
coordsEnum.append(',');
coordsEnum.append(coords[i]);
}
writer.write(" coords=\"" + coordsEnum + "\"");
}
}
protected void writeImageAreaHyperlink(JRPrintHyperlink hyperlink) throws IOException
{
String href = getHyperlinkURL(hyperlink);
if (href == null)
{
writer.write(" nohref=\"nohref\"");
}
else
{
writer.write(" href=\"" + href + "\"");
String target = getHyperlinkTarget(hyperlink);
if (target != null)
{
writer.write(" target=\"");
writer.write(target);
writer.write("\"");
}
}
if (hyperlink.getHyperlinkTooltip() != null)
{
writer.write(" title=\"");
writer.write(JRStringUtil.xmlEncode(hyperlink.getHyperlinkTooltip()));
writer.write("\"");
}
}
/**
|
protected void |
initExport() |
protected void |
initReport() |
protected void |
insertPageAnchor(int colIndex,
int rowIndex) |
protected void |
openWorkbook(java.io.OutputStream os) |
protected void |
resetAutoFilters() |
protected void |
restoreBackcolor() |
protected void |
setAutoFilter(java.lang.String autoFilterRange) |
protected void |
setBackcolor(java.awt.Color color) |
protected void |
setBackground() |
protected void |
setColumnWidth(int col,
int width,
boolean autoFit) |
protected void |
setFreezePane(int rowIndex,
int colIndex,
boolean isRowEdge,
boolean isColumnEdge) |
void |
setMacroTemplate(java.lang.String macroTemplate)
Deprecated.
Replaced by
XlsxExporterConfiguration.getMacroTemplate() . |
protected void |
setRowHeight(int rowIndex,
int rowHeight,
Cut yCut,
XlsRowLevelInfo levelInfo) |
protected void |
setRowLevels(XlsRowLevelInfo levelInfo,
java.lang.String level) |
protected void |
setScale(java.lang.Integer scale) |
protected void |
setSheetName(java.lang.String sheetName) |
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, ensureInput, ensureOutput, exportReport, exportReportToStream, exportSheet, getColumIndexName, getColumnIndex, getColumnName, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getMaxRowsPerSheet, getNature, getSheetProps, getStyledText, getTextAlignHolder, getWorkbookTemplate, hasGlobalSheetNames, isCellHidden, isCellLocked, isIgnoreTextFormatting, isShrinkToFit, isUseTimeZone, isValidScale, isWorkbookTemplateKeepSheets, isWrapText, mergeAndSetRowLevels, setColumnWidths, setFreezePane, 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, 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 XLSX_EXPORTER_KEY
GenericElementHandlerEnviroment.getElementHandler(JRGenericElementType, String)
.protected static final java.lang.String XLSX_EXPORTER_PROPERTIES_PREFIX
protected static final java.lang.String ONE_CELL
protected static final java.lang.String TWO_CELL
protected static final java.lang.String ABSOLUTE
public static final java.lang.String PROPERTY_MACRO_TEMPLATE
XlsxExporterConfiguration.PROPERTY_MACRO_TEMPLATE
.protected static final java.lang.String JR_PAGE_ANCHOR_PREFIX
public static final java.lang.String IMAGE_NAME_PREFIX
protected static final int IMAGE_NAME_PREFIX_LEGTH
protected XlsxZip xlsxZip
protected XlsxWorkbookHelper wbHelper
protected XlsxRelsHelper relsHelper
protected XlsxContentTypesHelper ctHelper
protected XlsxSheetHelper sheetHelper
protected XlsxSheetRelsHelper sheetRelsHelper
protected XlsxDrawingHelper drawingHelper
protected XlsxDrawingRelsHelper drawingRelsHelper
protected XlsxStyleHelper styleHelper
protected XlsxCellHelper cellHelper
protected java.lang.StringBuffer definedNames
protected java.lang.String firstSheetName
protected java.lang.String currentSheetName
protected java.util.Map<java.lang.String,java.lang.String> rendererToImagePathMap
protected java.util.List<JRPrintElementIndex> imagesToProcess
protected int tableIndex
protected boolean startPage
protected java.util.LinkedList<java.awt.Color> backcolorStack
protected java.awt.Color backcolor
protected java.lang.String sheetAutoFilter
protected java.lang.String macroTemplate
protected PrintPageFormat oldPageFormat
protected java.lang.Integer currentSheetPageScale
protected java.lang.Integer currentSheetFirstPageNumber
public JRXlsxExporter()
JRXlsxExporter(JasperReportsContext)
public JRXlsxExporter(JasperReportsContext jasperReportsContext)
protected java.lang.Class<XlsxExporterConfiguration> getConfigurationInterface()
protected java.lang.Class<XlsxReportConfiguration> getItemConfigurationInterface()
protected void initExport()
initExport
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void initReport()
initReport
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected int exportPage(JRPrintPage page, CutsInfo xCuts, int startRow, java.lang.String defaultSheetName) throws JRException
exportPage
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
public JRPrintImage getImage(ExporterInput exporterInput, JRPrintElementIndex imageIndex) throws JRException
JRException
protected void exportStyledText(JRStyle style, JRStyledText styledText, java.util.Locale locale, boolean isStyledText)
protected java.lang.String getImagePath(Renderable renderer, boolean isLazy, JRExporterGridCell gridCell)
protected JRPrintElementIndex getElementIndex(JRExporterGridCell gridCell)
public static JRPrintElementIndex getPrintElementIndex(java.lang.String imageName)
protected void setBackcolor(java.awt.Color color)
protected void restoreBackcolor()
protected java.lang.String getHyperlinkTarget(JRPrintHyperlink link)
protected java.lang.String getHyperlinkURL(JRPrintHyperlink link)
protected void insertPageAnchor(int colIndex, int rowIndex)
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
addBlankCell
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void closeWorkbook(java.io.OutputStream os) throws JRException
closeWorkbook
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void createSheet(CutsInfo xCuts, JRXlsAbstractExporter.SheetInfo sheetInfo)
createSheet
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void closeSheet()
closeSheet
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportFrame
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
public void exportImage(JRPrintImage image, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportImage
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportLine
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void exportRectangle(JRPrintGraphicElement rectangle, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportRectangle
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
public void exportText(JRPrintText text, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportText
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void exportGenericElement(JRGenericPrintElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportGenericElement
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void openWorkbook(java.io.OutputStream os) throws JRException
openWorkbook
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void setBackground()
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
addOccupiedCell
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void setColumnWidth(int col, int width, boolean autoFit)
setColumnWidth
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void setRowHeight(int rowIndex, int rowHeight, Cut yCut, XlsRowLevelInfo levelInfo) throws JRException
setRowHeight
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
JRException
protected void addRowBreak(int rowIndex)
addRowBreak
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
public java.lang.String getExporterKey()
public java.lang.String getExporterPropertiesPrefix()
JRAbstractExporter
getExporterPropertiesPrefix
in class JRAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,OutputStreamExporterOutput,JRXlsxExporterContext>
protected void setFreezePane(int rowIndex, int colIndex, boolean isRowEdge, boolean isColumnEdge)
setFreezePane
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void setSheetName(java.lang.String sheetName)
setSheetName
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void setAutoFilter(java.lang.String autoFilterRange)
setAutoFilter
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
protected void resetAutoFilters()
protected void setRowLevels(XlsRowLevelInfo levelInfo, java.lang.String level)
setRowLevels
in class JRXlsAbstractExporter<XlsxReportConfiguration,XlsxExporterConfiguration,JRXlsxExporterContext>
public java.lang.String getMacroTemplatePath()
XlsxExporterConfiguration.getMacroTemplate()
.public void setMacroTemplate(java.lang.String macroTemplate)
XlsxExporterConfiguration.getMacroTemplate()
.protected void setScale(java.lang.Integer scale)
protected java.lang.String getAnchorType(ImageAnchorTypeEnum anchorType)
protected java.lang.String getDefinedName(java.lang.String name)
© 2001-2014 TIBCO Software Inc. www.jaspersoft.com