idare.imagenode.internal.DataSetReaders.CSVReader

Class CSVSheet

java.lang.Object

idare.imagenode.internal.DataSetReaders.CSVReader.CSVSheet

All Implemented Interfaces:

Iterable<org.apache.poi.ss.usermodel.Row>, org.apache.poi.ss.usermodel.Sheet

public class CSVSheet
extends Object
implements org.apache.poi.ss.usermodel.Sheet

A Sheet implementation to be used for CSV files.

Author:

Thomas Pfau

Field Summary

Fields inherited from interface org.apache.poi.ss.usermodel.Sheet

BottomMargin, FooterMargin, HeaderMargin, LeftMargin, PANE_LOWER_LEFT, PANE_LOWER_RIGHT, PANE_UPPER_LEFT, PANE_UPPER_RIGHT, RightMargin, TopMargin

Constructor Summary

Constructors

Constructor and Description
CSVSheet(CSVWorkbook workbook, String SheetName) Simple constructor.

Method Summary

Modifier and Type	Method and Description
int	addMergedRegion(org.apache.poi.ss.util.CellRangeAddress arg0)
void	addValidationData(org.apache.poi.ss.usermodel.DataValidation arg0)
void	autoSizeColumn(int arg0)
void	autoSizeColumn(int arg0, boolean arg1)
org.apache.poi.ss.usermodel.Drawing	createDrawingPatriarch()
void	createFreezePane(int arg0, int arg1)
void	createFreezePane(int arg0, int arg1, int arg2, int arg3)
org.apache.poi.ss.usermodel.Row	createRow(int arg0)
void	createSplitPane(int arg0, int arg1, int arg2, int arg3, int arg4)
boolean	getAutobreaks()
org.apache.poi.ss.usermodel.Comment	getCellComment(int arg0, int arg1)
int[]	getColumnBreaks()
org.apache.poi.ss.usermodel.CellStyle	getColumnStyle(int arg0)
int	getColumnWidth(int arg0)
org.apache.poi.ss.usermodel.DataValidationHelper	getDataValidationHelper()
int	getDefaultColumnWidth()
short	getDefaultRowHeight()
float	getDefaultRowHeightInPoints()
boolean	getDisplayGuts()
int	getFirstRowNum()
boolean	getFitToPage()
org.apache.poi.ss.usermodel.Footer	getFooter()
boolean	getForceFormulaRecalculation()
org.apache.poi.ss.usermodel.Header	getHeader()
boolean	getHorizontallyCenter()
int	getLastRowNum()
short	getLeftCol()
double	getMargin(short arg0)
org.apache.poi.ss.util.CellRangeAddress	getMergedRegion(int arg0)
int	getNumMergedRegions()
org.apache.poi.hssf.util.PaneInformation	getPaneInformation()
int	getPhysicalNumberOfRows()
org.apache.poi.ss.usermodel.PrintSetup	getPrintSetup()
boolean	getProtect()
org.apache.poi.ss.usermodel.Row	getRow(int arg0)
int[]	getRowBreaks()
int	getRowNumber(org.apache.poi.ss.usermodel.Row row) get the row position of a row.
boolean	getRowSumsBelow()
boolean	getRowSumsRight()
boolean	getScenarioProtect()
org.apache.poi.ss.usermodel.SheetConditionalFormatting	getSheetConditionalFormatting()
String	getSheetName()
short	getTopRow()
boolean	getVerticallyCenter()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
void	groupColumn(int arg0, int arg1)
void	groupRow(int arg0, int arg1)
boolean	isColumnBroken(int arg0)
boolean	isColumnHidden(int arg0)
boolean	isDisplayFormulas()
boolean	isDisplayGridlines()
boolean	isDisplayRowColHeadings()
boolean	isDisplayZeros()
boolean	isPrintGridlines()
boolean	isRightToLeft()
boolean	isRowBroken(int arg0)
boolean	isSelected()
Iterator<org.apache.poi.ss.usermodel.Row>	iterator()
void	protectSheet(String arg0)
org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>	removeArrayFormula(org.apache.poi.ss.usermodel.Cell arg0)
void	removeColumnBreak(int arg0)
void	removeMergedRegion(int arg0)
void	removeRow(org.apache.poi.ss.usermodel.Row arg0)
void	removeRowBreak(int arg0)
Iterator<org.apache.poi.ss.usermodel.Row>	rowIterator()
org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell>	setArrayFormula(String arg0, org.apache.poi.ss.util.CellRangeAddress arg1)
void	setAutobreaks(boolean arg0)
org.apache.poi.ss.usermodel.AutoFilter	setAutoFilter(org.apache.poi.ss.util.CellRangeAddress arg0)
void	setColumnBreak(int arg0)
void	setColumnGroupCollapsed(int arg0, boolean arg1)
void	setColumnHidden(int arg0, boolean arg1)
void	setColumnWidth(int arg0, int arg1)
void	setDefaultColumnStyle(int arg0, org.apache.poi.ss.usermodel.CellStyle arg1)
void	setDefaultColumnWidth(int arg0)
void	setDefaultRowHeight(short arg0)
void	setDefaultRowHeightInPoints(float arg0)
void	setDisplayFormulas(boolean arg0)
void	setDisplayGridlines(boolean arg0)
void	setDisplayGuts(boolean arg0)
void	setDisplayRowColHeadings(boolean arg0)
void	setDisplayZeros(boolean arg0)
void	setFitToPage(boolean arg0)
void	setForceFormulaRecalculation(boolean arg0)
void	setHorizontallyCenter(boolean arg0)
void	setMargin(short arg0, double arg1)
void	setPrintGridlines(boolean arg0)
void	setRightToLeft(boolean arg0)
void	setRowBreak(int arg0)
void	setRowGroupCollapsed(int arg0, boolean arg1)
void	setRowSumsBelow(boolean arg0)
void	setRowSumsRight(boolean arg0)
void	setSelected(boolean arg0)
void	setVerticallyCenter(boolean arg0)
void	setZoom(int arg0, int arg1)
void	shiftRows(int arg0, int arg1, int arg2)
void	shiftRows(int arg0, int arg1, int arg2, boolean arg3, boolean arg4)
void	showInPane(short arg0, short arg1)
void	ungroupColumn(int arg0, int arg1)
void	ungroupRow(int arg0, int arg1)

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

CSVSheet

public CSVSheet(CSVWorkbook workbook,
                String SheetName)

Simple constructor. The data is simply stored in a vector.

Parameters:

workbook - - the enclosing workbook.

SheetName - The name of the Sheet

Method Detail

iterator

public Iterator<org.apache.poi.ss.usermodel.Row> iterator()

Specified by:

iterator in interface Iterable<org.apache.poi.ss.usermodel.Row>

getRowNumber

public int getRowNumber(org.apache.poi.ss.usermodel.Row row)

get the row position of a row.

Parameters:

row - The row to get the row number for

Returns:

the position of the provided row

addMergedRegion

public int addMergedRegion(org.apache.poi.ss.util.CellRangeAddress arg0)

Specified by:

addMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

addValidationData

public void addValidationData(org.apache.poi.ss.usermodel.DataValidation arg0)

Specified by:

addValidationData in interface org.apache.poi.ss.usermodel.Sheet

autoSizeColumn

public void autoSizeColumn(int arg0)

Specified by:

autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet

autoSizeColumn

public void autoSizeColumn(int arg0,
                           boolean arg1)

Specified by:

autoSizeColumn in interface org.apache.poi.ss.usermodel.Sheet

createDrawingPatriarch

public org.apache.poi.ss.usermodel.Drawing createDrawingPatriarch()

Specified by:

createDrawingPatriarch in interface org.apache.poi.ss.usermodel.Sheet

createFreezePane

public void createFreezePane(int arg0,
                             int arg1)

Specified by:

createFreezePane in interface org.apache.poi.ss.usermodel.Sheet

createFreezePane

public void createFreezePane(int arg0,
                             int arg1,
                             int arg2,
                             int arg3)

Specified by:

createFreezePane in interface org.apache.poi.ss.usermodel.Sheet

createRow

public org.apache.poi.ss.usermodel.Row createRow(int arg0)

Specified by:

createRow in interface org.apache.poi.ss.usermodel.Sheet

createSplitPane

public void createSplitPane(int arg0,
                            int arg1,
                            int arg2,
                            int arg3,
                            int arg4)

Specified by:

createSplitPane in interface org.apache.poi.ss.usermodel.Sheet

getAutobreaks

public boolean getAutobreaks()

Specified by:

getAutobreaks in interface org.apache.poi.ss.usermodel.Sheet

getCellComment

public org.apache.poi.ss.usermodel.Comment getCellComment(int arg0,
                                                          int arg1)

Specified by:

getCellComment in interface org.apache.poi.ss.usermodel.Sheet

getColumnBreaks

public int[] getColumnBreaks()

Specified by:

getColumnBreaks in interface org.apache.poi.ss.usermodel.Sheet

getColumnStyle

public org.apache.poi.ss.usermodel.CellStyle getColumnStyle(int arg0)

Specified by:

getColumnStyle in interface org.apache.poi.ss.usermodel.Sheet

getColumnWidth

public int getColumnWidth(int arg0)

Specified by:

getColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getDataValidationHelper

public org.apache.poi.ss.usermodel.DataValidationHelper getDataValidationHelper()

Specified by:

getDataValidationHelper in interface org.apache.poi.ss.usermodel.Sheet

getDefaultColumnWidth

public int getDefaultColumnWidth()

Specified by:

getDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

getDefaultRowHeight

public short getDefaultRowHeight()

Specified by:

getDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet

getDefaultRowHeightInPoints

public float getDefaultRowHeightInPoints()

Specified by:

getDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet

getDisplayGuts

public boolean getDisplayGuts()

Specified by:

getDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet

getFirstRowNum

public int getFirstRowNum()

Specified by:

getFirstRowNum in interface org.apache.poi.ss.usermodel.Sheet

getFitToPage

public boolean getFitToPage()

Specified by:

getFitToPage in interface org.apache.poi.ss.usermodel.Sheet

getFooter

public org.apache.poi.ss.usermodel.Footer getFooter()

Specified by:

getFooter in interface org.apache.poi.ss.usermodel.Sheet

getForceFormulaRecalculation

public boolean getForceFormulaRecalculation()

Specified by:

getForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet

getHeader

public org.apache.poi.ss.usermodel.Header getHeader()

Specified by:

getHeader in interface org.apache.poi.ss.usermodel.Sheet

getHorizontallyCenter

public boolean getHorizontallyCenter()

Specified by:

getHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet

getLastRowNum

public int getLastRowNum()

Specified by:

getLastRowNum in interface org.apache.poi.ss.usermodel.Sheet

getLeftCol

public short getLeftCol()

Specified by:

getLeftCol in interface org.apache.poi.ss.usermodel.Sheet

getMargin

public double getMargin(short arg0)

Specified by:

getMargin in interface org.apache.poi.ss.usermodel.Sheet

getMergedRegion

public org.apache.poi.ss.util.CellRangeAddress getMergedRegion(int arg0)

Specified by:

getMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

getNumMergedRegions

public int getNumMergedRegions()

Specified by:

getNumMergedRegions in interface org.apache.poi.ss.usermodel.Sheet

getPaneInformation

public org.apache.poi.hssf.util.PaneInformation getPaneInformation()

Specified by:

getPaneInformation in interface org.apache.poi.ss.usermodel.Sheet

getPhysicalNumberOfRows

public int getPhysicalNumberOfRows()

Specified by:

getPhysicalNumberOfRows in interface org.apache.poi.ss.usermodel.Sheet

getPrintSetup

public org.apache.poi.ss.usermodel.PrintSetup getPrintSetup()

Specified by:

getPrintSetup in interface org.apache.poi.ss.usermodel.Sheet

getProtect

public boolean getProtect()

Specified by:

getProtect in interface org.apache.poi.ss.usermodel.Sheet

getRow

public org.apache.poi.ss.usermodel.Row getRow(int arg0)

Specified by:

getRow in interface org.apache.poi.ss.usermodel.Sheet

getRowBreaks

public int[] getRowBreaks()

Specified by:

getRowBreaks in interface org.apache.poi.ss.usermodel.Sheet

getRowSumsBelow

public boolean getRowSumsBelow()

Specified by:

getRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet

getRowSumsRight

public boolean getRowSumsRight()

Specified by:

getRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet

getScenarioProtect

public boolean getScenarioProtect()

Specified by:

getScenarioProtect in interface org.apache.poi.ss.usermodel.Sheet

getSheetConditionalFormatting

public org.apache.poi.ss.usermodel.SheetConditionalFormatting getSheetConditionalFormatting()

Specified by:

getSheetConditionalFormatting in interface org.apache.poi.ss.usermodel.Sheet

getSheetName

public String getSheetName()

Specified by:

getSheetName in interface org.apache.poi.ss.usermodel.Sheet

getTopRow

public short getTopRow()

Specified by:

getTopRow in interface org.apache.poi.ss.usermodel.Sheet

getVerticallyCenter

public boolean getVerticallyCenter()

Specified by:

getVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet

getWorkbook

public org.apache.poi.ss.usermodel.Workbook getWorkbook()

Specified by:

getWorkbook in interface org.apache.poi.ss.usermodel.Sheet

groupColumn

public void groupColumn(int arg0,
                        int arg1)

Specified by:

groupColumn in interface org.apache.poi.ss.usermodel.Sheet

groupRow

public void groupRow(int arg0,
                     int arg1)

Specified by:

groupRow in interface org.apache.poi.ss.usermodel.Sheet

isColumnBroken

public boolean isColumnBroken(int arg0)

Specified by:

isColumnBroken in interface org.apache.poi.ss.usermodel.Sheet

isColumnHidden

public boolean isColumnHidden(int arg0)

Specified by:

isColumnHidden in interface org.apache.poi.ss.usermodel.Sheet

isDisplayFormulas

public boolean isDisplayFormulas()

Specified by:

isDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet

isDisplayGridlines

public boolean isDisplayGridlines()

Specified by:

isDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet

isDisplayRowColHeadings

public boolean isDisplayRowColHeadings()

Specified by:

isDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet

isDisplayZeros

public boolean isDisplayZeros()

Specified by:

isDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet

isPrintGridlines

public boolean isPrintGridlines()

Specified by:

isPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet

isRightToLeft

public boolean isRightToLeft()

Specified by:

isRightToLeft in interface org.apache.poi.ss.usermodel.Sheet

isRowBroken

public boolean isRowBroken(int arg0)

Specified by:

isRowBroken in interface org.apache.poi.ss.usermodel.Sheet

isSelected

public boolean isSelected()

Specified by:

isSelected in interface org.apache.poi.ss.usermodel.Sheet

protectSheet

public void protectSheet(String arg0)

Specified by:

protectSheet in interface org.apache.poi.ss.usermodel.Sheet

removeArrayFormula

public org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell> removeArrayFormula(org.apache.poi.ss.usermodel.Cell arg0)

Specified by:

removeArrayFormula in interface org.apache.poi.ss.usermodel.Sheet

removeColumnBreak

public void removeColumnBreak(int arg0)

Specified by:

removeColumnBreak in interface org.apache.poi.ss.usermodel.Sheet

removeMergedRegion

public void removeMergedRegion(int arg0)

Specified by:

removeMergedRegion in interface org.apache.poi.ss.usermodel.Sheet

removeRow

public void removeRow(org.apache.poi.ss.usermodel.Row arg0)

Specified by:

removeRow in interface org.apache.poi.ss.usermodel.Sheet

removeRowBreak

public void removeRowBreak(int arg0)

Specified by:

removeRowBreak in interface org.apache.poi.ss.usermodel.Sheet

rowIterator

public Iterator<org.apache.poi.ss.usermodel.Row> rowIterator()

Specified by:

rowIterator in interface org.apache.poi.ss.usermodel.Sheet

setArrayFormula

public org.apache.poi.ss.usermodel.CellRange<? extends org.apache.poi.ss.usermodel.Cell> setArrayFormula(String arg0,
                                                                                                         org.apache.poi.ss.util.CellRangeAddress arg1)

Specified by:

setArrayFormula in interface org.apache.poi.ss.usermodel.Sheet

setAutoFilter

public org.apache.poi.ss.usermodel.AutoFilter setAutoFilter(org.apache.poi.ss.util.CellRangeAddress arg0)

Specified by:

setAutoFilter in interface org.apache.poi.ss.usermodel.Sheet

setAutobreaks

public void setAutobreaks(boolean arg0)

Specified by:

setAutobreaks in interface org.apache.poi.ss.usermodel.Sheet

setColumnBreak

public void setColumnBreak(int arg0)

Specified by:

setColumnBreak in interface org.apache.poi.ss.usermodel.Sheet

setColumnGroupCollapsed

public void setColumnGroupCollapsed(int arg0,
                                    boolean arg1)

Specified by:

setColumnGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet

setColumnHidden

public void setColumnHidden(int arg0,
                            boolean arg1)

Specified by:

setColumnHidden in interface org.apache.poi.ss.usermodel.Sheet

setColumnWidth

public void setColumnWidth(int arg0,
                           int arg1)

Specified by:

setColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

setDefaultColumnStyle

public void setDefaultColumnStyle(int arg0,
                                  org.apache.poi.ss.usermodel.CellStyle arg1)

Specified by:

setDefaultColumnStyle in interface org.apache.poi.ss.usermodel.Sheet

setDefaultColumnWidth

public void setDefaultColumnWidth(int arg0)

Specified by:

setDefaultColumnWidth in interface org.apache.poi.ss.usermodel.Sheet

setDefaultRowHeight

public void setDefaultRowHeight(short arg0)

Specified by:

setDefaultRowHeight in interface org.apache.poi.ss.usermodel.Sheet

setDefaultRowHeightInPoints

public void setDefaultRowHeightInPoints(float arg0)

Specified by:

setDefaultRowHeightInPoints in interface org.apache.poi.ss.usermodel.Sheet

setDisplayFormulas

public void setDisplayFormulas(boolean arg0)

Specified by:

setDisplayFormulas in interface org.apache.poi.ss.usermodel.Sheet

setDisplayGridlines

public void setDisplayGridlines(boolean arg0)

Specified by:

setDisplayGridlines in interface org.apache.poi.ss.usermodel.Sheet

setDisplayGuts

public void setDisplayGuts(boolean arg0)

Specified by:

setDisplayGuts in interface org.apache.poi.ss.usermodel.Sheet

setDisplayRowColHeadings

public void setDisplayRowColHeadings(boolean arg0)

Specified by:

setDisplayRowColHeadings in interface org.apache.poi.ss.usermodel.Sheet

setDisplayZeros

public void setDisplayZeros(boolean arg0)

Specified by:

setDisplayZeros in interface org.apache.poi.ss.usermodel.Sheet

setFitToPage

public void setFitToPage(boolean arg0)

Specified by:

setFitToPage in interface org.apache.poi.ss.usermodel.Sheet

setForceFormulaRecalculation

public void setForceFormulaRecalculation(boolean arg0)

Specified by:

setForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Sheet

setHorizontallyCenter

public void setHorizontallyCenter(boolean arg0)

Specified by:

setHorizontallyCenter in interface org.apache.poi.ss.usermodel.Sheet

setMargin

public void setMargin(short arg0,
                      double arg1)

Specified by:

setMargin in interface org.apache.poi.ss.usermodel.Sheet

setPrintGridlines

public void setPrintGridlines(boolean arg0)

Specified by:

setPrintGridlines in interface org.apache.poi.ss.usermodel.Sheet

setRightToLeft

public void setRightToLeft(boolean arg0)

Specified by:

setRightToLeft in interface org.apache.poi.ss.usermodel.Sheet

setRowBreak

public void setRowBreak(int arg0)

Specified by:

setRowBreak in interface org.apache.poi.ss.usermodel.Sheet

setRowGroupCollapsed

public void setRowGroupCollapsed(int arg0,
                                 boolean arg1)

Specified by:

setRowGroupCollapsed in interface org.apache.poi.ss.usermodel.Sheet

setRowSumsBelow

public void setRowSumsBelow(boolean arg0)

Specified by:

setRowSumsBelow in interface org.apache.poi.ss.usermodel.Sheet

setRowSumsRight

public void setRowSumsRight(boolean arg0)

Specified by:

setRowSumsRight in interface org.apache.poi.ss.usermodel.Sheet

setSelected

public void setSelected(boolean arg0)

Specified by:

setSelected in interface org.apache.poi.ss.usermodel.Sheet

setVerticallyCenter

public void setVerticallyCenter(boolean arg0)

Specified by:

setVerticallyCenter in interface org.apache.poi.ss.usermodel.Sheet

setZoom

public void setZoom(int arg0,
                    int arg1)

Specified by:

setZoom in interface org.apache.poi.ss.usermodel.Sheet

shiftRows

public void shiftRows(int arg0,
                      int arg1,
                      int arg2)

Specified by:

shiftRows in interface org.apache.poi.ss.usermodel.Sheet

shiftRows

public void shiftRows(int arg0,
                      int arg1,
                      int arg2,
                      boolean arg3,
                      boolean arg4)

Specified by:

shiftRows in interface org.apache.poi.ss.usermodel.Sheet

ungroupColumn

public void ungroupColumn(int arg0,
                          int arg1)

Specified by:

ungroupColumn in interface org.apache.poi.ss.usermodel.Sheet

ungroupRow

public void ungroupRow(int arg0,
                       int arg1)

Specified by:

ungroupRow in interface org.apache.poi.ss.usermodel.Sheet

showInPane

public void showInPane(short arg0,
                       short arg1)

Specified by:

showInPane in interface org.apache.poi.ss.usermodel.Sheet