com.aspose.cells.WorksheetCollection.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






WorksheetCollection





com.aspose.cells

Class WorksheetCollection
java.lang.Object
  CollectionBase
      com.aspose.cells.WorksheetCollection


All Implemented Interfaces: 
java.lang.Iterable



public class WorksheetCollection extends CollectionBase





            Encapsulates a collection of Worksheet objects.
            
Example:
Workbook workbook = new Workbook();

WorksheetCollection sheets = workbook.getWorksheets();

//Add a worksheet
sheets.add();

//Change the name of a worksheet
sheets.get(0).setName("First Sheet");

//Set the active sheet to the second worksheet
sheets.setActiveSheetIndex(1);












Property Getters/Setters Summary



int getActiveSheetIndex() 
void setActiveSheetIndex(int) 
          
            Represents the index of active worksheet when the spreadsheet is opened.
            



java.lang.String getActiveSheetName() 
void setActiveSheetName(java.lang.String) 
          
            Represents the name of active worksheet when the spreadsheet is opened.
            



BuiltInDocumentPropertyCollection getBuiltInDocumentProperties() 
          
            Returns a DocumentProperty collection that represents all the built-in document properties of the spreadsheet. 
            



int getCount() → inherited from com.aspose.cells.CollectionBase
          



CustomDocumentPropertyCollection getCustomDocumentProperties() 
          
            Returns a DocumentProperty collection that represents all the custom document properties of the spreadsheet. 
            



DxfCollection getDxfs() 
          
             Gets the master differential formatting records.
            



ExternalLinkCollection getExternalLinks() 
          
            Represents external links in a workbook.
            



boolean isRefreshAllConnections() 
void setRefreshAllConnections(boolean) 
          
            Indicates whether refresh all connections on opening file in MS Excel.
            



NameCollection getNames() 
          
            Gets the collection of all the Name objects in the spreadsheet. 
            



java.lang.Object getOleSize() 
void setOleSize(java.lang.Object) 
          
            Gets and Sets displayed size when Workbook file is used as an Ole object.
            



RevisionLogCollection getRevisionLogs() 
          
            Represents revision logs.
            



TableStyleCollection getTableStyles() 
          
            Gets TableStyles object.
            



ThreadedCommentAuthorCollection getThreadedCommentAuthors() 
          
            Gets the list of threaded comment authors.
            



WebExtensionCollection getWebExtensions() 
          
            Gets the list of task panes.
            



WebExtensionTaskPaneCollection getWebExtensionTaskPanes() 
          
            Gets the list of task panes.
            



XmlMapCollection getXmlMaps() 
void setXmlMaps(XmlMapCollection) 
          
            Gets and sets the XML maps in the workbook.
            



Worksheet get(int) 
          
             Gets the Worksheet element at the specified index.
             



Worksheet get(java.lang.String) 
          
            Gets the Worksheet element with the specified name.
            

 







Method Summary




int add() 
          
            Adds a worksheet to the collection.
            




int add(int type) 
          
            Adds a worksheet to the collection.
            




int add(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




Worksheet add(java.lang.String sheetName) 
          
            Adds a worksheet to the collection.
            




int addCopy(int sheetIndex) 
          
            Adds a worksheet to the collection and copies data from an existed worksheet.
            




int addCopy(java.lang.String sheetName) 
          
            Adds a worksheet to the collection and copies data from an existed worksheet.
            




void clear() 
          
            Clear all worksheets.
            




void clearPivottables() 
          
            Clears pivot tables from the spreadsheet.
            




boolean contains(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




Range createRange(java.lang.String address, int sheetIndex) 
          
             Creates a Range object from an address of the range.
            




UnionRange createUnionRange(java.lang.String address, int sheetIndex) 
          
             Creates a Range object from an address of the range.
            




com.aspose.cells.Range[] getNamedRanges() 
          
            Gets all pre-defined named ranges in the spreadsheet.
            




com.aspose.cells.Range[] getNamedRangesAndTables() 
          
            Gets all pre-defined named ranges in the spreadsheet.
            




Range getRangeByName(java.lang.String rangeName) 
          
            Gets Range object by pre-defined name.
            




Range getRangeByName(java.lang.String rangeName, int currentSheetIndex, boolean includeTable) 
          
            Gets Range by pre-defined name or table's name
            




Worksheet getSheetByCodeName(java.lang.String codeName) 
          
            Gets the worksheet by the code name.
            




int indexOf(java.lang.Object value) → inherited from com.aspose.cells.CollectionBase

          Reserved for internal use.




Worksheet insert(int index, int sheetType) 
          
            Insert a worksheet.
            




Worksheet insert(int index, int sheetType, java.lang.String sheetName) 
          
            Insert a worksheet.
            




java.util.Iterator iterator() → inherited from com.aspose.cells.CollectionBase

          




void refreshPivotTables() 
          
            Refreshes all the PivotTables in the WorksheetCollection.
            




java.lang.String registerAddInFunction(int id, java.lang.String functionName) 
          
            Adds addin function into the workbook
            




int registerAddInFunction(java.lang.String addInFile, java.lang.String functionName, boolean lib) 
          
            Adds addin function into the workbook
            




void removeAt(int index) 
          
            Removes the element at a specified index.
            




void removeAt(java.lang.String name) 
          
            Removes the element at a specified name.
            




void setOleSize(int startRow, int endRow, int startColumn, int endColumn) 
          
            Sets displayed size when Workbook file is used as an Ole object.
            




void sortNames() 
          
            Sorts the defined names.
            




void swapSheet(int sheetIndex1, int sheetIndex2) 
          
            Swaps the two sheets.
            

 








Property Getters/Setters Detail



getWebExtensionTaskPanes 
public WebExtensionTaskPaneCollection getWebExtensionTaskPanes()


            Gets the list of task panes.
            



getWebExtensions 
public WebExtensionCollection getWebExtensions()


            Gets the list of task panes.
            



getThreadedCommentAuthors 
public ThreadedCommentAuthorCollection getThreadedCommentAuthors()


            Gets the list of threaded comment authors.
            



isRefreshAllConnections/setRefreshAllConnections 
public boolean isRefreshAllConnections() / public void setRefreshAllConnections(boolean value)


            Indicates whether refresh all connections on opening file in MS Excel.
            



setRefreshAllConnections 
public void setRefreshAllConnections(boolean value)


            Indicates whether refresh all connections on opening file in MS Excel.
            




getNames 
public NameCollection getNames()


            Gets the collection of all the Name objects in the spreadsheet. 
            



getActiveSheetName/setActiveSheetName 
public java.lang.String getActiveSheetName() / public void setActiveSheetName(java.lang.String value)


            Represents the name of active worksheet when the spreadsheet is opened.
            



setActiveSheetName 
public void setActiveSheetName(java.lang.String value)


            Represents the name of active worksheet when the spreadsheet is opened.
            




getActiveSheetIndex/setActiveSheetIndex 
public int getActiveSheetIndex() / public void setActiveSheetIndex(int value)


            Represents the index of active worksheet when the spreadsheet is opened.
            
Sheet index is zero based.



setActiveSheetIndex 
public void setActiveSheetIndex(int value)


            Represents the index of active worksheet when the spreadsheet is opened.
            
Sheet index is zero based.




getDxfs 
public DxfCollection getDxfs()


             Gets the master differential formatting records.
            



getXmlMaps/setXmlMaps 
public XmlMapCollection getXmlMaps() / public void setXmlMaps(XmlMapCollection value)


            Gets and sets the XML maps in the workbook.
            



setXmlMaps 
public void setXmlMaps(XmlMapCollection value)


            Gets and sets the XML maps in the workbook.
            




getBuiltInDocumentProperties 
public BuiltInDocumentPropertyCollection getBuiltInDocumentProperties()


            Returns a DocumentProperty collection that represents all the built-in document properties of the spreadsheet. 
            
A new property cannot be added to built-in document properties list. You can only get a built-in property and change its value.
            The following is the built-in properties name list:
            Title
Subject
Author
Keywords
Comments
Template
Last Author
Revision Number
Application Name
Last Print Date
Creation Date
Last Save Time
Total Editing Time
Number of Pages
Number of Words
Number of Characters
Security
Category
Format
Manager
Company
Number of Bytes
Number of Lines
Number of Paragraphs
Number of Slides
Number of Notes
Number of Hidden Slides
Number of Multimedia ClipsExample:
DocumentProperty doc = workbook.getWorksheets().getBuiltInDocumentProperties().get("Author");
doc.setValue("John Smith");



getCustomDocumentProperties 
public CustomDocumentPropertyCollection getCustomDocumentProperties()


            Returns a DocumentProperty collection that represents all the custom document properties of the spreadsheet. 
            
Example:
excel.getWorksheets().getCustomDocumentProperties().add("Checked by", "Jane");



getOleSize/setOleSize 
public java.lang.Object getOleSize() / public void setOleSize(java.lang.Object value)


            Gets and Sets displayed size when Workbook file is used as an Ole object.
            

            Null means no ole size setting.
            



setOleSize 
public void setOleSize(java.lang.Object value)


            Gets and Sets displayed size when Workbook file is used as an Ole object.
            

            Null means no ole size setting.
            




getExternalLinks 
public ExternalLinkCollection getExternalLinks()


            Represents external links in a workbook.
            



getTableStyles 
public TableStyleCollection getTableStyles()


            Gets TableStyles object.
            



getRevisionLogs 
public RevisionLogCollection getRevisionLogs()


            Represents revision logs.
            



getCount → inherited from com.aspose.cells.CollectionBase

public int getCount()





get 
public Worksheet get(int index)


             Gets the Worksheet element at the specified index.
             
Parameters:
index - The zero based index of the element.
Returns:
The element at the specified index.



get 
public Worksheet get(java.lang.String sheetName)


            Gets the Worksheet element with the specified name.
            
Parameters:
sheetName - Worksheet name
Returns:
The element with the specified name.







Method Detail



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

            Sets displayed size when Workbook file is used as an Ole object.
            
This method is generally used to adjust display size in ppt file or doc file.Parameters:
startRow - Start row index.
endRow - End row index.
startColumn - Start column index.
endColumn - End column index.




clearPivottables 
public void clearPivottables()

            Clears pivot tables from the spreadsheet.
            




refreshPivotTables 
public void refreshPivotTables()
                       throws java.lang.Exception

            Refreshes all the PivotTables in the WorksheetCollection.
            




createRange 
public Range createRange(java.lang.String address, int sheetIndex)

             Creates a Range object from an address of the range.
            
Parameters:
address - The address of the range.
sheetIndex - The sheet index.
Returns:
A Range object




createUnionRange 
public UnionRange createUnionRange(java.lang.String address, int sheetIndex)

             Creates a Range object from an address of the range.
            
Parameters:
address - The address of the range.
sheetIndex - The sheet index.
Returns:
A Range object




getSheetByCodeName 
public Worksheet getSheetByCodeName(java.lang.String codeName)

            Gets the worksheet by the code name.
            
Parameters:
codeName - Worksheet code name.
Returns:
The element with the specified code name.




sortNames 
public void sortNames()

            Sorts the defined names.
            
If you create a large amount of named ranges in the Excel file, 
            please call this method after all named ranges are created and before saving 




insert 
public Worksheet insert(int index, int sheetType)

            Insert a worksheet.
            
Parameters:
index - The sheet index
sheetType - A SheetType value. The sheet type.
Returns:
Returns an inserted worksheet.




insert 
public Worksheet insert(int index, int sheetType, java.lang.String sheetName)

            Insert a worksheet.
            
Parameters:
index - The sheet index
sheetType - A SheetType value. The sheet type.
sheetName - The sheet name.
Returns:
Returns an inserted worksheet.




add 
public int add(int type)

            Adds a worksheet to the collection.
            
Parameters:
type - A SheetType value. Worksheet type.
Returns:
Worksheet object index.
Example:
Workbook workbook = new Workbook();
workbook.getWorksheets().add(SheetType.CHART);
Cells cells = workbook.getWorksheets().get(0).getCells();
cells.get("c2").putValue(5000);
cells.get("c3").putValue(3000);
cells.get("c4").putValue(4000);
cells.get("c5").putValue(5000);
cells.get("c6").putValue(6000);
ChartCollection charts = workbook.getWorksheets().get(1).getCharts();
int chartIndex = charts.add(ChartType.COLUMN, 10, 10, 20, 20);
Chart chart = charts.get(chartIndex);
chart.getNSeries().add("Sheet1!C2:C6", true);




swapSheet 
public void swapSheet(int sheetIndex1, int sheetIndex2)

            Swaps the two sheets.
            
Parameters:
sheetIndex1 - The first worksheet.
sheetIndex2 - The second worksheet.




add 
public int add()

            Adds a worksheet to the collection.
            
Returns:
Worksheet object index.




add 
public Worksheet add(java.lang.String sheetName)

            Adds a worksheet to the collection.
            
Parameters:
sheetName - Worksheet name
Returns:
Worksheet object.




registerAddInFunction 
public int registerAddInFunction(java.lang.String addInFile, java.lang.String functionName, boolean lib)

            Adds addin function into the workbook
            
Parameters:
addInFile - the file contains the addin functions
functionName - the addin function name
lib - whether the given addin file is in the directory or sub-directory of Workbook Add-In library.
            This flag takes effect and makes difference when given addInFile is of relative path:
            true denotes the path is relative to Add-In library and false denotes the path is relative to this Workbook.
Returns:
ID of the data which contains given addin function




registerAddInFunction 
public java.lang.String registerAddInFunction(int id, java.lang.String functionName)

            Adds addin function into the workbook
            
Parameters:
id - ID of the data which contains addin functions,
            can be got by the first call of registerAddInFunction(java.lang.String, java.lang.String, boolean) for the same addin file.
functionName - the addin function name
Returns:
URL of the addin file which contains addin functions




removeAt 
public void removeAt(java.lang.String name)

            Removes the element at a specified name.
            
Parameters:
name - The name of the element to remove.




removeAt 
public void removeAt(int index)

            Removes the element at a specified index.
            
Parameters:
index - The index value of the element to remove.




clear 
public void clear()

            Clear all worksheets.
            

            A workbook must contains a worksheet.
            




addCopy 
public int addCopy(java.lang.String sheetName)
           throws java.lang.Exception

            Adds a worksheet to the collection and copies data from an existed worksheet.
            
Parameters:
sheetName - Name of source worksheet.
Returns:
Worksheet object index.




addCopy 
public int addCopy(int sheetIndex)
           throws java.lang.Exception

            Adds a worksheet to the collection and copies data from an existed worksheet.
            
Parameters:
sheetIndex - Index of source worksheet.
Returns:
Worksheet object index.




getRangeByName 
public Range getRangeByName(java.lang.String rangeName)

            Gets Range object by pre-defined name.
            
Parameters:
rangeName - Name of range.
Returns:
Range object.Returns null if the named range does not exist.




getRangeByName 
public Range getRangeByName(java.lang.String rangeName, int currentSheetIndex, boolean includeTable)

            Gets Range by pre-defined name or table's name
            
Parameters:
rangeName - Name of range or table's name.
currentSheetIndex - The sheet index. -1 represents global .
includeTable - Indicates whether checking all tables.
Returns:





getNamedRanges 
public com.aspose.cells.Range[] getNamedRanges()

            Gets all pre-defined named ranges in the spreadsheet.
            
Returns:
An array of Range objects.
            If the defined Name's reference is external or has multiple ranges, no Range object will be returned for this Name.
            Returns null if the named range does not exist.




getNamedRangesAndTables 
public com.aspose.cells.Range[] getNamedRangesAndTables()

            Gets all pre-defined named ranges in the spreadsheet.
            
Returns:
An array of Range objects.Returns null if the named range does not exist.




iterator → inherited from com.aspose.cells.CollectionBase

public java.util.Iterator iterator()





contains → inherited from com.aspose.cells.CollectionBase

public boolean contains(java.lang.Object value)
Reserved for internal use.




add → inherited from com.aspose.cells.CollectionBase

public int add(java.lang.Object value)
Reserved for internal use.




indexOf → inherited from com.aspose.cells.CollectionBase

public int indexOf(java.lang.Object value)
Reserved for internal use.




See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Property Getters/Setters Summary
`int`	`getActiveSheetIndex()`
`void`	`setActiveSheetIndex(int)`
	Represents the index of active worksheet when the spreadsheet is opened.
`java.lang.String`	`getActiveSheetName()`
`void`	`setActiveSheetName(java.lang.String)`
	Represents the name of active worksheet when the spreadsheet is opened.
`BuiltInDocumentPropertyCollection`	`getBuiltInDocumentProperties()`
	Returns a DocumentProperty collection that represents all the built-in document properties of the spreadsheet.
`int`	`getCount()`	`→ inherited from com.aspose.cells.CollectionBase`

`CustomDocumentPropertyCollection`	`getCustomDocumentProperties()`
	Returns a DocumentProperty collection that represents all the custom document properties of the spreadsheet.
`DxfCollection`	`getDxfs()`
	Gets the master differential formatting records.
`ExternalLinkCollection`	`getExternalLinks()`
	Represents external links in a workbook.
`boolean`	`isRefreshAllConnections()`
`void`	`setRefreshAllConnections(boolean)`
	Indicates whether refresh all connections on opening file in MS Excel.
`NameCollection`	`getNames()`
	Gets the collection of all the Name objects in the spreadsheet.
`java.lang.Object`	`getOleSize()`
`void`	`setOleSize(java.lang.Object)`
	Gets and Sets displayed size when Workbook file is used as an Ole object.
`RevisionLogCollection`	`getRevisionLogs()`
	Represents revision logs.
`TableStyleCollection`	`getTableStyles()`
	Gets TableStyles object.
`ThreadedCommentAuthorCollection`	`getThreadedCommentAuthors()`
	Gets the list of threaded comment authors.
`WebExtensionCollection`	`getWebExtensions()`
	Gets the list of task panes.
`WebExtensionTaskPaneCollection`	`getWebExtensionTaskPanes()`
	Gets the list of task panes.
`XmlMapCollection`	`getXmlMaps()`
`void`	`setXmlMaps(XmlMapCollection)`
	Gets and sets the XML maps in the workbook.
`Worksheet`	`get(int)`
	Gets the Worksheet element at the specified index.
`Worksheet`	`get(java.lang.String)`
	Gets the Worksheet element with the specified name.

Method Summary
`int`	`add()`
`int`	Adds a worksheet to the collection.
`int`	`add(int type)`
`int`	Adds a worksheet to the collection.
`int`	`add(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`int`	Reserved for internal use.
`Worksheet`	`add(java.lang.String sheetName)`
`Worksheet`	Adds a worksheet to the collection.
`int`	`addCopy(int sheetIndex)`
`int`	Adds a worksheet to the collection and copies data from an existed worksheet.
`int`	`addCopy(java.lang.String sheetName)`
`int`	Adds a worksheet to the collection and copies data from an existed worksheet.
`void`	`clear()`
`void`	Clear all worksheets.
`void`	`clearPivottables()`
`void`	Clears pivot tables from the spreadsheet.
`boolean`	`contains(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`boolean`	Reserved for internal use.
`Range`	`createRange(java.lang.String address, int sheetIndex)`
`Range`	Creates a Range object from an address of the range.
`UnionRange`	`createUnionRange(java.lang.String address, int sheetIndex)`
`UnionRange`	Creates a Range object from an address of the range.
`com.aspose.cells.Range[]`	`getNamedRanges()`
`com.aspose.cells.Range[]`	Gets all pre-defined named ranges in the spreadsheet.
`com.aspose.cells.Range[]`	`getNamedRangesAndTables()`
`com.aspose.cells.Range[]`	Gets all pre-defined named ranges in the spreadsheet.
`Range`	`getRangeByName(java.lang.String rangeName)`
`Range`	Gets Range object by pre-defined name.
`Range`	`getRangeByName(java.lang.String rangeName, int currentSheetIndex, boolean includeTable)`
`Range`	Gets Range by pre-defined name or table's name
`Worksheet`	`getSheetByCodeName(java.lang.String codeName)`
`Worksheet`	Gets the worksheet by the code name.
`int`	`indexOf(java.lang.Object value)`	`→ inherited from com.aspose.cells.CollectionBase`
`int`	Reserved for internal use.
`Worksheet`	`insert(int index, int sheetType)`
`Worksheet`	Insert a worksheet.
`Worksheet`	`insert(int index, int sheetType, java.lang.String sheetName)`
`Worksheet`	Insert a worksheet.
`java.util.Iterator`	`iterator()`	`→ inherited from com.aspose.cells.CollectionBase`
`java.util.Iterator`
`void`	`refreshPivotTables()`
`void`	Refreshes all the PivotTables in the WorksheetCollection.
`java.lang.String`	`registerAddInFunction(int id, java.lang.String functionName)`
`java.lang.String`	Adds addin function into the workbook
`int`	`registerAddInFunction(java.lang.String addInFile, java.lang.String functionName, boolean lib)`
`int`	Adds addin function into the workbook
`void`	`removeAt(int index)`
`void`	Removes the element at a specified index.
`void`	`removeAt(java.lang.String name)`
`void`	Removes the element at a specified name.
`void`	`setOleSize(int startRow, int endRow, int startColumn, int endColumn)`
`void`	Sets displayed size when Workbook file is used as an Ole object.
`void`	`sortNames()`
`void`	Sorts the defined names.
`void`	`swapSheet(int sheetIndex1, int sheetIndex2)`
`void`	Swaps the two sheets.

getWebExtensionTaskPanes
public WebExtensionTaskPaneCollection getWebExtensionTaskPanes()

getWebExtensions
public WebExtensionCollection getWebExtensions()

getThreadedCommentAuthors
public ThreadedCommentAuthorCollection getThreadedCommentAuthors()

isRefreshAllConnections/setRefreshAllConnections
public boolean isRefreshAllConnections() / public void setRefreshAllConnections(boolean value)

setRefreshAllConnections
public void setRefreshAllConnections(boolean value)

getActiveSheetName/setActiveSheetName
public java.lang.String getActiveSheetName() / public void setActiveSheetName(java.lang.String value)

setActiveSheetName
public void setActiveSheetName(java.lang.String value)

getActiveSheetIndex/setActiveSheetIndex
public int getActiveSheetIndex() / public void setActiveSheetIndex(int value)

setActiveSheetIndex
public void setActiveSheetIndex(int value)

getXmlMaps/setXmlMaps
public XmlMapCollection getXmlMaps() / public void setXmlMaps(XmlMapCollection value)

setXmlMaps
public void setXmlMaps(XmlMapCollection value)

getBuiltInDocumentProperties
public BuiltInDocumentPropertyCollection getBuiltInDocumentProperties()

getCustomDocumentProperties
public CustomDocumentPropertyCollection getCustomDocumentProperties()

getOleSize/setOleSize
public java.lang.Object getOleSize() / public void setOleSize(java.lang.Object value)

setOleSize
public void setOleSize(java.lang.Object value)

getExternalLinks
public ExternalLinkCollection getExternalLinks()

getTableStyles
public TableStyleCollection getTableStyles()

getRevisionLogs
public RevisionLogCollection getRevisionLogs()

getCount	`→ inherited from com.aspose.cells.CollectionBase`
public int getCount()

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

com.aspose.cells.WorksheetCollection.html Maven / Gradle / Ivy

com.aspose.cells Class WorksheetCollection

getWebExtensionTaskPanes

getWebExtensions

getThreadedCommentAuthors

isRefreshAllConnections/setRefreshAllConnections

setRefreshAllConnections

getNames

getActiveSheetName/setActiveSheetName

setActiveSheetName

getActiveSheetIndex/setActiveSheetIndex

setActiveSheetIndex

getDxfs

getXmlMaps/setXmlMaps

setXmlMaps

getBuiltInDocumentProperties

getCustomDocumentProperties

getOleSize/setOleSize

setOleSize

getExternalLinks

getTableStyles

getRevisionLogs

getCount

get

get

setOleSize

clearPivottables

refreshPivotTables

createRange

createUnionRange

getSheetByCodeName

sortNames

insert

insert

add

swapSheet

add

add

registerAddInFunction

registerAddInFunction

removeAt

removeAt

clear

addCopy

addCopy

getRangeByName

getRangeByName

getNamedRanges

getNamedRangesAndTables

iterator

contains

add

indexOf

com.aspose.cells
Class WorksheetCollection

refreshPivotTables
public void refreshPivotTables() throws java.lang.Exception

createRange
public Range createRange(java.lang.String address, int sheetIndex)

createUnionRange
public UnionRange createUnionRange(java.lang.String address, int sheetIndex)

getSheetByCodeName
public Worksheet getSheetByCodeName(java.lang.String codeName)

insert
public Worksheet insert(int index, int sheetType, java.lang.String sheetName)

swapSheet
public void swapSheet(int sheetIndex1, int sheetIndex2)

registerAddInFunction
public int registerAddInFunction(java.lang.String addInFile, java.lang.String functionName, boolean lib)

registerAddInFunction
public java.lang.String registerAddInFunction(int id, java.lang.String functionName)

addCopy
public int addCopy(java.lang.String sheetName) throws java.lang.Exception

addCopy
public int addCopy(int sheetIndex) throws java.lang.Exception