IWorkbook | 自助仪表盘宏接口文档

com.aspose.cells.Workbook

Hierarchy 层级

Izk
- IWorkbook

Index 目录

Methods 方法

acceptAllRevisions

acceptAllRevisions(): void

void acceptAllRevisions()

Returns 返回值 void

addDigitalSignature

addDigitalSignature(digitalSignatureCollection: IDigitalSignatureCollection): void

void addDigitalSignature(com.aspose.cells.DigitalSignatureCollection)

Parameters 参数
- digitalSignatureCollection: IDigitalSignatureCollection
Returns 返回值 void

calculateFormula

calculateFormula(options: ICalculationOptions): void
calculateFormula(ignoreError: boolean): void
calculateFormula(ignoreError: boolean, customFunction: IICustomFunction): void
calculateFormula(): void

void calculateFormula(com.aspose.cells.CalculationOptions)

Parameters 参数
- options: ICalculationOptions
Returns 返回值 void
void calculateFormula(boolean)

Parameters 参数
- ignoreError: boolean
Returns 返回值 void
void calculateFormula(boolean, com.aspose.cells.ICustomFunction)

Parameters 参数
- ignoreError: boolean
- customFunction: IICustomFunction
Returns 返回值 void
void calculateFormula()

Returns 返回值 void

changePalette

changePalette(color: IColor, index: number): void

void changePalette(com.aspose.cells.Color, int)

Parameters 参数
- color: IColor
- index: number
Returns 返回值 void

combine

combine(secondWorkbook: IWorkbook): void

void combine(com.aspose.cells.Workbook)

Parameters 参数
- secondWorkbook: IWorkbook
Returns 返回值 void

copy

copy(source: IWorkbook): void
copy(source: IWorkbook, copyOptions: ICopyOptions): void

void copy(com.aspose.cells.Workbook)

Parameters 参数
- source: IWorkbook
Returns 返回值 void
void copy(com.aspose.cells.Workbook, com.aspose.cells.CopyOptions)

Parameters 参数
- source: IWorkbook
- copyOptions: ICopyOptions
Returns 返回值 void

copyTheme

copyTheme(source: IWorkbook): void

void copyTheme(com.aspose.cells.Workbook)

Parameters 参数
- source: IWorkbook
Returns 返回值 void

createBuiltinStyle

createBuiltinStyle(type: number): IStyle

com.aspose.cells.Style createBuiltinStyle(int)

Parameters 参数
- type: number
Returns 返回值 IStyle

createCellsColor

createCellsColor(): ICellsColor

com.aspose.cells.CellsColor createCellsColor()

Returns 返回值 ICellsColor

createStyle

createStyle(): IStyle

com.aspose.cells.Style createStyle()

Returns 返回值 IStyle

customTheme

customTheme(themeName: string, colors: IColor[]): void

void customTheme(java.lang.String, com.aspose.cells.Color[])

Parameters 参数
- themeName: string
- colors: IColor[]
Returns 返回值 void

dispose

dispose(): void

void dispose()

Returns 返回值 void

exportXml

exportXml(mapName: string, path: string): void
exportXml(mapName: string, stream: any): void

void exportXml(java.lang.String, java.lang.String)

Parameters 参数
- mapName: string
- path: string
Returns 返回值 void
void exportXml(java.lang.String, java.io.OutputStream)

Parameters 参数
- mapName: string
- stream: any
Returns 返回值 void

getAbsolutePath

getAbsolutePath(): string

java.lang.String getAbsolutePath()

Returns 返回值 string

getBuiltInDocumentProperties

getBuiltInDocumentProperties(): IBuiltInDocumentPropertyCollection

com.aspose.cells.BuiltInDocumentPropertyCollection getBuiltInDocumentProperties()

Returns 返回值 IBuiltInDocumentPropertyCollection

getColors

getColors(): IColor[]

com.aspose.cells.Color[] getColors()

Returns 返回值 IColor[]

getContentTypeProperties

getContentTypeProperties(): IContentTypePropertyCollection

com.aspose.cells.ContentTypePropertyCollection getContentTypeProperties()

Returns 返回值 IContentTypePropertyCollection

getCountOfStylesInPool

getCountOfStylesInPool(): number

int getCountOfStylesInPool()

Returns 返回值 number

getCustomDocumentProperties

getCustomDocumentProperties(): ICustomDocumentPropertyCollection

com.aspose.cells.CustomDocumentPropertyCollection getCustomDocumentProperties()

Returns 返回值 ICustomDocumentPropertyCollection

getCustomXmlParts

getCustomXmlParts(): ICustomXmlPartCollection

com.aspose.cells.CustomXmlPartCollection getCustomXmlParts()

Returns 返回值 ICustomXmlPartCollection

getDataConnections

getDataConnections(): IExternalConnectionCollection

com.aspose.cells.ExternalConnectionCollection getDataConnections()

Returns 返回值 IExternalConnectionCollection

getDataMashup

getDataMashup(): IDataMashup

com.aspose.cells.DataMashup getDataMashup()

Returns 返回值 IDataMashup

getDataSorter

getDataSorter(): IDataSorter

com.aspose.cells.DataSorter getDataSorter()

Returns 返回值 IDataSorter

getDefaultStyle

getDefaultStyle(): IStyle

com.aspose.cells.Style getDefaultStyle()

Returns 返回值 IStyle

getDigitalSignature

getDigitalSignature(): IDigitalSignatureCollection

com.aspose.cells.DigitalSignatureCollection getDigitalSignature()

Returns 返回值 IDigitalSignatureCollection

getFileFormat

getFileFormat(): number

int getFileFormat()

Returns 返回值 number

getFileName

getFileName(): string

java.lang.String getFileName()

Returns 返回值 string

getFonts

getFonts(): IFont[]

com.aspose.cells.Font[] getFonts()

Returns 返回值 IFont[]

getInterruptMonitor

getInterruptMonitor(): IInterruptMonitor

com.aspose.cells.InterruptMonitor getInterruptMonitor()

Returns 返回值 IInterruptMonitor

getMatchingColor

getMatchingColor(rawColor: IColor): IColor

com.aspose.cells.Color getMatchingColor(com.aspose.cells.Color)

Parameters 参数
- rawColor: IColor
Returns 返回值 IColor

getNamedStyle

getNamedStyle(name: string): IStyle

com.aspose.cells.Style getNamedStyle(java.lang.String)

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

getRibbonXml

getRibbonXml(): string

java.lang.String getRibbonXml()

Returns 返回值 string

getSettings

getSettings(): IWorkbookSettings

com.aspose.cells.WorkbookSettings getSettings()

Returns 返回值 IWorkbookSettings

getStyleInPool

getStyleInPool(index: number): IStyle

com.aspose.cells.Style getStyleInPool(int)

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

getTheme

getTheme(): string

java.lang.String getTheme()

Returns 返回值 string

getThemeColor

getThemeColor(type: number): IColor

com.aspose.cells.Color getThemeColor(int)

Parameters 参数
- type: number
Returns 返回值 IColor

getVbaProject

getVbaProject(): IVbaProject

com.aspose.cells.VbaProject getVbaProject()

Returns 返回值 IVbaProject

getWorksheets

getWorksheets(): IWorksheetCollection

com.aspose.cells.WorksheetCollection getWorksheets()

Returns 返回值 IWorksheetCollection

hasExernalLinks

hasExernalLinks(): boolean

boolean hasExernalLinks()

Returns 返回值 boolean

hasMacro

hasMacro(): boolean

boolean hasMacro()

Returns 返回值 boolean

hasRevisions

hasRevisions(): boolean

boolean hasRevisions()

Returns 返回值 boolean

importXml

importXml(stream: any, sheetName: string, row: number, col: number): void
importXml(url: string, sheetName: string, row: number, col: number): void

void importXml(java.io.InputStream, java.lang.String, int, int)

Parameters 参数
- stream: any
- sheetName: string
- row: number
- col: number
Returns 返回值 void
void importXml(java.lang.String, java.lang.String, int, int)

Parameters 参数
- url: string
- sheetName: string
- row: number
- col: number
Returns 返回值 void

isColorInPalette

isColorInPalette(color: IColor): boolean

boolean isColorInPalette(com.aspose.cells.Color)

Parameters 参数
- color: IColor
Returns 返回值 boolean

isDigitallySigned

isDigitallySigned(): boolean

boolean isDigitallySigned()

Returns 返回值 boolean

isLicensed

isLicensed(): boolean

boolean isLicensed()

Returns 返回值 boolean

isWorkbookProtectedWithPassword

isWorkbookProtectedWithPassword(): boolean

boolean isWorkbookProtectedWithPassword()

Returns 返回值 boolean

parseFormulas

parseFormulas(ignoreError: boolean): void

void parseFormulas(boolean)

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

protect

protect(protectionType: number, password: string): void

void protect(int, java.lang.String)

Parameters 参数
- protectionType: number
- password: string
Returns 返回值 void

protectSharedWorkbook

protectSharedWorkbook(password: string): void

void protectSharedWorkbook(java.lang.String)

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

refreshDynamicArrayFormulas

refreshDynamicArrayFormulas(calculate: boolean): void

void refreshDynamicArrayFormulas(boolean)

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

removeDigitalSignature

removeDigitalSignature(): void

void removeDigitalSignature()

Returns 返回值 void

removeExternalLinks

removeExternalLinks(): void

void removeExternalLinks()

Returns 返回值 void

removeMacro

removeMacro(): void

void removeMacro()

Returns 返回值 void

removeUnusedStyles

removeUnusedStyles(): void

void removeUnusedStyles()

Returns 返回值 void

replace

replace(placeHolder: string, newValue: number): number
replace(placeHolder: string, newValues: string[], isVertical: boolean): number
replace(placeHolder: string, newValues: number[], isVertical: boolean): number
replace(placeHolder: string, newValue: number): number
replace(placeHolder: string, newValue: string): number
replace(placeHolder: string, newValue: string, options: IReplaceOptions): number
replace(intValue: number, newValue: any): number
replace(boolValue: boolean, newValue: any): number
replace(placeHolder: string, newValues: number[], isVertical: boolean): number

int replace(java.lang.String, double)

Parameters 参数
- placeHolder: string
- newValue: number
Returns 返回值 number
int replace(java.lang.String, java.lang.String[], boolean)

Parameters 参数
- placeHolder: string
- newValues: string[]
- isVertical: boolean
Returns 返回值 number
int replace(java.lang.String, int[], boolean)

Parameters 参数
- placeHolder: string
- newValues: number[]
- isVertical: boolean
Returns 返回值 number
int replace(java.lang.String, int)

Parameters 参数
- placeHolder: string
- newValue: number
Returns 返回值 number
int replace(java.lang.String, java.lang.String)

Parameters 参数
- placeHolder: string
- newValue: string
Returns 返回值 number
int replace(java.lang.String, java.lang.String, com.aspose.cells.ReplaceOptions)

Parameters 参数
- placeHolder: string
- newValue: string
- options: IReplaceOptions
Returns 返回值 number
int replace(int, java.lang.Object)

Parameters 参数
- intValue: number
- newValue: any
Returns 返回值 number
int replace(boolean, java.lang.Object)

Parameters 参数
- boolValue: boolean
- newValue: any
Returns 返回值 number
int replace(java.lang.String, double[], boolean)

Parameters 参数
- placeHolder: string
- newValues: number[]
- isVertical: boolean
Returns 返回值 number

save

save(fileName: string, saveOptions: ISaveOptions): void
save(fileName: string, saveFormat: number): void
save(fileName: string): void
save(stream: any, saveFormat: number): void
save(stream: any, saveOptions: ISaveOptions): void
save(stream: Izm1, saveFormat: number): void

void save(java.lang.String, com.aspose.cells.SaveOptions)

Parameters 参数
- fileName: string
- saveOptions: ISaveOptions
Returns 返回值 void
void save(java.lang.String, int)

Parameters 参数
- fileName: string
- saveFormat: number
Returns 返回值 void
void save(java.lang.String)

Parameters 参数
- fileName: string
Returns 返回值 void
void save(java.io.OutputStream, int)

Parameters 参数
- stream: any
- saveFormat: number
Returns 返回值 void
void save(java.io.OutputStream, com.aspose.cells.SaveOptions)

Parameters 参数
- stream: any
- saveOptions: ISaveOptions
Returns 返回值 void
void save(com.aspose.cells.b.a.d.zm, int)

Parameters 参数
- stream: Izm1
- saveFormat: number
Returns 返回值 void

setAbsolutePath

setAbsolutePath(value: string): void

void setAbsolutePath(java.lang.String)

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

setDefaultStyle

setDefaultStyle(value: IStyle): void

void setDefaultStyle(com.aspose.cells.Style)

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

setDigitalSignature

setDigitalSignature(digitalSignatureCollection: IDigitalSignatureCollection): void

void setDigitalSignature(com.aspose.cells.DigitalSignatureCollection)

Parameters 参数
- digitalSignatureCollection: IDigitalSignatureCollection
Returns 返回值 void

setEncryptionOptions

setEncryptionOptions(encryptionType: number, keyLength: number): void

void setEncryptionOptions(int, int)

Parameters 参数
- encryptionType: number
- keyLength: number
Returns 返回值 void

setFileFormat

setFileFormat(value: number): void

void setFileFormat(int)

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

setFileName

setFileName(value: string): void

void setFileName(java.lang.String)

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

setInterruptMonitor

setInterruptMonitor(value: IInterruptMonitor): void

void setInterruptMonitor(com.aspose.cells.InterruptMonitor)

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

setRibbonXml

setRibbonXml(value: string): void

void setRibbonXml(java.lang.String)

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

setThemeColor

setThemeColor(type: number, color: IColor): void

void setThemeColor(int, com.aspose.cells.Color)

Parameters 参数
- type: number
- color: IColor
Returns 返回值 void

unprotect

unprotect(password: string): void

void unprotect(java.lang.String)

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

unprotectSharedWorkbook

unprotectSharedWorkbook(password: string): void

void unprotectSharedWorkbook(java.lang.String)

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

updateLinkedDataSource

updateLinkedDataSource(exteralWorkbooks: IWorkbook[]): void

void updateLinkedDataSource(com.aspose.cells.Workbook[])

Parameters 参数
- exteralWorkbooks: IWorkbook[]
Returns 返回值 void

Hierarchy 层级

Index 目录

Methods 方法

Methods 方法

acceptAllRevisions

Returns 返回值 void

addDigitalSignature

Parameters 参数

digitalSignatureCollection: IDigitalSignatureCollection

Returns 返回值 void

calculateFormula

Parameters 参数

options: ICalculationOptions

Returns 返回值 void

Parameters 参数

ignoreError: boolean

Returns 返回值 void

Parameters 参数

ignoreError: boolean

customFunction: IICustomFunction

Returns 返回值 void

Returns 返回值 void

changePalette

Parameters 参数

color: IColor

index: number

Returns 返回值 void

combine

Parameters 参数

secondWorkbook: IWorkbook

Returns 返回值 void

copy

Parameters 参数

source: IWorkbook

Returns 返回值 void

Parameters 参数

source: IWorkbook

copyOptions: ICopyOptions

Returns 返回值 void

copyTheme

Parameters 参数

source: IWorkbook

Returns 返回值 void

createBuiltinStyle

Parameters 参数

type: number

Returns 返回值 IStyle

createCellsColor

Returns 返回值 ICellsColor

createStyle

Returns 返回值 IStyle

customTheme

Parameters 参数

themeName: string

colors: IColor[]

Returns 返回值 void

dispose

Returns 返回值 void

exportXml

Parameters 参数

mapName: string

path: string

Returns 返回值 void

Parameters 参数

mapName: string

stream: any

Returns 返回值 void

getAbsolutePath

Returns 返回值 string

getBuiltInDocumentProperties

Returns 返回值 IBuiltInDocumentPropertyCollection

getColors

Returns 返回值 IColor[]

getContentTypeProperties

Returns 返回值 IContentTypePropertyCollection

getCountOfStylesInPool

Returns 返回值 number

getCustomDocumentProperties

Returns 返回值 ICustomDocumentPropertyCollection

getCustomXmlParts