[]
Workbook
void
addDataSource(String name,
Object dataSource)
void
void
void
convertBarcodeToPicture(ImageType imageType)
void
dirty()
fromJson(InputStream stream)
fromJson(InputStream stream,
DeserializationOptions deserializationOptions)
fromJson(String json,
DeserializationOptions deserializationOptions)
void
fromSjsJson(InputStream stream)
void
fromSjsJson(InputStream stream,
SjsOpenOptions openOptions)
void
fromSjsJson(String json)
void
fromSjsJson(String json,
SjsOpenOptions openOptions)
generateReport(IWorksheet... worksheets)
boolean
boolean
boolean
ITableStyleCollection
collectionthat is used as the default TableStyle.boolean
boolean
getName()
getNames()
INames
collection that represents the workbook-specified names.IExcelOptions
object that represents some settings to control workbook behavior.getPath()
IPivotCaches
collection that represents all theIPivotTable
caches in the specified workbook.boolean
boolean
boolean
IWorksheets
collectionthat represents all the selected sheets in the specified workbook.boolean
ISlicerCaches
object associated with the workbook.IStyleCollection
collection that represents all thestyles in the specified workbook.ITableStyleCollection
collection object for the currentworkbook that refers to the styles used in the current workbook.getTheme()
IWorksheets
collection that represents all the worksheetsin the specified workbook.WriteProtection
object that provides access to the workbook write protection options.boolean
isEncryptedFile(InputStream fileStream)
boolean
isEncryptedFile(String fileName)
void
open(InputStream fileStream)
void
open(InputStream fileStream,
OpenFileFormat fileFormat)
void
open(InputStream fileStream,
OpenOptionsBase options)
void
open(InputStream fileStream,
String password)
void
open(String fileName,
DeserializationOptions deserializationOptions)
void
open(String fileName,
OpenFileFormat fileFormat)
void
open(String fileName,
OpenOptionsBase options)
void
void
void
processTemplate(CancellationToken cancellationToken)
void
protect()
void
protect(boolean structure)
void
protect(boolean structure,
boolean windows)
void
void
void
void
save(OutputStream outputStream)
void
save(OutputStream fileStream,
SaveFileFormat fileFormat)
void
save(OutputStream fileStream,
SaveOptionsBase options)
void
save(OutputStream outputStream,
String password)
void
void
save(String fileName,
SaveFileFormat fileFormat)
void
save(String fileName,
SaveOptionsBase options)
void
void
setAllowDynamicArray(boolean value)
IRange.setFormula2(String)
to set dynamic array formula.void
void
setAutoParse(boolean value)
void
setAutoRoundValue(boolean value)
void
setCulture(Locale value)
void
setDefaultTableStyle(String value)
ITableStyleCollection
collectionthat is used as the default TableStyle.void
setDeferUpdateDirtyState(boolean value)
void
setEnableCalculation(boolean value)
void
setGraphicsInfo(IGraphicsInfo value)
void
void
void
setReferenceStyle(ReferenceStyle value)
void
setResetAdjacentRangeBorder(boolean value)
void
setShowPivotTableFieldList(boolean value)
void
toJson()
toJson(SerializationOptions serializationOptions)
void
toJson(OutputStream stream)
void
toJson(OutputStream stream,
SerializationOptions serializationOptions)
toSjsJson(SjsSaveOptions options)
void
toSjsJson(OutputStream stream)
void
toSjsJson(OutputStream stream,
SjsSaveOptions options)
void
void
void
updateExcelLink(String name)
void
updateExcelLink(String name,
IWorkbook sourceWorkbook)
void
void
IRange.getFormula2()
to get dynamic array formula.IRange.setFormula2(String)
to set dynamic array formula.IWorksheets
collectionthat represents all the selected sheets in the specified workbook.IExcelOptions
object that represents some settings to control workbook behavior.value
- True to reset the border of adjacent ranges, false otherwise.WriteProtection
object that provides access to the workbook write protection options.The culture must contain both country/region and language. For example:
ITableStyleCollection
collectionthat is used as the default TableStyle.ITableStyleCollection
collectionthat is used as the default TableStyle.INames
collection that represents the workbook-specified names.IPivotCaches
collection that represents all theIPivotTable
caches in the specified workbook.IStyleCollection
collection that represents all thestyles in the specified workbook.ITableStyleCollection
collection object for the currentworkbook that refers to the styles used in the current workbook.IWorksheets
collection that represents all the worksheetsin the specified workbook. This is a read-only Sheets object.ISlicerCaches
object associated with the workbook.json
- the json.json
- the json.deserializationOptions
- the DeserializationOptions
object.stream
- the streamstream
- the streamdeserializationOptions
- the DeserializationOptions
object.serializationOptions
- the SerializationOptions
object.stream
- the output stream.stream
- the output stream.serializationOptions
- the SerializationOptions
object.fileName
- the file name.fileStream
- the input file stream.fileName
- The excel file.fileName
- The specified json file.deserializationOptions
- The json deserialization options.fileName
- The excel file.password
- The password of the file.fileName
- The excel file.options
- The options of opening the file. Possible types:fileName
- The specified file.fileFormat
- The format of the file.fileStream
- The file stream.fileStream
- The file stream.password
- The password of the file.fileStream
- The file stream.options
- The format of opening the file stream. Possible types:fileStream
- The specified file stream.fileFormat
- The format of the file stream.fileName
- The file name.fileName
- The excel file.password
- The password of the file.fileName
- The specified file.options
- The options of saving the file. Possible types:fileName
- The specified file.fileFormat
- The format of the file.outputStream
- The file stream.outputStream
- The file stream.password
- The password of the file.fileStream
- The specified file stream.options
- The options of saving the file stream. Possible types:fileStream
- The specified file stream.fileFormat
- The format of the file stream.structure
- True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets).structure
- True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets).windows
- True to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. This option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac.password
- Password to protect the workbook.password
- Password to protect the workbook.structure
- True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets).password
- Password to protect the workbook.structure
- True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets).windows
- True to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. This option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac.password
- Password to protect the workbook.name
- : the alias name of the data source.dataSource
- : Can be object of ResultSet, Custom object and variable.cancellationToken
- The token to monitor for cancellation requests.CancellationException
- Throws when the CancellationToken
was canceled.IWorkbook
object.worksheets
- IWorksheet collection that need to be processed.IWorkbook
object.options
- Option for opening SpreadJS .sjs file.stream
- The specified file stream.options
- Option for opening SpreadJS .sjs file.stream
- The specified file stream.ImageType
of converted image is ImageType.SVG
.ImageType.EMF
and ImageType.WMF
image types.imageType
- Specify the ImageType
of converted image.UnsupportedOperationException
- If convert to ImageType.EMF
or ImageType.WMF
image type.json
- The JSON string.json
- The JSON string.openOptions
- The open options for opening SpreadJS .sjs file.stream
- The JSON stream.openOptions
- The open options for opening SpreadJS .sjs file.stream
- The JSON stream.
IRange.getFormula2()
to get dynamic array formula.