[]
IWorkbook
static IFontProvider
static String
Workbook()
Workbook(WorkbookOptions options)
Workbook(String licenseKey,
WorkbookOptions options)
static void
static void
AddCustomFunction(CustomFunction func,
boolean canOverride)
void
addDataSource(String name,
Object dataSource)
void
clone()
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
boolean
boolean
final IGraphicsInfo
getName()
getNames()
INames
集合。static String[]
getNames(InputStream fileStream)
static String[]
IExcelOptions
对象。getPath()
boolean
boolean
boolean
final IWorksheets
boolean
ISlicerCaches
对象。static IJsonSerializer
getTheme()
static IJsonSerializer
static IWebRequestHandler
static Object[][]
importData(InputStream fileStream,
String sourceName)
static Object[][]
importData(InputStream fileStream,
String worksheetName,
int row,
int column,
int rowCount,
int columnCount)
static Object[][]
importData(String fileName,
String sourceName)
static Object[][]
importData(String fileName,
String worksheetName,
int row,
int column,
int rowCount,
int columnCount)
boolean
isEncryptedFile(InputStream fileStream)
boolean
isEncryptedFile(String fileName)
final 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)
void
void
setAutoParse(boolean value)
void
setAutoRoundValue(boolean value)
void
setCulture(Locale value)
void
setDefaultTableStyle(String value)
ITableStyleCollection
集合中获取。void
setDeferUpdateDirtyState(boolean value)
void
setEnableCalculation(boolean value)
final void
setGraphicsInfo(IGraphicsInfo value)
static void
SetLicenseFile(String licenseFilePath)
static void
SetLicenseKey(String key)
void
void
void
setReferenceStyle(ReferenceStyle value)
void
setResetAdjacentRangeBorder(boolean value)
void
setShowPivotTableFieldList(boolean value)
static void
void
static void
static void
setWebRequestHandler(IWebRequestHandler webRequestHandler)
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
options
- 工作簿选项。重要:对于中国市场的许可证,请使用SetLicenseFile
或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7
环境变量中设置许可证。
licenseKey
- 许可证密钥重要:对于中国市场的许可证,请使用SetLicenseFile
或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7
环境变量中设置许可证。
licenseKey
- 许可证密钥options
- 工作簿选项。getAllowDynamicArray
in interface IWorkbook
setAllowDynamicArray
in interface IWorkbook
getDeferUpdateDirtyState
in interface IWorkbook
setDeferUpdateDirtyState
in interface IWorkbook
getFullName
in interface IWorkbook
getAfterSaveEvent
in interface IWorkbook
getBeforeSaveEvent
in interface IWorkbook
getNewSheetEvent
in interface IWorkbook
getOpenedEvent
in interface IWorkbook
getSheetActivateEvent
in interface IWorkbook
getSheetBeforeDeleteEvent
in interface IWorkbook
getSheetChangeEvent
in interface IWorkbook
getSheetDeactivateEvent
in interface IWorkbook
getSheetSelectionChange
in interface IWorkbook
IExcelOptions
对象。getOptions
in interface IWorkbook
getBuiltInDocumentProperties
in interface IWorkbook
getCustomDocumentProperties
in interface IWorkbook
getCustomViews
in interface IWorkbook
getWriteProtection
in interface IWorkbook
getSignatures
in interface IWorkbook
value
- 标签自定义类型的JSON序列化器。value
- 自定义类型的JSON序列化器。getAutoParse
in interface IWorkbook
setAutoParse
in interface IWorkbook
getAutoRoundValue
in interface IWorkbook
setAutoRoundValue
in interface IWorkbook
getBookView
in interface IWorkbook
getProtectStructure
in interface IWorkbook
getProtectWindows
in interface IWorkbook
getReferenceStyle
in interface IWorkbook
setReferenceStyle
in interface IWorkbook
getWorksheets
in interface IWorkbook
getActiveSheet
in interface IWorkbook
getIconSets
in interface IWorkbook
getDefaultTableStyle
in interface IWorkbook
ITableStyleCollection
集合中获取。setDefaultTableStyle
in interface IWorkbook
getCulture
in interface IWorkbook
区域信息必须同时包含国家和语言。例如:
setCulture
in interface IWorkbook
getEnableCalculation
in interface IWorkbook
setEnableCalculation
in interface IWorkbook
func
- 自定义函数实例。func
- 自定义函数实例。canOverride
- 是否覆盖现有函数。getPivotCaches
in interface IWorkbook
ISlicerCaches
对象。getSlicerCaches
in interface IWorkbook
getUsedFonts
in interface IWorkbook
getTableStyles
in interface IWorkbook
INames
集合。isEncryptedFile
in interface IWorkbook
fileName
- 文件名。isEncryptedFile
in interface IWorkbook
fileStream
- 文件流。toJson
in interface IWorkbook
serializationOptions
- SerializationOptions
对象。toJson
in interface IWorkbook
stream
- 输出流。serializationOptions
- SerializationOptions
对象。fromJson
in interface IWorkbook
json
- JSON字符串。deserializationOptions
- DeserializationOptions
对象。fromJson
in interface IWorkbook
stream
- 流的参数deserializationOptions
- DeserializationOptions
对象。fromSjsJson
in interface IWorkbook
json
- JSON字符串。fromSjsJson
in interface IWorkbook
json
- JSON字符串。openOptions
- 打开SpreadJS .sjs文件时的打开选项。fromSjsJson
in interface IWorkbook
stream
- JSON流。waitForCalculationToFinish
in interface IWorkbook
webRequestHandler
- IWebRequestHandler的新单例实例fromSjsJson
in interface IWorkbook
stream
- JSON流。openOptions
- 打开SpreadJS .sjs文件的打开选项。addDataSource
in interface IWorkbook
name
- :数据源的别名dataSource
- :可以是ResultSet对象、自定义对象和变量。processTemplate
in interface IWorkbook
processTemplate
in interface IWorkbook
cancellationToken
- 用于监控取消请求的令牌。CancellationException
- 当CancellationToken
被取消时抛出。generateReport
in interface IWorkbook
IWorkbook
对象。generateReport
in interface IWorkbook
worksheets
- 需要处理的工作表集合。IWorkbook
对象。getResetAdjacentRangeBorder
in interface IWorkbook
setResetAdjacentRangeBorder
in interface IWorkbook
value
- True 表示重置相邻范围的边界,False 表示否。重要:对于中国市场许可证,请使用SetLicenseFile
或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7
环境变量中设置许可证。
key
- 许可证密钥。如果您的许可证是从其他市场购买的,则不应调用此方法。
licenseFilePath
- 包含许可证键的文件getGraphicsInfo
in interface IWorkbook
setGraphicsInfo
in interface IWorkbook
getSelectedSheets
in interface IWorkbook
getExcelLinkSources
in interface IWorkbook
updateExcelLinks
in interface IWorkbook
updateExcelLink
in interface IWorkbook
updateExcelLink
in interface IWorkbook
fileName
- 文件的路径和名称。fileStream
- 工作簿的文件流。fileName
- 文件的路径和名称。sourceName
- 数据源的名称。源名称可能是:fileName
- 文件的路径和名称。worksheetName
- 工作表名称。row
- 范围的起始行。column
- 范围的起始列。rowCount
- 行数。columnCount
- 列数。fileStream
- 工作簿的fileStream。sourceName
- 源数据的名称。源名称可能是:fileStream
- 工作簿的文件流。worksheetName
- 工作表名称。row
- 范围的起始行。column
- 范围的起始列。rowCount
- 行的数量。columnCount
- 列的数量。convertBarcodeToPicture
in interface IWorkbook
convertBarcodeToPicture
in interface IWorkbook
imageType
- 指定转换后图像的 ImageType
。UnsupportedOperationException
- 如果转换到 ImageType.EMF
或 ImageType.WMF
图像类型时。getShowPivotTableFieldList
in interface IWorkbook
setShowPivotTableFieldList
in interface IWorkbook
open(InputStream,OpenOptionsBase)
替代。