![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.aspose.cells.Worksheet
public final class Worksheet
Represents a worksheet.
Method Summary | |
---|---|
void |
addPageBreaks(int row,
int column)
Adds a page break to the worksheet. |
void |
addPageBreaks(java.lang.String cellName)
Adds a page break to the worksheet. |
void |
autoFitColumn(int columnIndex)
Autofits the column width. |
void |
autoFitColumn(int columnIndex,
int startRow,
int endRow)
Autofits the column width. |
void |
autoFitColumns()
Autofits all columns width in this worksheet. |
void |
autoFitColumns(int startColumn,
int endColumn)
Autofits columns width from startColumn to endColumn. |
void |
autoFitColumns(int startRow,
int startColumn,
int endRow,
int endColumn)
Autofits columns width in a rectangle range. |
void |
autoFitRow(int rowIndex)
Autofits the row height. |
void |
autoFitRow(int rowIndex,
int startColumn,
int endColumn)
Autofits the row height. |
void |
autoFitRows()
Autofits all rows height in this worksheet. |
void |
autoFitRows(int startRow,
int endRow)
Autofits rows height from startRow to endRow. |
void |
autoFitRows(int startRow,
int startColumn,
int endRow,
int endColumn)
Autofits rows height in a rectangle range. |
void |
calculateFormula(boolean recursive,
boolean ignoreError)
Calculates all formulas in this worksheet. |
void |
clearComments()
Clears all comments in the worksheet. |
void |
copy(Worksheet sheet)
Copys contents and formats from another worksheet. |
void |
deleteColumns(int startIndex,
int deletedColumns,
boolean bShift)
Deprecated. Replaced by Cells.deleteColumns(int,int,boolean) |
void |
deleteRows(int startIndex,
int deletedRows,
boolean bShift)
Deprecated. Replaced by Cells.deleteRows(int,int,boolean) |
void |
freezePanes(int row,
int column,
int freezedRows,
int freezedColumns)
Freezes panes at the specified cell in the worksheet. |
void |
freezePanes(java.lang.String cellName,
int freezedRows,
short freezedColumns)
Freezes panes at the specified cell in the worksheet. |
java.lang.String |
getActiveCell()
Gets the active cell. |
AutoFilter |
getAutoFilter()
Gets autofiltering object for the specified worksheet. |
Cell |
getCell(int rowIndex,
int columnIndex)
Deprecated. Replaced by Cells.getCell(int,int) |
Cell |
getCell(java.lang.String cellName)
Deprecated. Replaced by Cells.getCell(String) |
Cells |
getCells()
Gets a collection of Cell objects. |
Charts |
getCharts()
Gets a Charts collection. |
Style |
getColumnStyle(int columnIndex)
Gets the style setting for the specified column. |
float |
getColumnWidth(int columnIndex)
Deprecated. Replaced by Cells.getColumnWidth(int) |
Comments |
getComments()
Gets the Comments collection. |
ConditionalFormattings |
getConditionalFormattings()
Gets the ConditionalFormattings in the worksheet. |
float |
getDefaultColumnWidth()
Deprecated. Replaced by Cells.getStandardWidth() |
float |
getDefaultRowHeight()
Deprecated. Replaced by Cells.getStandardHeight() |
int |
getFirstRowIndex()
Deprecated. Replaced by Cells.getMinRow() |
short |
getFirstVisibleColumn()
Gets first visible column index. |
int |
getFirstVisibleRow()
Gets first visible row index. |
int[] |
getFrozenInfo()
Gets info of frozen panes. |
HPageBreaks |
getHPageBreaks()
Get the HPageBreaks in the worksheet. |
Hyperlinks |
getHyperlinks()
Get the Hyperlinks in the worksheet. |
int |
getIndex()
Gets the sheet index. |
int |
getLastRowIndex()
Deprecated. Replaced by Cells.getMaxRow() |
java.util.ArrayList |
getMergedCells()
Deprecated. Replaced by Cells.getMergedCells() |
java.lang.String |
getName()
Returns the name of the worksheet. |
NamedRange[] |
getNamedRanges()
Gets all pre-defined named ranges in the specific worksheet. |
Outline |
getOutline()
Gets Outline object on a worksheet. |
PageSetup |
getPageSetup()
Get the page setup options in the worksheet. |
Pictures |
getPictures()
Gets a Pictures collection. |
PivotTables |
getPivotTables()
Gets the PivotTables Object which Represents the collection of all the PivotTable objects in the worksheet |
Protection |
getProtection()
Gets the current protection settings. |
Row |
getRow(int rowIndex)
Deprecated. Replaced by Cells.getRow(int) |
java.util.Iterator |
getRowIterator()
Deprecated. Replaced by Cells.getRowIterator() |
Shapes |
getShapes()
Gets the Shapes object in the worksheet. |
SparklineGroupCollection |
getSparklineGroupCollection()
Gets the sparkline group collection in the worksheet. |
Color |
getTabColor()
Gets the colour of the tab below the sheet containing the sheet name. |
TextBoxes |
getTextBoxes()
Gets the TextBoxes collection. |
short |
getType()
Returns the type of the worksheet. |
Validations |
getValidations()
Get the Validations in the worksheet. |
VPageBreaks |
getVPageBreaks()
Get the VPageBreaks in the worksheet. |
Workbook |
getWorkbook()
Gets the workbook which contains this worksheet. |
short |
getZoom()
Gets the scaling factor in percent. |
void |
groupColumns(int startIndex,
int endIndex)
Deprecated. Replaced by Cells.groupColumns(int,int) |
void |
groupColumns(int startIndex,
int endIndex,
boolean isHidden)
Deprecated. Replaced by Cells.groupColumns(int,int,boolean) |
void |
groupRows(int startIndex,
int endIndex)
Deprecated. Replaced by Cells.groupRows(int,int) |
void |
groupRows(int startIndex,
int endIndex,
boolean isHidden)
Deprecated. Replaced by Cells.groupRows(int,int,boolean) |
boolean |
hasAutoFilter()
Indicates whether the sheet has bean auto filtered. |
int |
importResultSet(java.sql.ResultSet rs,
int rowIndex,
int columnIndex,
boolean isFieldNameShown)
Deprecated. Replaced by Cells.importResultSet(ResultSet,int,int,boolean) |
int |
importResultSet(java.sql.ResultSet rs,
int rowIndex,
int columnIndex,
int rowNum,
int columnNum,
boolean isFieldNameShown)
Deprecated. Replaced by Cells.importResultSet(ResultSet,int,int,int,int,boolean) |
int |
importResultSet(java.sql.ResultSet rs,
java.lang.String startCell,
boolean isFieldNameShown)
Deprecated. Replaced by Cells.importResultSet(ResultSet,String,boolean) |
int |
importResultSet(java.sql.ResultSet rs,
java.lang.String startCell,
int rowNum,
int columnNum,
boolean isFieldNameShown)
Deprecated. Replaced by Cells.importResultSet(ResultSet,String,String,boolean) |
void |
insertColumns(int columnIndex,
int columnNum)
Deprecated. Replaced by Cells.insertColumns(int,int) |
void |
insertRows(int rowIndex,
int rowNum)
Deprecated. Replaced by Cells.insertRows(int,int) |
boolean |
isActive()
Indicates whether the worksheet is active. |
boolean |
isColumnHidden(int columnIndex)
Deprecated. Replaced by Cells.isColumnHidden(int) |
boolean |
isGridlinesVisible()
Gets if the the gride lines are visible. |
boolean |
isPageBreakPreview()
Indicates the specified worksheet is shown in normal view or page break preview. |
boolean |
isRowColumnHeadersVisible()
Gets whether the worksheet will display row and column headers. |
boolean |
isSelected()
Indicates whether the worksheet is selected. |
boolean |
isVeryHidden()
Checks if the worksheet is very hidden. |
boolean |
isVisible()
Gets if the worksheet is visible. |
void |
protect(Protection protection)
Protects the worksheet. |
void |
removeCell(int rowIndex,
int columnIndex)
Deprecated. Replaced by Cells.removeCell(int,int) |
void |
removeCell(java.lang.String cellName)
Deprecated. Replaced by Cells.reomveCell(String) |
void |
removeRow(int rowIndex)
Deprecated. Replaced by Cells.removeRow(int) |
void |
removeSplit()
Removes splitted window. |
void |
setActiveCell(int row,
int column)
Sets the active cell. |
void |
setActiveCell(java.lang.String cellName)
Sets the active cell. |
void |
setBackground(byte[] pictureData)
Sets the background for the worksheet. |
void |
setColumnHidden(int columnIndex,
boolean isHidden)
Deprecated. Replaced by Cells.setColumnHidden(int,boolean) |
void |
setColumnStyle(short columnIndex,
Style style)
Sets a style to the specified column. |
void |
setColumnWidth(int columnIndex,
float columnWidth)
Deprecated. Replaced by Cells.setColumnWidth(int,float) |
void |
setDefaultColumnWidth(float defaultColumnWidth)
Deprecated. Replaced by Cells.setStandardWidth(float) |
void |
setDefaultRowHeight(float defaultRowHeight)
Deprecated. Replaced by Cells.setStandardHeight(float) |
void |
setFirstVisibleColumn(int column)
Sets first visible column index. |
void |
setFirstVisibleRow(int row)
Sets first visible row index. |
void |
setGridlinesVisible(boolean gridlinesVisible)
Sets whether the grid lines to be visible or not. |
void |
setName(java.lang.String name)
Sets the worksheet name. |
void |
setPageBreakPreview(boolean pageBreakPreview)
Sets the specified worksheet is shown in normal view or page break preview. |
void |
setRowColumnHeadersVisible(boolean rowColumnHeadersVisible)
Sets whether the worksheet will display row and column headers. |
void |
setSelected(boolean isSelected)
Sets whether the worksheet is selected. |
void |
setStyle(int startRow,
int endRow,
int startColumn,
int endColumn,
Style style)
Deprecated. Replaced by Cells.setRangeStyle(int,int,int,int,Style) |
void |
setTabColor(Color tabColor)
Sets the colour of the tab below the sheet containing the sheet name. |
void |
setVeryHidden(boolean veryHidden)
Sets whether the worksheet to be very hidden or not. |
void |
setVisible(boolean visible)
Sets whether the worksheet to be visible or not. |
void |
setZoom(int zoom)
Sets the scaling factor in percent. |
void |
split()
Splits window. |
void |
unFreezePanes()
Unfreezes panes in the worksheet. |
void |
ungroupColumns(int startIndex,
int endIndex)
Deprecated. Replaced by Cells.ungroupColumns(int,int) |
void |
ungroupRows(int startIndex,
int endIndex)
Deprecated. Replaced by Cells.ungroupRows(int,int) |
void |
unprotect()
Unprotects the worksheet which is protected without password. |
void |
unprotect(java.lang.String password)
Unprotects the worksheet. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public void copy(Worksheet sheet)
sheet
- Source worksheet.public Cells getCells()
CellsException
- if the worksheet has been removed from the workbook.public Workbook getWorkbook()
CellsException
- if the worksheet has been removed from the workbook.public java.lang.String getName()
public int getIndex()
public short getType()
SheetType
public void setName(java.lang.String name)
name
- name of the worksheet. The name length should be 1 to 31.
java.lang.IllegalArgumentException
- if name is invalid
CellsException
- if the worksheet has been removed from the workbook,
or a worksheet with the same name already exists.public boolean isVisible()
public void setVisible(boolean visible)
visible
- true for visible
CellsException
- if the worksheet has been removed from the workbook.public boolean isVeryHidden()
public void setVeryHidden(boolean veryHidden)
veryHidden
- true for veryHidden
CellsException
- if the worksheet has been removed from the workbook.public void setSelected(boolean isSelected)
isSelected
- whether the worksheet is selected.public boolean isSelected()
public boolean isActive()
public short getZoom()
public void setZoom(int zoom)
zoom
- the scaling factor in percent.
CellsException
- if the worksheet has been removed from the workbook.public void setActiveCell(java.lang.String cellName)
cellName
- the cell name.
java.lang.IllegalArgumentException
- if cell name is invalid.public java.lang.String getActiveCell()
public void setActiveCell(int row, int column)
row
- row index.column
- column index.
java.lang.IllegalArgumentException
- if row/column index is out of range.public int getFirstVisibleRow()
public void setFirstVisibleRow(int row)
row
- first visible row index.
java.lang.IllegalArgumentException
- if row index is out of range.
CellsException
- if the worksheet has been removed from the workbook.public short getFirstVisibleColumn()
public void setFirstVisibleColumn(int column)
column
- first visible column index,zero besed.
java.lang.IllegalArgumentException
- if column index is out of range.
CellsException
- if the worksheet has been removed from the workbook.public Color getTabColor()
public void setTabColor(Color tabColor)
tabColor
- the colour of the tab below the sheet containing the sheet name.public void split()
CellsException
- if the worksheet has been removed from the workbook.public void removeSplit()
CellsException
- if the worksheet has been removed from the workbook.public void freezePanes(int row, int column, int freezedRows, int freezedColumns)
row
- row index.column
- column index.freezedRows
- number of visible rows in top pane, no more than row index.freezedColumns
- number of visible columns in left pane, no more than column index.
java.lang.IllegalArgumentException
- if row index,column index,freezedRows or freezedColumns is out of range.
java.lang.IllegalArgumentException
- if row index or column index all are zero.
number of rows and number of columns all are zero.
CellsException
- if the worksheet has been removed from the workbook.public void freezePanes(java.lang.String cellName, int freezedRows, short freezedColumns)
cellName
- cell name.freezedRows
- number of visible rows in top pane, no more than row index.freezedColumns
- number of visible columns in left pane, no more than column index.
java.lang.IllegalArgumentException
- if cell name is invalid.freezePanes(int, int, int, int)
public int[] getFrozenInfo()
public void unFreezePanes()
CellsException
- if the worksheet has been removed from the workbook.public boolean isPageBreakPreview()
public void setPageBreakPreview(boolean pageBreakPreview)
pageBreakPreview
- whether the specified worksheet is shown in normal view or page break preview.
CellsException
- if the worksheet has been removed from the workbook.public boolean isGridlinesVisible()
public void setGridlinesVisible(boolean gridlinesVisible)
gridlinesVisible
- whether the grid lines to be visible or not.
CellsException
- if the worksheet has been removed from the workbook.public boolean isRowColumnHeadersVisible()
public void setRowColumnHeadersVisible(boolean rowColumnHeadersVisible)
rowColumnHeadersVisible
- whether the worksheet
will display row and column headers.
CellsException
- if the worksheet has been removed from the workbook.public Style getColumnStyle(int columnIndex)
columnIndex
- column index.
java.lang.IllegalArgumentException
- if column index is out of range.
CellsException
- if the worksheet has been removed from the workbook.public void setColumnStyle(short columnIndex, Style style)
columnIndex
- column index.style
- style to set.
java.lang.IllegalArgumentException
- if column index is out of range.
CellsException
- if the worksheet has been removed from the workbook.public Hyperlinks getHyperlinks()
public Charts getCharts()
public PivotTables getPivotTables()
public Shapes getShapes()
public SparklineGroupCollection getSparklineGroupCollection()
public Pictures getPictures()
public AutoFilter getAutoFilter()
public boolean hasAutoFilter()
public Comments getComments()
public void clearComments()
public TextBoxes getTextBoxes()
public Outline getOutline()
public Validations getValidations()
public VPageBreaks getVPageBreaks()
public HPageBreaks getHPageBreaks()
public void addPageBreaks(java.lang.String cellName)
cellName
- cell name.
java.lang.IllegalArgumentException
- if cell name is invalid.public void addPageBreaks(int row, int column)
row
- row index,zero basedcolumn
- column index,zero based.
java.lang.IllegalArgumentException
- if row index or cell indexs is invalid.public PageSetup getPageSetup()
public ConditionalFormattings getConditionalFormattings()
public Protection getProtection()
public void protect(Protection protection)
protection
- protection options.public void unprotect()
public void unprotect(java.lang.String password)
java.lang.IllegalArgumentException
- if password is invalid.public NamedRange[] getNamedRanges()
public void autoFitColumn(int columnIndex, int startRow, int endRow)
columnIndex
- column index, zero basedstartRow
- start row index, zero basedendRow
- end row index, zero based
java.lang.IllegalArgumentException
- if row indexs or column index is invalid.public void autoFitColumn(int columnIndex)
columnIndex
- column index,zero based
java.lang.IllegalArgumentException
- if column index is invalid.public void autoFitColumns(int startRow, int startColumn, int endRow, int endColumn)
startRow
- start row index, zero basedstartColumn
- column index, zero basedendRow
- end row index, zero basedendColumn
- column index, zero based
java.lang.IllegalArgumentException
- if row indexs or column indexs is invalid.public void autoFitColumns(int startColumn, int endColumn)
startColumn
- column index, zero basedendColumn
- column index, zero based
java.lang.IllegalArgumentException
- if column indexs is invalid.public void autoFitColumns()
public void autoFitRow(int rowIndex, int startColumn, int endColumn)
rowIndex
- row index, zero basedstartColumn
- start column index, zero basedendColumn
- end column index, zero based
java.lang.IllegalArgumentException
- if row index or column indexs is invalid.public void autoFitRow(int rowIndex)
rowIndex
- row index, zero based
java.lang.IllegalArgumentException
- if row index is invalid.public void autoFitRows(int startRow, int startColumn, int endRow, int endColumn)
startRow
- start row index, zero basedstartColumn
- column index, zero basedendRow
- end row index, zero basedendColumn
- column index, zero based
java.lang.IllegalArgumentException
- if row indexs or column indexs is invalid.public void autoFitRows(int startRow, int endRow)
startRow
- start row index, zero basedendRow
- end row index, zero based
java.lang.IllegalArgumentException
- if row indexs is invalid.public void autoFitRows()
public void calculateFormula(boolean recursive, boolean ignoreError) throws FormulaCalcException
recursive
- True means if the worksheet' cells depend on the cells of other worksheets,
the dependant cells in other worksheets will be calculated too.
False means all the formulas in the worksheet have been calculated and the values are right.ignoreError
- Indicates if hide the error in calculating formulas.
The error may be unsupported function, external links, etc.
FormulaCalcException
- if an error occurs and not hide the error.public void setBackground(byte[] pictureData)
pictureData
- the background picture data.@Deprecated public void groupRows(int startIndex, int endIndex)
Cells.groupRows(int,int)
startIndex
- The first row index to be grouped.endIndex
- The last row index to be grouped.@Deprecated public void groupRows(int startIndex, int endIndex, boolean isHidden)
Cells.groupRows(int,int,boolean)
startIndex
- The first row index to be grouped.endIndex
- The last row index to be grouped.isHidden
- Specifies if the grouped columns are hidden.@Deprecated public void ungroupRows(int startIndex, int endIndex)
Cells.ungroupRows(int,int)
startIndex
- The first row index to be ungrouped.endIndex
- The last row index to be ungrouped.@Deprecated public void groupColumns(int startIndex, int endIndex)
Cells.groupColumns(int,int)
startIndex
- The first column index to be grouped.endIndex
- The last column index to be grouped.@Deprecated public void groupColumns(int startIndex, int endIndex, boolean isHidden)
Cells.groupColumns(int,int,boolean)
startIndex
- The first column index to be grouped.endIndex
- The last column index to be grouped.isHidden
- Specifies if the grouped columns are hidden.@Deprecated public void ungroupColumns(int startIndex, int endIndex)
Cells.ungroupColumns(int,int)
startIndex
- The first column index to be ungrouped.endIndex
- The last column index to be ungrouped.@Deprecated public Cell getCell(int rowIndex, int columnIndex)
Cells.getCell(int,int)
rowIndex
- row indexcolumnIndex
- column index
java.lang.IllegalArgumentException
- if any of the indexes is out of range.
CellsException
- if the worksheet has been removed.@Deprecated public Cell getCell(java.lang.String cellName)
Cells.getCell(String)
cellName
- cell name.
java.lang.IllegalArgumentException
- if the cell name is invalid.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public Row getRow(int rowIndex)
Cells.getRow(int)
rowIndex
- row index.
java.lang.IllegalArgumentException
- if index is out of range.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void insertRows(int rowIndex, int rowNum)
Cells.insertRows(int,int)
rowIndex
- The row index to insert before.rowNum
- Number of rows to be inserted.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void insertColumns(int columnIndex, int columnNum)
Cells.insertColumns(int,int)
columnIndex
- The column index to insert before.columnNum
- Number of columns to be inserted.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void removeRow(int rowIndex)
Cells.removeRow(int)
rowIndex
- row index.
java.lang.IllegalArgumentException
- if row index is out of range.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void deleteRows(int startIndex, int deletedRows, boolean bShift)
Cells.deleteRows(int,int,boolean)
startIndex
- the first row index to be removed.deletedRows
- Number of rows to be removed.bShift
- whether the rows after the deleted rows should be shifted up.@Deprecated public void deleteColumns(int startIndex, int deletedColumns, boolean bShift)
Cells.deleteColumns(int,int,boolean)
startIndex
- the first column index to be removed.deletedColumns
- Number of columns to be removed.bShift
- whether the columns after the deleted columns should be shifted left.@Deprecated public void removeCell(int rowIndex, int columnIndex)
Cells.removeCell(int,int)
rowIndex
- row index of the cell.columnIndex
- column Index of the cell.
java.lang.IllegalArgumentException
- if any of the indexes is out of range.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void removeCell(java.lang.String cellName)
Cells.reomveCell(String)
cellName
- cell name.
java.lang.IllegalArgumentException
- if the cell name is invalid.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public float getDefaultColumnWidth()
Cells.getStandardWidth()
@Deprecated public void setDefaultColumnWidth(float defaultColumnWidth)
Cells.setStandardWidth(float)
defaultColumnWidth
- the default column width of the worksheet in characters. 0-255.
java.lang.IllegalArgumentException
- if the given column width is invalid(< 0 or > 255 ).
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public float getDefaultRowHeight()
Cells.getStandardHeight()
@Deprecated public void setDefaultRowHeight(float defaultRowHeight)
Cells.setStandardHeight(float)
defaultRowHeight
- row height in points(0-409).
java.lang.IllegalArgumentException
- if the row height is invalid.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public void setStyle(int startRow, int endRow, int startColumn, int endColumn, Style style)
Cells.setRangeStyle(int,int,int,int,Style)
startRow
- start row index.endRow
- end row index.startColumn
- start column index.endColumn
- end column index.style
- style to set.
java.lang.IllegalArgumentException
- if any of the indexes is out of range, or start index is
greater than end index.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public java.util.ArrayList getMergedCells()
Cells.getMergedCells()
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown) throws java.sql.SQLException
Cells.importResultSet(ResultSet,int,int,int,int,boolean)
rs
- the ResultSet object to import from.rowIndex
- start row index in the worksheet.columnIndex
- start column index in the worksheet.rowNum
- number of rows to import.columnNum
- number of columns to import.isFieldNameShown
- Indicates whether the field name of the resultset will be imported
to the first row.
java.sql.SQLException
- if an error occurs while reading from the resultset.
CellsException
- if the worksheet has been removed from the workbook.public int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, int rowNum, int columnNum, boolean isFieldNameShown) throws java.sql.SQLException
Cells.importResultSet(ResultSet,String,String,boolean)
rs
- the ResultSet object to import from.startCell
- name of start cell to insert the resultset, such as "A1".rowNum
- number of rows to be imported.columnNum
- number of columns to be imported.isFieldNameShown
- Indicates whether the field name of the resultset will be imported
to the first row.
java.sql.SQLException
- if an error occurs while reading from the resultset.
CellsException
- if the worksheet has been removed from the workbook.public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown) throws java.sql.SQLException
Cells.importResultSet(ResultSet,int,int,boolean)
rs
- the ResultSet object to import from.rowIndex
- start row index in the worksheet.columnIndex
- start column index in the worksheet.isFieldNameShown
- Indicates whether the field name of the resultset will be imported
to the first row.
java.sql.SQLException
- if an error occurs while reading from the resultset.
CellsException
- if the worksheet has been removed from the workbook.public int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, boolean isFieldNameShown) throws java.sql.SQLException
Cells.importResultSet(ResultSet,String,boolean)
rs
- the ResultSet object to import from.startCell
- name of start cell to insert the resultset, such as "A1".isFieldNameShown
- Indicates whether the field name of the resultset will be imported
to the first row.
java.sql.SQLException
- if an error occurs while reading from the resultset.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public int getFirstRowIndex()
Cells.getMinRow()
@Deprecated public int getLastRowIndex()
Cells.getMaxRow()
@Deprecated public java.util.Iterator getRowIterator()
Cells.getRowIterator()
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public float getColumnWidth(int columnIndex)
Cells.getColumnWidth(int)
columnIndex
- column index.
java.lang.IllegalArgumentException
- if column index is out of range.@Deprecated public void setColumnWidth(int columnIndex, float columnWidth)
Cells.setColumnWidth(int,float)
columnIndex
- column index.columnWidth
- column width in characters(0-255).
java.lang.IllegalArgumentException
- if either column index or column width is invalid.
CellsException
- if the worksheet has been removed from the workbook.@Deprecated public boolean isColumnHidden(int columnIndex)
Cells.isColumnHidden(int)
columnIndex
- column index.
java.lang.IllegalArgumentException
- if column index is out of range.@Deprecated public void setColumnHidden(int columnIndex, boolean isHidden)
Cells.setColumnHidden(int,boolean)
columnIndex
- column index.isHidden
- true for hidden.
java.lang.IllegalArgumentException
- if the column index is out of range.
CellsException
- if the worksheet has been removed from the workbook.
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |