iworksheets-ag凯发旗舰厅

com.spire.xls.core
interface iworksheets

all superinterfaces:

java.lang.iterable

all known implementing classes:

worksheetscollection, xlsworksheetscollection

public interface iworksheets
extends java.lang.iterable

a collection of all the worksheet objects in the specified or active workbook. each worksheet object represents a worksheet.

getcount

int getcount()

returns the number of objects in the collection. read-only long.

get

iworksheet get(int index)

returns a single object from a collection.

get

iworksheet get(java.lang.string sheetname)

returns a single object from a collection.

getparent

java.lang.object getparent()

returns the parent object for the specified object.

getuserangescache

boolean getuserangescache()

indicates whether all created range objects should be cached.

create

iworksheet create(java.lang.string name)

create worksheet with specified name.

parameters:

name - new name of worksheet. must be unique for collection.

returns:

reference on created worksheet.

create

iworksheet create()

create a new worksheet.

returns:

reference on created worksheet.

remove

void remove(iworksheet sheet)

remove worksheet from collection.

parameters:

sheet - reference on worksheet to remove.

remove

void remove(java.lang.string sheetname)

removes specified worksheet from the collection.

parameters:

sheetname - name of the sheet to remove.

remove

void remove(int index)

removes specified worksheet from the collection.

parameters:

index - index of the sheet to remove.

addcopybefore

iworksheet addcopybefore(iworksheet tocopy)

adds copy of sheet to collection before choosed sheet.

parameters:

tocopy - represents worksheet to copy.

returns:

returns copied sheet.

addcopybefore

iworksheet addcopybefore(iworksheet tocopy,
                         iworksheet sheetafter)

adds copy of sheet to collection before choosed sheet.

parameters:

tocopy - represents worksheet to copy.

sheetafter - represents sheet that, in collection must be after copied sheet.

returns:

returns copied sheet.

addcopyafter

iworksheet addcopyafter(iworksheet tocopy)

adds copy of sheet to collection after choosed sheet.

parameters:

tocopy - represents worksheet to copy.

returns:

returns copied sheet.

addcopyafter

iworksheet addcopyafter(iworksheet tocopy,
                        iworksheet sheetbefore)

adds copy of sheet to collection before choosed sheet.

parameters:

tocopy - represents worksheet to copy.

sheetbefore - represents sheet that, in collection must be before copied sheet.

returns:

returns copied sheet.