nl.fountain.xelem.excel
Interface Worksheet

All Superinterfaces:

XLElement

All Known Implementing Classes:

SSWorksheet

public interface Worksheet
extends XLElement

Represents the Worksheet element.

Field Summary

static int	firstColumn The left-most limit of the worksheets columns.
static int	firstRow The top row of the worksheet.
static int	lastColumn The right-most limit of the worksheets columns.
static int	lastRow The bottom row of the worksheet.

Fields inherited from interface nl.fountain.xelem.excel.XLElement

PREFIX_HTML, PREFIX_O, PREFIX_SS, PREFIX_X, XMLNS, XMLNS_HTML, XMLNS_O, XMLNS_SS, XMLNS_X

Method Summary

Cell	addCell() Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(Cell cell) Adds the given cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(double data) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(double data, String styleID) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(int data) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(int data, String styleID) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(Object data) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCell(Object data, String styleID) Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
Cell	addCellAt(Address address) Adds a new cell at the given address.
Cell	addCellAt(Address address, Cell cell) Adds the given cell at the given address.
Cell	addCellAt(int rowIndex, int columnIndex) Adds a new cell at the given row and column index.
Cell	addCellAt(int rowIndex, int columnIndex, Cell cell) Adds the given cell at the given row and column index.
Cell	addCellAt(String a1_ref) Adds a new cell at the address specified by the A1-reference string.
Cell	addCellAt(String a1_ref, Cell cell) Adds the given cell at the address specified by the A1-reference string.
Column	addColumn() Adds a new Column to this worksheet.
Column	addColumn(Column column) Adds the given column to this worksheet.
Column	addColumnAt(int index) Adds a new Column at the given index to this worksheet.
Column	addColumnAt(int index, Column column) Adds the given Column at the given index to this worksheet.
Column	addColumnAt(String label) Adds a new Column at the index specified by the given label.
Column	addColumnAt(String label, Column column) Adds the given Column at the given index specified by the given label.
NamedRange	addNamedRange(NamedRange namedRange) Adds a new NamedRange to this worksheet.
NamedRange	addNamedRange(String name, String refersTo) Adds a new NamedRange to this worksheet.
Row	addRow() Adds a new Row to this worksheet.
Row	addRow(Row row) Adds the given row to this worksheet.
Row	addRowAt(int index) Adds a new Row at the given index to this worksheet.
Row	addRowAt(int index, Row row) Adds the given Row at the given index to this worksheet.
Cell	getCellAt(Address address) Gets the cell at the given address.
Cell	getCellAt(int rowIndex, int columnIndex) Gets the cell at the given coordinates.
Cell	getCellAt(String a1_ref) Gets the cell at address specified by the given string in A1-reference style.
CellPointer	getCellPointer() Gets the cellpointer of this worksheet.
Column	getColumnAt(int columnIndex) Gets the column at the given index.
Column	getColumnAt(String label) Gets the column at the index specified by the given label.
Collection<Column>	getColumns() Gets all the columns of this worksheet in the order of their index.
String	getName() Returns the name of this worksheet.
Map<String,NamedRange>	getNamedRanges() Gets all the NamedRanges that were added to this worksheet.
String	getReferenceName() Returns the name of this worksheet for purposes of reference.
Row	getRowAt(int rowIndex) Gets the row at the given index.
Collection<Row>	getRows() Gets all the rows of this worksheet in the order of their index.
Table	getTable() Gets the table of this worksheet.
WorksheetOptions	getWorksheetOptions() Gets the WorksheetOptions of this worksheet.
boolean	hasAutoFilter() Specifies whether the setAutoFilter-method was applied on this worksheet.
boolean	hasCellAt(Address address) Specifies whether there is a cell at the given address.
boolean	hasCellAt(int rowIndex, int columnIndex) Specifies whether there is a cell at the intersection of the given row and column index.
boolean	hasCellAt(String a1_ref) Specifies whether there is a cell at the address specified by the given string in A1-reference style.
boolean	hasColumnAt(int columnIndex) Specifies whether there is a column at the given column index.
boolean	hasColumnAt(String label) Specifies whether there is a column at the index specified by the given label.
boolean	hasRowAt(int rowIndex) Specifies whether there is a row at the given row index.
boolean	hasTable() Indicates whether this worksheet has a table.
boolean	hasWorksheetOptions() Indicates whether WorksheetOptions was added to this worksheet.
boolean	isProtected() Specifies whether protection is applied to this worksheet.
boolean	isRightToLeft() Specifies whether this worksheet is displayed from right to left.
void	removeAutoFilter() Removes the Autofilter on this worksheet.
Cell	removeCellAt(Address address) Removes the cell at the given address.
Cell	removeCellAt(int rowIndex, int columnIndex) Removes the cell at the given coordinates.
Cell	removeCellAt(String a1_ref) Removes the cell at the address specified by the A1-reference string.
Column	removeColumnAt(int columnIndex) Removes the column at the given index.
Column	removeColumnAt(String label) Removes the column at the index specified by the given label.
Row	removeRowAt(int rowIndex) Removes the row at the given index.
void	setAutoFilter(AutoFilter af) Sets the AutoFilter on this worksheet.
void	setAutoFilter(String rcString) Sets the AutoFilter-option on the specified range.
void	setProtected(boolean p) Sets whether protection will be applied to this worksheet.
void	setRightToLeft(boolean r) Sets whether this worksheet will be displayed from right to left.
void	setTable(Table table) Sets the given table as the table of this worksheet.
void	setWorksheetOptions(WorksheetOptions wso) Sets the given worksheetOptions as the worksheetOptions of this worksheet.

Methods inherited from interface nl.fountain.xelem.excel.XLElement

addElementComment, assemble, getElementComments, getNameSpace, getPrefix, getTagName, setAttributes, setChildElement

Field Detail

firstColumn

static final int firstColumn

The left-most limit of the worksheets columns.

See Also:

Constant Field Values

firstRow

static final int firstRow

The top row of the worksheet.

See Also:

Constant Field Values

lastColumn

static final int lastColumn

The right-most limit of the worksheets columns.

See Also:

Constant Field Values

lastRow

static final int lastRow

The bottom row of the worksheet.

See Also:

Constant Field Values

Method Detail

getName

String getName()

Returns the name of this worksheet.

Returns:

the name of this worksheet

getReferenceName

String getReferenceName()

Returns the name of this worksheet for purposes of reference.

Returns:

the name of this worksheet or, if there are spaces in the name, the name of this worksheet between single quoutes ('...')

setProtected

void setProtected(boolean p)

Sets whether protection will be applied to this worksheet.

isProtected

boolean isProtected()

Specifies whether protection is applied to this worksheet.

Returns:

true if this worksheet is protected

setRightToLeft

void setRightToLeft(boolean r)

Sets whether this worksheet will be displayed from right to left.

isRightToLeft

boolean isRightToLeft()

Specifies whether this worksheet is displayed from right to left.

Returns:

true if this worksheet is displayed from right to left

addNamedRange

NamedRange addNamedRange(String name,
                         String refersTo)

Adds a new NamedRange to this worksheet. Named ranges are usefull when working with formulas. If this workbook allready contained a NamedRange with the same name, replaces that NamedRange.

If the workbook has a named range with the same name, the named range on the worksheet level has precedence over the one defined on the workbook level.

The string refersTo should be in R1C1-reference style i.e. in the format [worksheet name]!R1C1:R1C1. You may skip the worksheet indicator: R1C1:R1C1 will do as well.

Parameters:

name - The name to apply to the range.

refersTo - A String of R1C1-reference style.

Returns:

New NamedRange.

addNamedRange

NamedRange addNamedRange(NamedRange namedRange)

Adds a new NamedRange to this worksheet. If this workbook allready contained a NamedRange with the same name, replaces that NamedRange.

If the workbook has a named range with the same name, the named range on the worksheet level has precedence over the one defined on the workbook level.

Parameters:

namedRange - the NamedRange to be added to this worksheet

Returns:

the given NamedRange

getNamedRanges

Map<String,NamedRange> getNamedRanges()

Gets all the NamedRanges that were added to this worksheet. The map-keys are equal to their names.

Returns:

a map with NamedRanges

setWorksheetOptions

void setWorksheetOptions(WorksheetOptions wso)

Sets the given worksheetOptions as the worksheetOptions of this worksheet.

Parameters:

wso - the worksheetOptions to be set on this worksheet

hasWorksheetOptions

boolean hasWorksheetOptions()

Indicates whether WorksheetOptions was added to this worksheet.

Returns:

true if this worksheet has WorksheetOptions.

getWorksheetOptions

WorksheetOptions getWorksheetOptions()

Gets the WorksheetOptions of this worksheet.

Returns:

The WorksheetOptions of this worksheet. Never null.

setTable

void setTable(Table table)

Sets the given table as the table of this worksheet.

Parameters:

table - the table to be set on this worksheet

getTable

Table getTable()

Gets the table of this worksheet.

Returns:

The table of this worksheet. Never null.

hasTable

boolean hasTable()

Indicates whether this worksheet has a table.

getCellPointer

CellPointer getCellPointer()

Gets the cellpointer of this worksheet.

Returns:

This worksheets cellpointer.

addCell

Cell addCell()

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Returns:

A new cell with an initial datatype of "String" and an empty ("") value.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCell

Cell addCell(Cell cell)

Adds the given cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Returns:

The passed cell.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCell

Cell addCell(Object data)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Datatype and value of the new cell depend on the passed object.

Parameters:

data - The data to be displayed in this cell.

Returns:

A new cell.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

Cell.setData(Object), CellPointer.move()

addCell

Cell addCell(Object data,
             String styleID)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Datatype and value of the new cell depend on the passed object. The new cell will have it's styleID set to the given id.

Parameters:

data - The data to be displayed in this cell.

styleID - The id of the style to employ on this cell.

Returns:

A new cell.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

Cell.setData(Object), Cell.setStyleID(String), CellPointer.move()

addCell

Cell addCell(double data)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Parameters:

data - The data to be displayed in this cell.

Returns:

A new cell with a datatype "Number" and the given double as value.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

Cell.setData(double), CellPointer.move()

addCell

Cell addCell(double data,
             String styleID)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added. The new cell will have it's styleID set to the given id.

Parameters:

data - The data to be displayed in this cell.

styleID - The id of the style to employ on this cell.

Returns:

A new cell with a datatype "Number" and the given double as value.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

Cell.setData(double), Cell.setStyleID(String), CellPointer.move()

addCell

Cell addCell(int data)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Parameters:

data - The data to be displayed in this cell.

Returns:

A new cell with a datatype "Number" and the given int as value.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCell

Cell addCell(int data,
             String styleID)

Adds a new cell at the current position of the worksheets CellPointer and moves the cellpointer.
If this worksheet did not have a table, a new table will be added.

Parameters:

data - The data to be displayed in this cell.

styleID - The id of the style to employ on this cell.

Returns:

A new cell with a datatype "Number" and the given int as value.

Throws:

IndexOutOfBoundsException - if the position of the cellpointer is not within the limits of the worksheet.

See Also:

Cell.setStyleID(String), CellPointer.move()

addCellAt

Cell addCellAt(Address address)

Adds a new cell at the given address. If this worksheet didn't have a row at the row index of the given address, a new row will be added. If there was a cell at the given address, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to address.

Parameters:

address - The address where the new cell should be added.

Returns:

A new cell with an initial datatype of "String" and an empty ("") value.

Throws:

IndexOutOfBoundsException - if the address is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCellAt

Cell addCellAt(int rowIndex,
               int columnIndex)

Adds a new cell at the given row and column index. If this worksheet didn't have a row at the given index, a new row will be added. If the place at the given coordinates was allredy occupied by another cell, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to rowIndex and columnIndex.

Parameters:

rowIndex - The row index (row number).

columnIndex - The column index (column number).

Returns:

A new cell with an initial datatype of "String" and an empty ("") value.

Throws:

IndexOutOfBoundsException - if the position is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCellAt

Cell addCellAt(String a1_ref)

Adds a new cell at the address specified by the A1-reference string. If this worksheet didn't have a row at the row index specified, a new row will be added. If the place at the given coordinates was allredy occupied by another cell, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to the address specified by the A1-reference string.

Parameters:

a1_ref - a string in A1-reference style

Returns:

A new cell with an initial datatype of "String" and an empty ("") value.

Throws:

IndexOutOfBoundsException - if the position is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCellAt

Cell addCellAt(Address address,
               Cell cell)

Adds the given cell at the given address. If this worksheet didn't have a row at the row index of the given address, a new row will be added. If there was a cell at the given address, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to address.

Parameters:

address - The address where the cell should be added.

cell - The cell to be added.

Returns:

The passed cell.

Throws:

IndexOutOfBoundsException - if the address is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCellAt

Cell addCellAt(int rowIndex,
               int columnIndex,
               Cell cell)

Adds the given cell at the given row and column index. If this worksheet didn't have a row at the given index, a new row will be added. If the place at the given coordinates was allredy occupied by another cell, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to rowIndex and columnIndex.

Parameters:

rowIndex - The row index (row number).

columnIndex - The column index (column number).

cell - The cell to be added.

Returns:

The passed cell.

Throws:

IndexOutOfBoundsException - if the position is not within the limits of the worksheet.

See Also:

CellPointer.move()

addCellAt

Cell addCellAt(String a1_ref,
               Cell cell)

Adds the given cell at the address specified by the A1-reference string. If this worksheet didn't have a row at the index specified, a new row will be added. If the place at the given coordinates was allredy occupied by another cell, replaces this cell. If this worksheet did not have a table, a new table will be added.
Moves the cellpointer to a new position relative to the address specified by the A1-reference string.

Parameters:

a1_ref - a string of A1-reference style

cell - the cell to be added.

Returns:

The passed cell.

Throws:

IndexOutOfBoundsException - if the position is not within the limits of the worksheet.

See Also:

CellPointer.move()

removeCellAt

Cell removeCellAt(Address address)

Removes the cell at the given address.

Parameters:

address - The position of the cell to remove.

Returns:

The removed cell or null.

removeCellAt

Cell removeCellAt(int rowIndex,
                  int columnIndex)

Removes the cell at the given coordinates.

Parameters:

rowIndex - The row index (row number).

columnIndex - The column index (column number).

Returns:

The removed cell or null.

removeCellAt

Cell removeCellAt(String a1_ref)

Removes the cell at the address specified by the A1-reference string.

Parameters:

a1_ref - a string of A1-reference style

Returns:

The removed cell or null.

getCellAt

Cell getCellAt(Address address)

Gets the cell at the given address.

Parameters:

address - The position of the cell.

Returns:

The cell at the given address. Never null

getCellAt

Cell getCellAt(int rowIndex,
               int columnIndex)

Gets the cell at the given coordinates.

Parameters:

rowIndex - The row index (row number).

columnIndex - The column index (column number).

Returns:

The cell at the given coordinates. Never null

getCellAt

Cell getCellAt(String a1_ref)

Gets the cell at address specified by the given string in A1-reference style.

Parameters:

a1_ref - a string of A1-reference style

Returns:

The cell at the given coordinates. Never null

hasCellAt

boolean hasCellAt(Address address)

Specifies whether there is a cell at the given address.

hasCellAt

boolean hasCellAt(int rowIndex,
                  int columnIndex)

Specifies whether there is a cell at the intersection of the given row and column index.

hasCellAt

boolean hasCellAt(String a1_ref)

Specifies whether there is a cell at the address specified by the given string in A1-reference style.

addRow

Row addRow()

Adds a new Row to this worksheet. If no rows were previously added the row will be added at index 1. Otherwise the row will be added at maxRowIndex of the underlying Table + 1.

Returns:

A new Row.

Throws:

IndexOutOfBoundsException - If the calculated index is less then firstRow or greater then lastRow.

addRowAt

Row addRowAt(int index)

Adds a new Row at the given index to this worksheet. If the index was allready occupied by another row, replaces this row.

Parameters:

index - The index (row number) of the row.

Returns:

A new Row.

Throws:

IndexOutOfBoundsException - If the given index is less then firstRow or greater then lastRow.

addRow

Row addRow(Row row)

Adds the given row to this worksheet. If no rows were previously added the row will be added at index 1. Otherwise the row will be added at maxRowIndex of the underlying Table + 1.

Parameters:

row - The row to be added.

Returns:

The passed row.

Throws:

IndexOutOfBoundsException - If the calculated index is less then firstRow or greater then lastRow.

addRowAt

Row addRowAt(int index,
             Row row)

Adds the given Row at the given index to this worksheet. If the index was allready occupied by another row, replaces this row.

Parameters:

index - The index (row number) of the row.

row - The row to be added.

Returns:

The passed row.

Throws:

IndexOutOfBoundsException - If the given index is less then firstRow or greater then lastRow.

removeRowAt

Row removeRowAt(int rowIndex)

Removes the row at the given index.

Parameters:

rowIndex - The index (row number) of the row.

Returns:

The removed row or null if the index was not occupied by a row.

getRows

Collection<Row> getRows()

Gets all the rows of this worksheet in the order of their index.

Returns:

A collection of rows.

getRowAt

Row getRowAt(int rowIndex)

Gets the row at the given index.

Parameters:

rowIndex - The index (row number) of the row.

Returns:

The row at the given index, never null.

Throws:

IndexOutOfBoundsException - If the calculated index is less then firstRow or greater then lastRow.

hasRowAt

boolean hasRowAt(int rowIndex)

Specifies whether there is a row at the given row index.

addColumn

Column addColumn()

Adds a new Column to this worksheet. If no columns were previously added the column will be added at index 1. Otherwise the column will be added at maxColumnIndex of the underlying Table + 1.

Returns:

A new column.

Throws:

IndexOutOfBoundsException - If the calculated index is less then firstColumn or greater then lastColumn.

addColumnAt

Column addColumnAt(int index)

Adds a new Column at the given index to this worksheet. If the index was allready occupied by another column, replaces this column.

Parameters:

index - The index (column number) of the column.

Returns:

A new column.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

addColumnAt

Column addColumnAt(String label)

Adds a new Column at the index specified by the given label. If the index was allready occupied by another column, replaces this column.

Parameters:

label - a string ("A" through "IV" inclusive) corresponding to the column index

Returns:

A new column.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

addColumn

Column addColumn(Column column)

Adds the given column to this worksheet. If no columns were previously added the column will be added at index 1. Otherwise the ccolumn will be added at maxColumnIndex of the underlying Table + 1.

Parameters:

column - The column to be added.

Returns:

The passed column.

Throws:

IndexOutOfBoundsException - If the calculated index is less then firstColumn or greater then lastColumn.

addColumnAt

Column addColumnAt(int index,
                   Column column)

Adds the given Column at the given index to this worksheet. If the index was allready occupied by another column, replaces this column.

Parameters:

index - The index (column number) of the column.

column - The column to be added.

Returns:

The passed column.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

addColumnAt

Column addColumnAt(String label,
                   Column column)

Adds the given Column at the given index specified by the given label. If the index was allready occupied by another column, replaces this column.

Parameters:

label - a string ("A" through "IV" inclusive) corresponding to the column index

column - The column to be added.

Returns:

The passed column.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

removeColumnAt

Column removeColumnAt(int columnIndex)

Removes the column at the given index.

Parameters:

columnIndex - The index (column number) of the column.

Returns:

The removed column or null if the index was not occupied by a column.

removeColumnAt

Column removeColumnAt(String label)

Removes the column at the index specified by the given label.

Parameters:

label - a string ("A" through "IV" inclusive) corresponding to the column index

Returns:

The removed column or null if the index was not occupied by a column.

getColumns

Collection<Column> getColumns()

Gets all the columns of this worksheet in the order of their index.

Returns:

A collection of columns.

getColumnAt

Column getColumnAt(int columnIndex)

Gets the column at the given index. If no column was at the given index, returns a new column.

Parameters:

columnIndex - The index (column number) of the column.

Returns:

The column at the given index. Never null.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

getColumnAt

Column getColumnAt(String label)

Gets the column at the index specified by the given label. If no column was at the index, returns a new column.

Parameters:

label - a string ("A" through "IV" inclusive) corresponding to the column index

Returns:

The column at the given index. Never null.

Throws:

IndexOutOfBoundsException - If the given index is less then firstColumn or greater then lastColumn.

hasColumnAt

boolean hasColumnAt(int columnIndex)

Specifies whether there is a column at the given column index.

hasColumnAt

boolean hasColumnAt(String label)

Specifies whether there is a column at the index specified by the given label.

Parameters:

label - a string ("A" through "IV" inclusive) corresponding to the column index

setAutoFilter

void setAutoFilter(String rcString)

Sets the AutoFilter-option on the specified range.

The String rcString should include all of the columns that are to be equiped with a drop-down button at their column- headings, and should either include just the row of the column-headings or the entire range on which the AutoFilter must be set.

Here are some examples:
Given a table of 3 columns and 11 rows. The column-headings are at row 10. The table-data expands to row 21.

• R10C1:R10C3 - the AutoFilter includes the entire range (R10C1:R21C3) and will dynamically expand if more rows of data are added below.
• R10C1:R21C3 - the AutoFilter includes the entire range (R10C1:R21C3) and will dynamically expand if more rows of data are added below.
• R10C1:R10C2 - the AutoFilter includes the entire range (R10C1:R21C3) and will dynamically expand if more rows of data are added below, however, only the first two column-headings have drop -down buttons.
• R12C1:R12C3 - drop-down buttons manifest at row 12; this is probably not what you wanted.

Parameters:

rcString - A String of R1C1 reference style.

setAutoFilter

void setAutoFilter(AutoFilter af)

Sets the AutoFilter on this worksheet.

Parameters:

af - the AutoFilter to be set on this worksheet.

hasAutoFilter

boolean hasAutoFilter()

Specifies whether the setAutoFilter-method was applied on this worksheet.

Returns:

true if the setAutoFilter-method was applied on this worksheet, false otherwise.

removeAutoFilter

void removeAutoFilter()

Removes the Autofilter on this worksheet.

Since:

xelem.2.1