net.sf.jasperreports.engine.export
Class JExcelApiExporter

java.lang.Object
  extended by net.sf.jasperreports.engine.JRAbstractExporter
      extended by net.sf.jasperreports.engine.export.JRXlsAbstractExporter
          extended by net.sf.jasperreports.engine.export.JExcelApiExporter
All Implemented Interfaces:
JRExporter

public class JExcelApiExporter
extends JRXlsAbstractExporter

Version:
$Id: JExcelApiExporter.java 2079 2008-02-07 14:33:11Z shertage $
Author:
Manuel Paul (mpaul@ratundtat.com)

Nested Class Summary
protected  class JExcelApiExporter.BoxStyle
           
protected  class JExcelApiExporter.CellTextValueHandler
           
protected  class JExcelApiExporter.StyleInfo
           
 
Nested classes/interfaces inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
JRXlsAbstractExporter.TextAlignHolder
 
Nested classes/interfaces inherited from class net.sf.jasperreports.engine.JRAbstractExporter
JRAbstractExporter.ParameterOverriddenResolver, JRAbstractExporter.ParameterOverrideResolver, JRAbstractExporter.ParameterResolver
 
Field Summary
protected static Colour BLACK
           
protected  boolean createCustomPalette
           
protected static java.lang.String EMPTY_SHEET_NAME
           
protected  java.util.Map formatPatternsMap
           
protected  ExporterNature nature
           
protected  java.util.Map usedColours
           
protected static Colour WHITE
           
protected  java.util.Map workbookColours
           
 
Fields inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
currentSheetName, defaultFont, fontMap, hyperlinkProducerFactory, isAutoDetectCellType, isCollapseRowSpan, isDetectCellType, isFontSizeFixEnabled, isIgnoreCellBorder, isIgnoreGraphics, isIgnorePageMargins, isOnePagePerSheet, isRemoveEmptySpaceBetweenColumns, isRemoveEmptySpaceBetweenRows, isWhitePageBackground, loadedFonts, maxRowsPerSheet, progressMonitor, reportIndex, sheetIndex, sheetNames, sheetNamesMap
 
Fields inherited from class net.sf.jasperreports.engine.JRAbstractExporter
classLoader, classLoaderSet, dateFormatCache, endPageIndex, fileResolver, fileResolverSet, filter, globalOffsetX, globalOffsetY, isModeBatch, jasperPrint, jasperPrintList, numberFormatCache, parameters, startPageIndex, urlHandlerFactory, urlHandlerFactorySet
 
Constructor Summary
JExcelApiExporter()
           
 
Method Summary
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 closeWorkbook(java.io.OutputStream os)
           
protected  void createSheet(java.lang.String name)
           
protected  Colour determineWorkbookColour(java.awt.Color awtColor)
           
protected  void exportFrame(JRPrintFrame frame, JRExporterGridCell gridCell, int col, int row)
           
protected  void exportImage(JRPrintImage element, JRExporterGridCell gridCell, int col, int row, int emptyCols)
           
protected  void exportLine(JRPrintLine line, JRExporterGridCell gridCell, int col, int row)
           
protected  void exportRectangle(JRPrintGraphicElement element, JRExporterGridCell gridCell, int col, int row)
           
protected  void exportText(JRPrintText text, JRExporterGridCell gridCell, int col, int row)
           
protected  CellValue getAutoDetectedCellValue(int x, int y, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle)
           
protected static BorderLineStyle getBorderLineStyle(JRPen pen)
           
protected  jxl.write.DateFormat getDateFormat(java.lang.String pattern)
           
protected  CellValue getDetectedCellValue(int x, int y, JRPrintText text, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle)
           
protected  CellValue getLabelCell(int x, int y, java.lang.String textStr, JExcelApiExporter.StyleInfo baseStyle)
           
protected  WritableCellFormat getLoadedCellStyle(JExcelApiExporter.StyleInfo styleKey)
           
protected  ExporterNature getNature()
           
protected static Colour getNearestColour(java.awt.Color awtColor)
           
protected  jxl.write.NumberFormat getNumberFormat(java.lang.String pattern)
           
static JRXlsAbstractExporter.TextAlignHolder getTextAlignHolder(JRPrintText textElement)
           
protected  Colour getWorkbookColour(java.awt.Color awtColor)
           
protected  void initCustomPalette()
           
protected  void openWorkbook(java.io.OutputStream os)
           
protected  void removeColumn(int col)
           
protected static int rgbDistance(java.awt.Color awtColor, RGB rgb)
           
protected  void setBackground()
           
protected  void setCell(int x, int y)
           
protected  void setColourUsed(Colour colour)
           
protected  void setColourUsed(Colour colour, java.awt.Color reportColour)
           
protected  void setColumnWidth(int col, int width)
           
protected  void setParameters()
           
protected  void setRowHeight(int y, int lastRowHeight)
           
 
Methods inherited from class net.sf.jasperreports.engine.export.JRXlsAbstractExporter
exportPage, exportReport, exportReportToStream, getCustomHandler, getDefaultFont, getImageBorderCorrection, getStyledText, removeEmptyColumns, setColumnWidths
 
Methods inherited from class net.sf.jasperreports.engine.JRAbstractExporter
defaultParseNumber, getBooleanCellValue, getBooleanParameter, getDateCellValue, getDateFormat, getIntegerParameter, getNumberCellValue, getNumberFormat, getOffsetX, getOffsetY, getParameter, getParameterResolver, getParameters, getStringParameter, getStringParameterOrDefault, getStyledText, getTextFormatFactoryClass, getTextLocale, getTextTimeZone, getTextValue, getTextValueString, reset, resetClassLoader, resetExportContext, restoreElementOffsets, setClassLoader, setExportContext, setFrameElementsOffset, setInput, setOffset, setOffset, setOutput, setPageRange, setParameter, setParameters
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

WHITE

protected static final Colour WHITE

BLACK

protected static final Colour BLACK

EMPTY_SHEET_NAME

protected static final java.lang.String EMPTY_SHEET_NAME
See Also:
Constant Field Values

formatPatternsMap

protected java.util.Map formatPatternsMap

createCustomPalette

protected boolean createCustomPalette

workbookColours

protected java.util.Map workbookColours

usedColours

protected java.util.Map usedColours

nature

protected ExporterNature nature
Constructor Detail

JExcelApiExporter

public JExcelApiExporter()
Method Detail

setParameters

protected void setParameters()
Overrides:
setParameters in class JRXlsAbstractExporter

initCustomPalette

protected void initCustomPalette()

setColourUsed

protected void setColourUsed(Colour colour)

setColourUsed

protected void setColourUsed(Colour colour,
                             java.awt.Color reportColour)

setBackground

protected void setBackground()
Specified by:
setBackground in class JRXlsAbstractExporter

openWorkbook

protected void openWorkbook(java.io.OutputStream os)
                     throws JRException
Specified by:
openWorkbook in class JRXlsAbstractExporter
Throws:
JRException

createSheet

protected void createSheet(java.lang.String name)
Specified by:
createSheet in class JRXlsAbstractExporter

closeWorkbook

protected void closeWorkbook(java.io.OutputStream os)
                      throws JRException
Specified by:
closeWorkbook in class JRXlsAbstractExporter
Throws:
JRException

setColumnWidth

protected void setColumnWidth(int col,
                              int width)
Specified by:
setColumnWidth in class JRXlsAbstractExporter

setRowHeight

protected void setRowHeight(int y,
                            int lastRowHeight)
                     throws JRException
Specified by:
setRowHeight in class JRXlsAbstractExporter
Throws:
JRException

setCell

protected void setCell(int x,
                       int y)
Specified by:
setCell in class JRXlsAbstractExporter

removeColumn

protected void removeColumn(int col)
Specified by:
removeColumn in class JRXlsAbstractExporter

addBlankCell

protected void addBlankCell(JRExporterGridCell gridCell,
                            int colIndex,
                            int rowIndex)
                     throws JRException
Specified by:
addBlankCell in class JRXlsAbstractExporter
Throws:
JRException

exportLine

protected void exportLine(JRPrintLine line,
                          JRExporterGridCell gridCell,
                          int col,
                          int row)
                   throws JRException
Specified by:
exportLine in class JRXlsAbstractExporter
Throws:
JRException

exportRectangle

protected void exportRectangle(JRPrintGraphicElement element,
                               JRExporterGridCell gridCell,
                               int col,
                               int row)
                        throws JRException
Specified by:
exportRectangle in class JRXlsAbstractExporter
Throws:
JRException

exportText

protected void exportText(JRPrintText text,
                          JRExporterGridCell gridCell,
                          int col,
                          int row)
                   throws JRException
Specified by:
exportText in class JRXlsAbstractExporter
Throws:
JRException

addCell

protected void addCell(int x,
                       int y,
                       JRPrintText text,
                       java.lang.String textStr,
                       JExcelApiExporter.StyleInfo baseStyle)
                throws WriteException,
                       RowsExceededException,
                       JRException
Throws:
WriteException
RowsExceededException
JRException

getDetectedCellValue

protected CellValue getDetectedCellValue(int x,
                                         int y,
                                         JRPrintText text,
                                         java.lang.String textStr,
                                         JExcelApiExporter.StyleInfo baseStyle)
                                  throws JRException
Throws:
JRException

getNumberFormat

protected jxl.write.NumberFormat getNumberFormat(java.lang.String pattern)

getDateFormat

protected jxl.write.DateFormat getDateFormat(java.lang.String pattern)

getAutoDetectedCellValue

protected CellValue getAutoDetectedCellValue(int x,
                                             int y,
                                             java.lang.String textStr,
                                             JExcelApiExporter.StyleInfo baseStyle)
                                      throws JRException
Throws:
JRException

getLabelCell

protected CellValue getLabelCell(int x,
                                 int y,
                                 java.lang.String textStr,
                                 JExcelApiExporter.StyleInfo baseStyle)
                          throws JRException
Throws:
JRException

addMergeRegion

protected void addMergeRegion(JRExporterGridCell gridCell,
                              int x,
                              int y)
                       throws JRException
Throws:
JRException

exportImage

protected void exportImage(JRPrintImage element,
                           JRExporterGridCell gridCell,
                           int col,
                           int row,
                           int emptyCols)
                    throws JRException
Specified by:
exportImage in class JRXlsAbstractExporter
Throws:
JRException

getWorkbookColour

protected Colour getWorkbookColour(java.awt.Color awtColor)

determineWorkbookColour

protected Colour determineWorkbookColour(java.awt.Color awtColor)

getNearestColour

protected static Colour getNearestColour(java.awt.Color awtColor)

rgbDistance

protected static int rgbDistance(java.awt.Color awtColor,
                                 RGB rgb)

getLoadedCellStyle

protected WritableCellFormat getLoadedCellStyle(JExcelApiExporter.StyleInfo styleKey)
                                         throws JRException
Throws:
JRException

getBorderLineStyle

protected static BorderLineStyle getBorderLineStyle(JRPen pen)

getTextAlignHolder

public static JRXlsAbstractExporter.TextAlignHolder getTextAlignHolder(JRPrintText textElement)

exportFrame

protected void exportFrame(JRPrintFrame frame,
                           JRExporterGridCell gridCell,
                           int col,
                           int row)
                    throws JRException
Specified by:
exportFrame in class JRXlsAbstractExporter
Throws:
JRException

getNature

protected ExporterNature getNature()
Specified by:
getNature in class JRXlsAbstractExporter


© 2001-2006 JasperSoft Corporation www.jaspersoft.com