net.sf.jxls.transformer
Class SheetTransformer

java.lang.Object
  net.sf.jxls.transformer.SheetTransformer

public class SheetTransformer
extends java.lang.Object

Author:

Leonid Vysochyn

Field Summary

protected org.apache.commons.logging.Log

log

Constructor Summary

SheetTransformer(java.util.Set fixedSizeCollections, java.util.Set groupedCollections, java.util.List rowProcessors, java.util.List cellProcessors)

SheetTransformer(java.util.Set fixedSizeCollections, java.util.Set groupedCollections, java.util.List rowProcessors, java.util.List cellProcessors, Configuration configuration)

Method Summary

(package private) void	groupRows(Sheet sheet) Outlines all required collections in a sheet
(package private) RowTransformer	parseRow(Sheet sheet, org.apache.poi.hssf.usermodel.HSSFRow hssfRow, java.util.Map beans)
(package private) ResultTransformation	processRow(SheetTransformationController stc, Sheet sheet, org.apache.poi.hssf.usermodel.HSSFRow hssfRow, java.util.Map beans, Row parentRow)
ResultTransformation	processRow(SheetTransformationController stc, Sheet sheet, org.apache.poi.hssf.usermodel.HSSFRow hssfRow, short startCell, short endCell, java.util.Map beans, Row parentRow)
ResultTransformation	processRows(SheetTransformationController stc, Sheet sheet, int startRow, int endRow, java.util.Map beans, Row parentRow) Processes rows in a template sheet using map of beans as parameter
void	setGroupedCollections(java.util.Set groupedCollections)
(package private) void	transformSheet(WorkbookTransformationController workbookTransformationController, Sheet sheet, java.util.Map beans)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

log

protected final org.apache.commons.logging.Log log

Constructor Detail

SheetTransformer

public SheetTransformer(java.util.Set fixedSizeCollections,
                        java.util.Set groupedCollections,
                        java.util.List rowProcessors,
                        java.util.List cellProcessors,
                        Configuration configuration)

SheetTransformer

public SheetTransformer(java.util.Set fixedSizeCollections,
                        java.util.Set groupedCollections,
                        java.util.List rowProcessors,
                        java.util.List cellProcessors)

Method Detail

setGroupedCollections

public void setGroupedCollections(java.util.Set groupedCollections)

transformSheet

void transformSheet(WorkbookTransformationController workbookTransformationController,
                    Sheet sheet,
                    java.util.Map beans)
              throws ParsePropertyException

Throws:

ParsePropertyException

processRows

public ResultTransformation processRows(SheetTransformationController stc,
                                        Sheet sheet,
                                        int startRow,
                                        int endRow,
                                        java.util.Map beans,
                                        Row parentRow)
                                 throws ParsePropertyException

Processes rows in a template sheet using map of beans as parameter

Parameters:

stc - - SheetTransformationController corresponding to the sheet containing given rows

sheet - Sheet object

startRow - Row to start processing

endRow - Last row to be processed

beans - Beans for substitution

parentRow - - Row object representing original template row linked to rows to process

Returns:

A number of rows to be shifted

Throws:

ParsePropertyException

processRow

ResultTransformation processRow(SheetTransformationController stc,
                                Sheet sheet,
                                org.apache.poi.hssf.usermodel.HSSFRow hssfRow,
                                java.util.Map beans,
                                Row parentRow)

processRow

public ResultTransformation processRow(SheetTransformationController stc,
                                       Sheet sheet,
                                       org.apache.poi.hssf.usermodel.HSSFRow hssfRow,
                                       short startCell,
                                       short endCell,
                                       java.util.Map beans,
                                       Row parentRow)

parseRow

RowTransformer parseRow(Sheet sheet,
                        org.apache.poi.hssf.usermodel.HSSFRow hssfRow,
                        java.util.Map beans)

groupRows

void groupRows(Sheet sheet)

Outlines all required collections in a sheet

Parameters:

sheet - - Sheet where to outline collections