Interface IWorksheetCollection

com.aspose.cells.WorksheetCollection

Hierarchy 层级

ICollectionBase
- IWorksheetCollection

Index 目录

Methods 方法

Methods 方法

add

add(o: any): number
add(type: number): number
add(): number
add(sheetName: string): IWorksheet

int add(java.lang.Object)

Parameters 参数
- o: any
Returns 返回值 number
int add(int)

Parameters 参数
- type: number
Returns 返回值 number
int add()

Returns 返回值 number
com.aspose.cells.Worksheet add(java.lang.String)

Parameters 参数
- sheetName: string
Returns 返回值 IWorksheet

addCopy

addCopy(sheetIndex: number): number
addCopy(sheetName: string): number

int addCopy(int)

Parameters 参数
- sheetIndex: number
Returns 返回值 number
int addCopy(java.lang.String)

Parameters 参数
- sheetName: string
Returns 返回值 number

clear

clear(): void

void clear()

Returns 返回值 void

clearPivottables

clearPivottables(): void

void clearPivottables()

Returns 返回值 void

contains

contains(o: any): boolean

boolean contains(java.lang.Object)

Parameters 参数
- o: any
Returns 返回值 boolean

createRange

createRange(address: string, sheetIndex: number): IRange

com.aspose.cells.Range createRange(java.lang.String, int)

Parameters 参数
- address: string
- sheetIndex: number
Returns 返回值 IRange

createUnionRange

createUnionRange(address: string, sheetIndex: number): IUnionRange

com.aspose.cells.UnionRange createUnionRange(java.lang.String, int)

Parameters 参数
- address: string
- sheetIndex: number
Returns 返回值 IUnionRange

get

get(sheetName: string): IWorksheet
get(index: number): IWorksheet

com.aspose.cells.Worksheet get(java.lang.String)

Parameters 参数
- sheetName: string
Returns 返回值 IWorksheet
com.aspose.cells.Worksheet get(int)

Parameters 参数
- index: number
Returns 返回值 IWorksheet

getActiveSheetIndex

getActiveSheetIndex(): number

int getActiveSheetIndex()

Returns 返回值 number

getBuiltInDocumentProperties

getBuiltInDocumentProperties(): IBuiltInDocumentPropertyCollection

com.aspose.cells.BuiltInDocumentPropertyCollection getBuiltInDocumentProperties()

Returns 返回值 IBuiltInDocumentPropertyCollection

getCount

getCount(): number

int getCount()

Returns 返回值 number

getCustomDocumentProperties

getCustomDocumentProperties(): ICustomDocumentPropertyCollection

com.aspose.cells.CustomDocumentPropertyCollection getCustomDocumentProperties()

Returns 返回值 ICustomDocumentPropertyCollection

getDxfs

getDxfs(): IDxfCollection

com.aspose.cells.DxfCollection getDxfs()

Returns 返回值 IDxfCollection

getExternalLinks

getExternalLinks(): IExternalLinkCollection

com.aspose.cells.ExternalLinkCollection getExternalLinks()

Returns 返回值 IExternalLinkCollection

getNamedRanges

getNamedRanges(): IRange[]

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

Returns 返回值 IRange[]

getNamedRangesAndTables

getNamedRangesAndTables(): IRange[]

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

Returns 返回值 IRange[]

getNames

getNames(): INameCollection

com.aspose.cells.NameCollection getNames()

Returns 返回值 INameCollection

getOleSize

getOleSize(): any

java.lang.Object getOleSize()

Returns 返回值 any

getRangeByName

getRangeByName(rangeName: string): IRange

com.aspose.cells.Range getRangeByName(java.lang.String)

Parameters 参数
- rangeName: string
Returns 返回值 IRange

getRevisionLogs

getRevisionLogs(): IRevisionLogCollection

com.aspose.cells.RevisionLogCollection getRevisionLogs()

Returns 返回值 IRevisionLogCollection

getSheetByCodeName

getSheetByCodeName(codeName: string): IWorksheet

com.aspose.cells.Worksheet getSheetByCodeName(java.lang.String)

Parameters 参数
- codeName: string
Returns 返回值 IWorksheet

getTableStyles

getTableStyles(): ITableStyleCollection

com.aspose.cells.TableStyleCollection getTableStyles()

Returns 返回值 ITableStyleCollection

getThreadedCommentAuthors

getThreadedCommentAuthors(): IThreadedCommentAuthorCollection

com.aspose.cells.ThreadedCommentAuthorCollection getThreadedCommentAuthors()

Returns 返回值 IThreadedCommentAuthorCollection

getWebExtensionTaskPanes

getWebExtensionTaskPanes(): IWebExtensionTaskPaneCollection

com.aspose.cells.WebExtensionTaskPaneCollection getWebExtensionTaskPanes()

Returns 返回值 IWebExtensionTaskPaneCollection

getWebExtensions

getWebExtensions(): IWebExtensionCollection

com.aspose.cells.WebExtensionCollection getWebExtensions()

Returns 返回值 IWebExtensionCollection

getXmlMaps

getXmlMaps(): IXmlMapCollection

com.aspose.cells.XmlMapCollection getXmlMaps()

Returns 返回值 IXmlMapCollection

indexOf

indexOf(o: any): number

int indexOf(java.lang.Object)

Parameters 参数
- o: any
Returns 返回值 number

insert

insert(index: number, sheetType: number, sheetName: string): IWorksheet
insert(index: number, sheetType: number): IWorksheet

com.aspose.cells.Worksheet insert(int, int, java.lang.String)

Parameters 参数
- index: number
- sheetType: number
- sheetName: string
Returns 返回值 IWorksheet
com.aspose.cells.Worksheet insert(int, int)

Parameters 参数
- index: number
- sheetType: number
Returns 返回值 IWorksheet

isRefreshAllConnections

isRefreshAllConnections(): boolean

boolean isRefreshAllConnections()

Returns 返回值 boolean

iterator

iterator(): any

java.util.Iterator iterator()

Returns 返回值 any

refreshPivotTables

refreshPivotTables(): void

void refreshPivotTables()

Returns 返回值 void

registerAddInFunction

registerAddInFunction(addInFile: string, functionName: string, lib: boolean): number
registerAddInFunction(id: number, functionName: string): string

int registerAddInFunction(java.lang.String, java.lang.String, boolean)

Parameters 参数
- addInFile: string
- functionName: string
- lib: boolean
Returns 返回值 number
java.lang.String registerAddInFunction(int, java.lang.String)

Parameters 参数
- id: number
- functionName: string
Returns 返回值 string

removeAt

removeAt(index: number): void
removeAt(name: string): void

void removeAt(int)

Parameters 参数
- index: number
Returns 返回值 void
void removeAt(java.lang.String)

Parameters 参数
- name: string
Returns 返回值 void

setActiveSheetIndex

setActiveSheetIndex(value: number): void

void setActiveSheetIndex(int)

Parameters 参数
- value: number
Returns 返回值 void

setOleSize

setOleSize(value: any): void
setOleSize(startRow: number, endRow: number, startColumn: number, endColumn: number): void

void setOleSize(java.lang.Object)

Parameters 参数
- value: any
Returns 返回值 void
void setOleSize(int, int, int, int)

Parameters 参数
- startRow: number
- endRow: number
- startColumn: number
- endColumn: number
Returns 返回值 void

setRefreshAllConnections

setRefreshAllConnections(value: boolean): void

void setRefreshAllConnections(boolean)

Parameters 参数
- value: boolean
Returns 返回值 void

setXmlMaps

setXmlMaps(value: IXmlMapCollection): void

void setXmlMaps(com.aspose.cells.XmlMapCollection)

Parameters 参数
- value: IXmlMapCollection
Returns 返回值 void

sortNames

sortNames(): void

void sortNames()

Returns 返回值 void

swapSheet

swapSheet(sheetIndex1: number, sheetIndex2: number): void

void swapSheet(int, int)

Parameters 参数
- sheetIndex1: number
- sheetIndex2: number
Returns 返回值 void