worksheetscollection-j9官方网址

com.spire.xls.collections
class worksheetscollection

java.lang.object
  com.spire.ms.system.collections.collectionbase
      
          com.spire.xls.core.spreadsheet.collections.xlsworksheetscollection
              com.spire.xls.collections.worksheetscollection

all implemented interfaces:

com.spire.ms.system.collections.icollection, com.spire.ms.system.collections.ienumerable, iworksheets, java.lang.iterable

public class worksheetscollection
extends xlsworksheetscollection

represents the worksheetscollection.

add

public worksheet add(java.lang.string name)

adds a new worksheet.

overrides:

add in class xlsworksheetscollection

parameters:

name - worksheet name.

returns:

added worksheet.

addcopy

public worksheet addcopy(int sheetindex)

adds copy of worksheet.

overrides:

addcopy in class xlsworksheetscollection

parameters:

sheetindex - sheet index.

returns:

added worksheet.

addcopy

public worksheet addcopy(worksheet sheet)

adds copy of worksheet.

parameters:

sheet - worksheet to copy.

returns:

added worksheet.

addcopy

public void addcopy(worksheetscollection sheets)

adding worksheets collection to workbook.

parameters:

sheets - source worksheets collection.

create

public worksheet create(java.lang.string name)

create a new worksheet.

specified by:

create in interface iworksheets

overrides:

create in class xlsworksheetscollection

parameters:

name - worksheet name

returns:

create

public worksheet create()

creates a new worksheet.

specified by:

create in interface iworksheets

overrides:

create in class xlsworksheetscollection

returns:

findallnumber

public cellrange[] findallnumber(double doublevalue,
                                 boolean formulavalue)

finds the cell with the input double.

parameters:

doublevalue - double value to search for

formulavalue - indicates whether to find formula value

returns:

found ranges

findallstring

public cellrange[] findallstring(java.lang.string stringvalue,
                                 boolean formula,
                                 boolean formulavalue)

finds the cell with the input string.

parameters:

stringvalue - string value to search for

formula - indicates whether include formula

formulavalue - indicates whether include formula value

returns:

found ranges

findalldatetime

public cellrange[] findalldatetime(java.util.date datevalue)

finds the cell with the input datetime.

parameters:

datevalue - date value to search for

returns:

found ranges

findallbool

public cellrange[] findallbool(boolean boolvalue)

finds the cell with the input bool.

parameters:

boolvalue - bool value to search for

returns:

found ranges

findbool

public cellrange findbool(boolean boolvalue)

finds the cell with the input bool.

parameters:

boolvalue - bool value to search for

returns:

found range

findnumber

public cellrange findnumber(double doublevalue,
                            boolean formulavalue)

finds the cell with the input double.

parameters:

doublevalue - double value to search for

formulavalue - indicates whether includes formula value to search for

returns:

found range

findstring

public cellrange findstring(java.lang.string stringvalue,
                            boolean formula,
                            boolean formulavalue)

finds the cell with the input string.

parameters:

stringvalue - string value to search for

formula - indicates whether includes formula to search for

formulavalue - indicates whether includes formula value to search for

returns:

found range

finddatetime

public cellrange finddatetime(java.util.date datevalue)

finds the cell with the input date.

parameters:

datevalue - date value to search for

returns:

found range

remove

public void remove(worksheet sheet)

remove worksheet from collection.

parameters:

sheet - worksheet object.

get

public worksheet get(int index)

returns a single object from a collection. read-only.

specified by:

get in interface iworksheets

overrides:

get in class xlsworksheetscollection

parameters:

index -

returns:

get

public worksheet get(java.lang.string sheetname)

returns a single object from a collection. read-only.

specified by:

get in interface iworksheets

overrides:

get in class xlsworksheetscollection

parameters:

sheetname -

returns: