Namespace EasyXLS

Class ExcelTable

System.Object

EasyXLS.ExcelTable

public class ExcelTable
extends System.Object

This class simulates a worksheet table. It is assigned to an ExcelWorksheet class. It allows to access the spreadsheet cells, to add rows and columns, to set default row height and column width, to add horizontal and vertical page breaks for page break preview.

Constructor Summary

Constructors

Constructor	Description
ExcelTable()	Defines an instance of the worksheet table.

Method Summary

Modifier and Type	Method	Description
ExcelTable	Clone()	Creates and returns a copy of this object.
int	ColumnCount()	Returns the number of columns from the table.
void	Dispose()	Disposes any resources that it has allocated.
void	easy_addColumn()	Adds a column to table.
void	easy_addColumn(ExcelColumn columnData)	Adds the specified column to table. This method is overridden as easy_addColumn_2 in COM+ version of EasyXLS.
void	easy_addRow()	Adds a row to table.
void	easy_addRow(ExcelRow rowData)	Adds the specified row to table. This method is overridden as easy_addRow_2 in COM+ version of EasyXLS.
void	easy_freezePanes(int splitRow, int splitColumn)	Sets the freeze panes for the table.
void	easy_freezePanes(int splitRow, int splitColumn, int topVisibleRow_BottomPane, int leftVisibleColumn_RightPane)	Sets the freeze panes for the table. This method is overridden as easy_freezePanes_2 in COM+ version of EasyXLS.
ExcelCell	easy_getCell(int row, int column)	If a cell does not exist at the specified position, it creates one, and returns the cell.
ExcelCell	easy_getCell(System.String cellReference)	Returns the cell at the specified reference. This method is overridden as easy_getCell_2 in COM+ version of EasyXLS.
ExcelCell	easy_getCellAt(int row, int column)	Returns the cell at the specified row and column.
int	easy_getCellMergingFirstCol(int nIndex)	Returns the first column of the specified cell merging range.
int	easy_getCellMergingFirstRow(int nIndex)	Returns the first row of the specified cell merging range.
int	easy_getCellMergingLastCol(int nIndex)	Returns the last column of the specified cell merging range.
int	easy_getCellMergingLastRow(int nIndex)	Returns the last row of the specified cell merging range.
ExcelColumn	easy_getColumnAt(int column)	Returns the column at the specified position.
System.String	easy_getMergingRangeAsA1Reference(int nIndex)	Internal use only Returns the cell merging range at the specified range as A1 reference (e.g.
ExcelRow	easy_getRowAt(int row)	Returns the row at specified position.
void	easy_insertColumn(int column, ExcelColumn columnData)	Inserts the specified column to table into the specified position.
void	easy_insertPageBreakAtColumn(int column)	Inserts a page break after the specified column.
void	easy_insertPageBreakAtRow(int row)	Inserts a page break after the specified row.
void	easy_insertRow(int row, ExcelRow rowData)	Inserts the specified row to table into the specified position.
void	easy_mergeCells(int startRow, int startColumn, int endRow, int endColumn)	Merging the cells inside the specified range.
void	easy_mergeCells(System.String range)	Merging the cells inside the specified range. This method is overridden as easy_mergeCells_2 in COM+ version of EasyXLS.
void	easy_mergeCells(System.String startCellReference, System.String endCellReference)	Merging the cells inside the range limited by the specified cell references. This method is overridden as easy_mergeCells_3 in COM+ version of EasyXLS.
void	easy_removeCellMerging(int nIndex)	Removes the cell merging area at the specified index from the table
void	easy_removeColumn(int column)	Removes the column at the specified index from the table
void	easy_removeColumnRange(int startColumn, int count)	Removes a range of columns from the table
void	easy_removeRow(int row)	Removes the row at the specified index from the table
void	easy_removeRowRange(int startRow, int count)	Removes a range of rows from the table
void	easy_removeSplit()	Removes the split option for the table.
void	easy_resetAllPageBreaks()	Resets all the defined page breaks.
void	easy_setCellAt(ExcelCell cell, int row, int column)	Sets the cell at the specified position.
void	easy_setRangeAutoFormat(int startRow, int startColumn, int endRow, int endColumn, ExcelAutoFormat xlsAutoFormat)	Sets the specified autoformat for the range.
void	easy_setRangeAutoFormat(System.String range, ExcelAutoFormat xlsAutoFormat)	Sets the specified autoformat for the range. This method is overridden as easy_setRangeAutoFormat_2 in COM+ version of EasyXLS.
void	easy_setRangeAutoFormat(System.String startCellReference, System.String endCellReference, ExcelAutoFormat xlsAutoFormat)	Sets the specified autoformat for the range limited by the specified cell references. This method is overridden as easy_setRangeAutoFormat_3 in COM+ version of EasyXLS.
void	easy_setRangeOutlineBorder(int startRow, int startColumn, int endRow, int endColumn, int borderStyle, System.Drawing.Color borderColor)	Sets an outline border for the specified cell range.
void	easy_setRangeOutlineBorder(System.String range, int borderStyle, System.Drawing.Color borderColor)	Sets an outline border for the specified cell range. This method is overridden as easy_setRangeOutlineBorder_2 in COM+ version of EasyXLS.
void	easy_setRangeOutlineBorder(System.String startCellReference, System.String endCellReference, int borderStyle, System.Drawing.Color borderColor)	Sets an outline border for the specified cell range. This method is overridden as easy_setRangeOutlineBorder_3 in COM+ version of EasyXLS.
void	easy_setRangeStyle(int startRow, int startColumn, int endRow, int endColumn, ExcelStyle style)	Sets the specified style for the range limited by the rows and columns.
void	easy_setRangeStyle(System.String range, ExcelStyle style)	Sets the specified style for the range. This method is overridden as easy_setRangeStyle_2 in COM+ version of EasyXLS.
void	easy_setRangeStyle(System.String startCellReference, System.String endCellReference, ExcelStyle style)	Sets the specified style for the range limited by the specified cell references. This method is overridden as easy_setRangeStyle_3 in COM+ version of EasyXLS.
void	easy_split(int splitRow, int splitColumn)	Sets the split option for the table.
void	easy_split(int splitRow, int splitColumn, int topVisibleRow_BottomPane, int leftVisibleColumn_RightPane)	Sets the split option for the table. This method is overridden as easy_split_2 in COM+ version of EasyXLS.
void	easy_unfreezePanes()	Unfreezes panes for the table.
List	findAll(System.String value, int lookIn, bool matchCase, bool matchEntireCellContents)	Searches all the occurrences of the cell that matches the criteria.
Cell	findFirst(System.String value, int lookIn, bool matchCase, bool matchEntireCellContents)	Searches the first cell that matches the criteria.
int	getColumnWidth()	Returns the default width of the columns.
int	getColumnWidth(int column)	Returns the width of the specified column. This method is overridden as getColumnWidth_2 in COM+ version of EasyXLS.
List	getHorizontalPageBreaks()	Returns a list with all horizontal page breaks
int	getRowHeight()	Returns the default height of the rows.
int	getRowHeight(int row)	Returns the height of the specified row. This method is overridden as getRowHeight_2 in COM+ version of EasyXLS.
List	getVerticalPageBreaks()	Returns a list with all vertical page breaks
bool	IsFreezePaneSet()	Returns true if the row/columns are frozen, false otherwise.
bool	IsRowHeightSet()	Returns true if the default row height was set, false otherwise.
bool	IsSplitSet()	Returns true if the row/columns are split, false otherwise.
int	MergeCellRangesCount()	Returns the count of the cell merging ranges.
int	RowCount()	Returns the number of rows from the table.
void	setColumnCount(int count)	Sets the number of columns for the table.
void	setColumnWidth(int width)	Sets the default width of the columns.
void	setColumnWidth(int column, int columnWidth)	Sets the width for the specified column. This method is overridden as setColumnWidth_2 in COM+ version of EasyXLS.
void	setFreezePaneSet(bool isFreezePaneSet)	Internal use only
void	setRowCount(int count)	Sets the number of rows for the table.
void	setRowHeight(int height)	Sets the default height of the rows.
void	setRowHeight(int row, int rowHeight)	Sets the height for the specified row. This method is overridden as setRowHeight_2 in COM+ version of EasyXLS.
void	setRowHeightSet(bool isRowHeightSet)	Internal use only
void	setSplitSet(bool isSplitSet)	Internal use only
void	validate()	Finalize the changes applied on the rows, columns and cells.

Methods inherited from class System.Object

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

Constructor Details

ExcelTable

public ExcelTable()

Defines an instance of the worksheet table.

Method Details

validate

public void validate()

Finalize the changes applied on the rows, columns and cells.

RowCount

public int RowCount()

Returns the number of rows from the table.

Returns:

the number of rows from the table

See Also:

• setRowCount(int)

setRowCount

public void setRowCount(int count)

Sets the number of rows for the table.

Parameters:

count - the number of rows from the table

See Also:

• RowCount()

easy_addRow

public void easy_addRow()

Adds a row to table.

See Also:

• easy_insertRow(int, EasyXLS.ExcelRow)
• easy_removeRow(int)

easy_addRow

public void easy_addRow(ExcelRow rowData)

Adds the specified row to table.
This method is overridden as easy_addRow_2 in COM+ version of EasyXLS.

Parameters:

rowData - the row to be added

See Also:

• easy_insertRow(int, EasyXLS.ExcelRow)
• easy_removeRow(int)

easy_insertRow

public void easy_insertRow(int row,
 ExcelRow rowData)

Inserts the specified row to table into the specified position.

Parameters:

row - the position where the row will be inserted

rowData - the row to be inserted

See Also:

• easy_addRow()
• easy_removeRow(int)

easy_removeRow

public void easy_removeRow(int row)

Removes the row at the specified index from the table

Parameters:

row - the row index

See Also:

• easy_addRow()
• easy_insertRow(int, EasyXLS.ExcelRow)
• easy_removeRowRange(int, int)

easy_removeRowRange

public void easy_removeRowRange(int startRow,
 int count)

Removes a range of rows from the table

Parameters:

startRow - the starting index of the rows

count - the number of rows to be removed

See Also:

• easy_addRow()
• easy_insertRow(int, EasyXLS.ExcelRow)
• easy_removeRow(int)

getRowHeight

public int getRowHeight()

Returns the default height of the rows.

Returns:

the default height of the rows

See Also:

• setRowHeight(int)
• getRowHeight(int)
• setRowHeight(int,int)

setRowHeight

public void setRowHeight(int height)

Sets the default height of the rows.

Parameters:

height - the default height of the rows

See Also:

• getRowHeight()
• getRowHeight(int)
• setRowHeight(int,int)

IsRowHeightSet

public bool IsRowHeightSet()

Returns true if the default row height was set, false otherwise.

Returns:

true if the default row height was set, false otherwise

See Also:

• setRowHeight(int)

setRowHeightSet

public void setRowHeightSet(bool isRowHeightSet)

Internal use only

Parameters:

isRowHeightSet - true if the default row height is set, false otherwise

getRowHeight

public int getRowHeight(int row)

Returns the height of the specified row.
This method is overridden as getRowHeight_2 in COM+ version of EasyXLS.

Parameters:

row - the index of the row for which to return the height

Returns:

the height of the specified row

See Also:

• getRowHeight()
• setRowHeight(int)
• setRowHeight(int,int)

setRowHeight

public void setRowHeight(int row,
 int rowHeight)

Sets the height for the specified row.
This method is overridden as setRowHeight_2 in COM+ version of EasyXLS.

Parameters:

row - the index of the row

rowHeight - the new value of the height

See Also:

• getRowHeight()
• setRowHeight(int)
• getRowHeight(int)

easy_getRowAt

public ExcelRow easy_getRowAt(int row)

Returns the row at specified position.

Parameters:

row - the row position

Returns:

the row at specified position

ColumnCount

public int ColumnCount()

Returns the number of columns from the table.

Returns:

the number of columns from the table

See Also:

• setColumnCount(int)

setColumnCount

public void setColumnCount(int count)

Sets the number of columns for the table.

Parameters:

count - the number of columns for the table

See Also:

• ColumnCount()

easy_addColumn

public void easy_addColumn()

Adds a column to table.

See Also:

• easy_insertColumn(int, EasyXLS.ExcelColumn)
• easy_removeColumn(int)

easy_addColumn

public void easy_addColumn(ExcelColumn columnData)

Adds the specified column to table.
This method is overridden as easy_addColumn_2 in COM+ version of EasyXLS.

Parameters:

columnData - the column to be added

See Also:

• easy_insertColumn(int, EasyXLS.ExcelColumn)
• easy_removeColumn(int)

easy_insertColumn

public void easy_insertColumn(int column,
 ExcelColumn columnData)

Inserts the specified column to table into the specified position.

Parameters:

column - the position where the column will be inserted

columnData - the column to be inserted

See Also:

• easy_addColumn()
• easy_removeColumn(int)

easy_removeColumn

public void easy_removeColumn(int column)

Removes the column at the specified index from the table

Parameters:

column - the column index

See Also:

• easy_addColumn()
• easy_insertColumn(int, EasyXLS.ExcelColumn)
• easy_removeColumnRange(int, int)

easy_removeColumnRange

public void easy_removeColumnRange(int startColumn,
 int count)

Removes a range of columns from the table

Parameters:

startColumn - the starting index of the columns

count - the number of columns to be removed

See Also:

• easy_addColumn()
• easy_insertColumn(int, EasyXLS.ExcelColumn)
• easy_removeColumn(int)

getColumnWidth

public int getColumnWidth()

Returns the default width of the columns.

Returns:

the default width of the columns

See Also:

• setColumnWidth(int)
• getColumnWidth(int)
• setColumnWidth(int,int)

setColumnWidth

public void setColumnWidth(int width)

Sets the default width of the columns.

Parameters:

width - the new default width of the columns

See Also:

• getColumnWidth()
• getColumnWidth(int)
• setColumnWidth(int,int)

getColumnWidth

public int getColumnWidth(int column)

Returns the width of the specified column.
This method is overridden as getColumnWidth_2 in COM+ version of EasyXLS.

Parameters:

column - the column index for which to return the width

Returns:

the width of the specified column

See Also:

• getColumnWidth()
• setColumnWidth(int)
• setColumnWidth(int,int)

setColumnWidth

public void setColumnWidth(int column,
 int columnWidth)

Sets the width for the specified column.
This method is overridden as setColumnWidth_2 in COM+ version of EasyXLS.

Parameters:

column - the column position

columnWidth - the new width of the column

See Also:

• getColumnWidth()
• setColumnWidth(int)
• getColumnWidth(int)

easy_getColumnAt

public ExcelColumn easy_getColumnAt(int column)

Returns the column at the specified position.

Parameters:

column - the column position

Returns:

the column at specified position

easy_getCellAt

public ExcelCell easy_getCellAt(int row,
 int column)

Returns the cell at the specified row and column. If the cell does not exist an 'array index out of range exception' will be thrown.

Parameters:

row - the row that specifies the cell position

column - the column that specifies the cell position

Returns:

the cell at specified position

See Also:

• easy_getCell(int, int)
• easy_setCellAt(EasyXLS.ExcelCell, int, int)

easy_getCell

public ExcelCell easy_getCell(int row,
 int column)

If a cell does not exist at the specified position, it creates one, and returns the cell. Note: Slower than easy_getCellAt method.

Parameters:

row - the row that specifies the cell position

column - the column that specifies the cell position

Returns:

the cell at specified position

See Also:

• easy_getCellAt(int, int)
• easy_setCellAt(EasyXLS.ExcelCell, int, int)

easy_getCell

public ExcelCell easy_getCell(System.String cellReference)

Returns the cell at the specified reference.
This method is overridden as easy_getCell_2 in COM+ version of EasyXLS.

Parameters:

cellReference - the cell reference that specifies the cell position

Returns:

the cell at specified position

See Also:

• easy_getCell(int, int)
• easy_setCellAt(EasyXLS.ExcelCell, int, int)

easy_setCellAt

public void easy_setCellAt(ExcelCell cell,
 int row,
 int column)

Sets the cell at the specified position.

Parameters:

cell - the cell to be set

row - the row position

column - the column position

See Also:

• easy_getCellAt(int, int)
• easy_getCell(int, int)

easy_setRangeAutoFormat

public void easy_setRangeAutoFormat(int startRow,
 int startColumn,
 int endRow,
 int endColumn,
 ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range.

Parameters:

startRow - the row that limits the left upper corner of the cell range

startColumn - the column that limits the left upper corner of the cell range

endRow - the row that limits the right down corner of the cell range

endColumn - the column that limits the right down corner of the cell range

xlsAutoFormat - the autoformat to be applied

easy_setRangeAutoFormat

public void easy_setRangeAutoFormat(System.String range,
 ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range.
This method is overridden as easy_setRangeAutoFormat_2 in COM+ version of EasyXLS.

Parameters:

range - the range where the autoformat will be applied. It can be a cell reference or a range.

xlsAutoFormat - the autoformat to be applied

easy_setRangeAutoFormat

public void easy_setRangeAutoFormat(System.String startCellReference,
 System.String endCellReference,
 ExcelAutoFormat xlsAutoFormat)

Sets the specified autoformat for the range limited by the specified cell references.
This method is overridden as easy_setRangeAutoFormat_3 in COM+ version of EasyXLS.

Parameters:

startCellReference - the cell reference that limits the left upper corner of the cell range

endCellReference - the cell reference that limits the right down corner of the cell range

xlsAutoFormat - the autoformat to be applied

easy_setRangeStyle

public void easy_setRangeStyle(int startRow,
 int startColumn,
 int endRow,
 int endColumn,
 ExcelStyle style)

Sets the specified style for the range limited by the rows and columns.

Parameters:

startRow - the row that limits the left upper corner of the cell range

startColumn - the column that limits the left upper corner of the cell range

endRow - the row that limits the right down corner of the cell range

endColumn - the column that limits the right down corner of the cell range

style - the style for the cells

easy_setRangeStyle

public void easy_setRangeStyle(System.String range,
 ExcelStyle style)

Sets the specified style for the range.
This method is overridden as easy_setRangeStyle_2 in COM+ version of EasyXLS.

Parameters:

range - the range where the style will be applied. It can be a cell reference or a range.

style - the style for the cells

easy_setRangeStyle

public void easy_setRangeStyle(System.String startCellReference,
 System.String endCellReference,
 ExcelStyle style)

Sets the specified style for the range limited by the specified cell references.
This method is overridden as easy_setRangeStyle_3 in COM+ version of EasyXLS.

Parameters:

startCellReference - the cell reference that limits the left upper corner of the cell range

endCellReference - the cell reference that limits the right down corner of the cell range

style - the style for the cells

easy_setRangeOutlineBorder

public void easy_setRangeOutlineBorder(int startRow,
 int startColumn,
 int endRow,
 int endColumn,
 int borderStyle,
 System.Drawing.Color borderColor)

Sets an outline border for the specified cell range.

Parameters:

startRow - the row that limits the left upper corner of the cell range

startColumn - the column that limits the left upper corner of the cell range

endRow - the row that limits the right down corner of the cell range

endColumn - the column that limits the right down corner of the cell range

borderStyle - the style of the border. Possible values are available in Border class

borderColor - the color of the border

easy_setRangeOutlineBorder

public void easy_setRangeOutlineBorder(System.String range,
 int borderStyle,
 System.Drawing.Color borderColor)

Sets an outline border for the specified cell range.
This method is overridden as easy_setRangeOutlineBorder_2 in COM+ version of EasyXLS.

Parameters:

range - the range where the border will be applied. It can be a cell reference or a range.

borderStyle - the style for the border. Possible values are available in Border class

borderColor - the color of the border

easy_setRangeOutlineBorder

public void easy_setRangeOutlineBorder(System.String startCellReference,
 System.String endCellReference,
 int borderStyle,
 System.Drawing.Color borderColor)

Sets an outline border for the specified cell range.
This method is overridden as easy_setRangeOutlineBorder_3 in COM+ version of EasyXLS.

Parameters:

startCellReference - the cell reference that limits the left upper corner of the cell range

endCellReference - the cell reference that limits the right down corner of the cell range

borderStyle - the style for the border. Possible values are available in Border class

borderColor - the color of the border

easy_mergeCells

public void easy_mergeCells(int startRow,
 int startColumn,
 int endRow,
 int endColumn)

Merging the cells inside the specified range.

Parameters:

startRow - the row that limits the left upper corner of the cell range

startColumn - the column that limits the left upper corner of the cell range

endRow - the row that limits the right down corner of the cell range

endColumn - the column that limits the right down corner of the cell range

easy_mergeCells

public void easy_mergeCells(System.String range)

Merging the cells inside the specified range.
This method is overridden as easy_mergeCells_2 in COM+ version of EasyXLS.

Parameters:

range - the cell range

See Also:

• easy_mergeCells(int,int,int,int)
• easy_mergeCells(String,String)

easy_mergeCells

public void easy_mergeCells(System.String startCellReference,
 System.String endCellReference)

Merging the cells inside the range limited by the specified cell references.
This method is overridden as easy_mergeCells_3 in COM+ version of EasyXLS.

Parameters:

startCellReference - the cell reference that limits the left upper corner of the cell range

endCellReference - the cell reference that limits the right down corner of the cell range

See Also:

• easy_mergeCells(int,int,int,int)
• easy_mergeCells(String)

easy_getMergingRangeAsA1Reference

public System.String easy_getMergingRangeAsA1Reference(int nIndex)

Internal use only Returns the cell merging range at the specified range as A1 reference (e.g. B2:G9).

Parameters:

nIndex - the merge cells range index

Returns:

cell merging range at the specified range as A1 reference (e.g. B2:G9)

easy_getCellMergingFirstRow

public int easy_getCellMergingFirstRow(int nIndex)

Returns the first row of the specified cell merging range.

Parameters:

nIndex - the merge cells range index

Returns:

the first row of the specified cell merging range

See Also:

• easy_getCellMergingLastRow(int)
• easy_getCellMergingFirstCol(int)
• easy_getCellMergingLastCol(int)

easy_getCellMergingLastRow

public int easy_getCellMergingLastRow(int nIndex)

Returns the last row of the specified cell merging range.

Parameters:

nIndex - the merge cells range index

Returns:

the last row of the specified cell merging range

See Also:

• easy_getCellMergingFirstRow(int)
• easy_getCellMergingFirstCol(int)
• easy_getCellMergingLastCol(int)

easy_getCellMergingFirstCol

public int easy_getCellMergingFirstCol(int nIndex)

Returns the first column of the specified cell merging range.

Parameters:

nIndex - the merge cells range index

Returns:

the first column of the specified cell merging range

See Also:

• easy_getCellMergingFirstRow(int)
• easy_getCellMergingLastRow(int)
• easy_getCellMergingLastCol(int)

easy_getCellMergingLastCol

public int easy_getCellMergingLastCol(int nIndex)

Returns the last column of the specified cell merging range.

Parameters:

nIndex - the merge cells range index

Returns:

the last column of the specified cell merging range

See Also:

• easy_getCellMergingFirstRow(int)
• easy_getCellMergingLastRow(int)
• easy_getCellMergingFirstCol(int)

MergeCellRangesCount

public int MergeCellRangesCount()

Returns the count of the cell merging ranges.

Returns:

the count of the cell merging ranges

easy_removeCellMerging

public void easy_removeCellMerging(int nIndex)

Removes the cell merging area at the specified index from the table

Parameters:

nIndex - the cell merging area index

easy_insertPageBreakAtRow

public void easy_insertPageBreakAtRow(int row)

Inserts a page break after the specified row.

Parameters:

row - the row after which the page break will be inserted

See Also:

• easy_insertPageBreakAtColumn(int)
• easy_resetAllPageBreaks()

easy_insertPageBreakAtColumn

public void easy_insertPageBreakAtColumn(int column)

Inserts a page break after the specified column.

Parameters:

column - the column after which the page break will be inserted

See Also:

• easy_insertPageBreakAtRow(int)
• easy_resetAllPageBreaks()

easy_resetAllPageBreaks

public void easy_resetAllPageBreaks()

Resets all the defined page breaks.

See Also:

• easy_insertPageBreakAtRow(int)
• easy_insertPageBreakAtColumn(int)

getHorizontalPageBreaks

public List getHorizontalPageBreaks()

Returns a list with all horizontal page breaks

Returns:

a list with all horizontal page breaks

See Also:

• getVerticalPageBreaks()

getVerticalPageBreaks

public List getVerticalPageBreaks()

Returns a list with all vertical page breaks

Returns:

a list with all vertical page breaks

See Also:

• getHorizontalPageBreaks()

easy_freezePanes

public void easy_freezePanes(int splitRow,
 int splitColumn)

Sets the freeze panes for the table.

Parameters:

splitRow - the row position of the split

splitColumn - the column position of the split

See Also:

• easy_freezePanes(int,int,int,int)
• easy_unfreezePanes()

easy_freezePanes

public void easy_freezePanes(int splitRow,
 int splitColumn,
 int topVisibleRow_BottomPane,
 int leftVisibleColumn_RightPane)

Sets the freeze panes for the table.
This method is overridden as easy_freezePanes_2 in COM+ version of EasyXLS.

Parameters:

splitRow - the row position of the split

splitColumn - the column position of the split

topVisibleRow_BottomPane - the top row visible in the bottom pane

leftVisibleColumn_RightPane - the left most column visible in the right pane

See Also:

• easy_freezePanes(int,int)
• easy_unfreezePanes()

easy_split

public void easy_split(int splitRow,
 int splitColumn)

Sets the split option for the table.

Parameters:

splitRow - the row position of the split

splitColumn - the column position of the split

See Also:

• easy_split(int,int,int,int)
• easy_removeSplit()

easy_split

public void easy_split(int splitRow,
 int splitColumn,
 int topVisibleRow_BottomPane,
 int leftVisibleColumn_RightPane)

Sets the split option for the table.
This method is overridden as easy_split_2 in COM+ version of EasyXLS.

Parameters:

splitRow - the row position of the split

splitColumn - the column position of the split

topVisibleRow_BottomPane - the top row visible in the bottom pane

leftVisibleColumn_RightPane - the left most visible column in the right pane

See Also:

• easy_split(int,int)
• easy_removeSplit()

easy_unfreezePanes

public void easy_unfreezePanes()

Unfreezes panes for the table.

See Also:

• easy_freezePanes(int,int)
• easy_freezePanes(int,int,int,int)

easy_removeSplit

public void easy_removeSplit()

Removes the split option for the table.

See Also:

• easy_split(int,int)
• easy_split(int,int,int,int)

IsFreezePaneSet

public bool IsFreezePaneSet()

Returns true if the row/columns are frozen, false otherwise.

Returns:

true if the row/columns are frozen, false otherwise.

See Also:

• easy_freezePanes(int,int)

setFreezePaneSet

public void setFreezePaneSet(bool isFreezePaneSet)

Internal use only

Parameters:

isFreezePaneSet - true if the freeze is active, false otherwise

IsSplitSet

public bool IsSplitSet()

Returns true if the row/columns are split, false otherwise.

Returns:

true if the row/columns are split, false otherwise.

See Also:

• easy_split(int,int,int,int)

setSplitSet

public void setSplitSet(bool isSplitSet)

Internal use only

Parameters:

isSplitSet - true if the split is active, false otherwise

findFirst

public Cell findFirst(System.String value,
 int lookIn,
 bool matchCase,
 bool matchEntireCellContents)

Searches the first cell that matches the criteria.

Parameters:

value - the string to be searched

lookIn - shows whether the search is in formulas, in values or in comments. Possible values are available in Table class.

matchCase - true if the search is case sensitive, false otherwise

matchEntireCellContents - true if the search matches the entire cell contents, false otherwise

Returns:

the first cell that matches the criteria

See Also:

• findAll(System.String, int, bool, bool)

findAll

public List findAll(System.String value,
 int lookIn,
 bool matchCase,
 bool matchEntireCellContents)

Searches all the occurrences of the cell that matches the criteria.

Parameters:

value - the string to be searched

lookIn - shows whether the search is in formulas, in values or in comments. Possible values are available in Table class.

matchCase - true if the search is case sensitive, false otherwise

matchEntireCellContents - true if the search matches the entire cell contents, false otherwise

Returns:

all the occurrences of the cell that matches the criteria

See Also:

• findFirst(System.String, int, bool, bool)

Dispose

public void Dispose()

Disposes any resources that it has allocated.

Clone

public ExcelTable Clone()

Creates and returns a copy of this object.

Returns:

a clone of this instance.