public class JRXlsxExporter extends JRXlsAbstractExporter
| Modifier and Type | Class and Description |
|---|---|
protected class |
JRXlsxExporter.ExporterContext |
JRXlsAbstractExporter.TextAlignHolderJRAbstractExporter.BaseExporterContext, JRAbstractExporter.ParameterOverriddenResolver, JRAbstractExporter.ParameterOverrideResolver, JRAbstractExporter.ParameterResolverautoFilterEnd, 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, 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_PREFIXdateFormatCache, endPageIndex, filter, globalOffsetX, globalOffsetY, hyperlinkProducerFactory, isModeBatch, jasperPrint, jasperPrintList, numberFormatCache, parameters, PROPERTY_DEFAULT_FILTER_FACTORY, PROPERTY_SUFFIX_DEFAULT_FILTER_FACTORY, startPageIndex| Constructor and Description |
|---|
JRXlsxExporter() |
| 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 |
closeSheet() |
protected void |
closeWorkbook(java.io.OutputStream os) |
protected void |
createSheet(java.lang.String name) |
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 void |
exportRectangle(JRPrintGraphicElement rectangle,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
exportStyledText(JRStyle style,
JRStyledText styledText,
java.util.Locale locale) |
void |
exportText(JRPrintText text,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected JRPrintElementIndex |
getElementIndex(JRExporterGridCell gridCell) |
protected java.lang.String |
getExporterKey() |
protected java.lang.String |
getExporterPropertiesPrefix() |
protected java.lang.String |
getHyperlinkTarget(JRPrintHyperlink link) |
protected java.lang.String |
getHyperlinkURL(JRPrintHyperlink link) |
static JRPrintImage |
getImage(java.util.List<JasperPrint> jasperPrintList,
JRPrintElementIndex imageIndex) |
static JRPrintImage |
getImage(java.util.List<JasperPrint> jasperPrintList,
java.lang.String imageName) |
protected java.lang.String |
getImagePath(JRRenderable renderer,
boolean isLazy,
JRExporterGridCell gridCell) |
protected ExporterNature |
getNature() |
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 |
openWorkbook(java.io.OutputStream os) |
protected void |
removeColumn(int col) |
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 |
setCell(JRExporterGridCell gridCell,
int colIndex,
int rowIndex) |
protected void |
setColumnWidth(int col,
int width,
boolean autoFit) |
protected void |
setFreezePane(int rowIndex,
int colIndex,
boolean isRowEdge,
boolean isColumnEdge) |
protected void |
setParameters() |
protected void |
setRowHeight(int rowIndex,
int rowHeight,
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) |
calculateHeightForDinAN, calculateHeightForDinBN, calculateHeightForDinCN, calculateWidthForDinAN, calculateWidthForDinBN, calculateWidthForDinCN, exportPage, exportReport, exportReportToStream, getColumnIndex, getColumnName, getConvertedPattern, getDefaultFont, getFormula, getImageBorderCorrection, getStyledText, getTextAlignHolder, isCellHidden, isCellLocked, isWrapText, mergeAndSetRowLevels, setColumnWidths, setExporterHints, setFreezePane, setSheetNames, updateColumnscreateFilter, 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, setReportContextpublic static final java.lang.String XLSX_EXPORTER_KEY
GenericElementHandlerEnviroment.getHandler(net.sf.jasperreports.engine.JRGenericElementType, String).protected static final java.lang.String XLSX_EXPORTER_PROPERTIES_PREFIX
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 JRExportProgressMonitor progressMonitor
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 ExporterNature nature
protected java.lang.String sheetAutoFilter
protected void setParameters()
setParameters in class JRXlsAbstractExporterpublic static JRPrintImage getImage(java.util.List<JasperPrint> jasperPrintList, java.lang.String imageName) throws JRException
JRExceptionpublic static JRPrintImage getImage(java.util.List<JasperPrint> jasperPrintList, JRPrintElementIndex imageIndex) throws JRException
JRExceptionprotected void exportStyledText(JRStyle style, JRStyledText styledText, java.util.Locale locale)
protected java.lang.String getImagePath(JRRenderable 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 java.lang.String getExporterPropertiesPrefix()
protected void addBlankCell(JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
addBlankCell in class JRXlsAbstractExporterJRExceptionprotected void closeWorkbook(java.io.OutputStream os)
throws JRException
closeWorkbook in class JRXlsAbstractExporterJRExceptionprotected void createSheet(java.lang.String name)
createSheet in class JRXlsAbstractExporterprotected void closeSheet()
protected void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportFrame in class JRXlsAbstractExporterJRExceptionpublic void exportImage(JRPrintImage image, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportImage in class JRXlsAbstractExporterJRExceptionprotected void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportLine in class JRXlsAbstractExporterJRExceptionprotected void exportRectangle(JRPrintGraphicElement rectangle, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportRectangle in class JRXlsAbstractExporterJRExceptionpublic void exportText(JRPrintText text, JRExporterGridCell gridCell, int colIndex, int rowIndex) throws JRException
exportText in class JRXlsAbstractExporterJRExceptionprotected void exportGenericElement(JRGenericPrintElement element, JRExporterGridCell gridCell, int colIndex, int rowIndex, int emptyCols, int yCutsRow, JRGridLayout layout) throws JRException
exportGenericElement in class JRXlsAbstractExporterJRExceptionprotected ExporterNature getNature()
getNature in class JRXlsAbstractExporterprotected void openWorkbook(java.io.OutputStream os)
throws JRException
openWorkbook in class JRXlsAbstractExporterJRExceptionprotected void removeColumn(int col)
removeColumn in class JRXlsAbstractExporterprotected void setBackground()
setBackground in class JRXlsAbstractExporterprotected void setCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
setCell in class JRXlsAbstractExporterprotected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
addOccupiedCell in class JRXlsAbstractExporterprotected void setColumnWidth(int col,
int width,
boolean autoFit)
setColumnWidth in class JRXlsAbstractExporterprotected void updateColumn(int col,
boolean autoFit)
updateColumn in class JRXlsAbstractExporterprotected void setRowHeight(int rowIndex,
int rowHeight,
Cut yCut,
XlsRowLevelInfo levelInfo)
throws JRException
setRowHeight in class JRXlsAbstractExporterJRExceptionprotected java.lang.String getExporterKey()
getExporterKey in class JRAbstractExporterprotected void setFreezePane(int rowIndex,
int colIndex,
boolean isRowEdge,
boolean isColumnEdge)
setFreezePane in class JRXlsAbstractExporterprotected void setSheetName(java.lang.String sheetName)
setSheetName in class JRXlsAbstractExporterprotected void setAutoFilter(java.lang.String autoFilterRange)
setAutoFilter in class JRXlsAbstractExporterprotected void resetAutoFilters()
resetAutoFilters in class JRXlsAbstractExporterprotected void setRowLevels(XlsRowLevelInfo levelInfo, java.lang.String level)
setRowLevels in class JRXlsAbstractExporter© 2001-2010 Jaspersoft Corporation www.jaspersoft.com