[]
IWorkbookstatic IFontProviderstatic StringWorkbook()Workbook(WorkbookOptions options) Workbook(String licenseKey,
WorkbookOptions options) static voidstatic voidAddCustomFunction(CustomFunction func,
boolean canOverride) voidaddDataSource(String name,
Object dataSource) voidclone()voidvoidconvertBarcodeToPicture(ImageType imageType) voiddirty()fromJson(InputStream stream) fromJson(InputStream stream,
DeserializationOptions deserializationOptions) fromJson(String json,
DeserializationOptions deserializationOptions) voidfromSjsJson(InputStream stream) voidfromSjsJson(InputStream stream,
SjsOpenOptions openOptions) voidfromSjsJson(String json) voidfromSjsJson(String json,
SjsOpenOptions openOptions) generateReport(IWorksheet... worksheets) booleanbooleanbooleanbooleanbooleanfinal IGraphicsInfogetName()getNames()INames集合。static String[]getNames(InputStream fileStream) static String[]IExcelOptions 对象。getPath()booleanbooleanbooleanfinal IWorksheetsbooleanISlicerCaches 对象。static IJsonSerializergetTheme()static IJsonSerializerstatic IWebRequestHandlerstatic 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) booleanisEncryptedFile(InputStream fileStream) booleanisEncryptedFile(String fileName) final voidopen(InputStream fileStream) voidopen(InputStream fileStream,
OpenFileFormat fileFormat) voidopen(InputStream fileStream,
OpenOptionsBase options) voidopen(InputStream fileStream,
String password) voidopen(String fileName,
DeserializationOptions deserializationOptions) voidopen(String fileName,
OpenFileFormat fileFormat) voidopen(String fileName,
OpenOptionsBase options) voidvoidvoidprocessTemplate(CancellationToken cancellationToken) voidprotect()voidprotect(boolean structure) voidprotect(boolean structure,
boolean windows) voidvoidvoidvoidsave(OutputStream outputStream) voidsave(OutputStream fileStream,
SaveFileFormat fileFormat) voidsave(OutputStream fileStream,
SaveOptionsBase options) voidsave(OutputStream outputStream,
String password) voidvoidsave(String fileName,
SaveFileFormat fileFormat) voidsave(String fileName,
SaveOptionsBase options) voidvoidsetAllowDynamicArray(boolean value) voidvoidsetAutoParse(boolean value) voidsetAutoRoundValue(boolean value) voidsetCulture(Locale value) voidsetDefaultTableStyle(String value) ITableStyleCollection集合中获取。voidsetDeferUpdateDirtyState(boolean value) voidsetEnableCalculation(boolean value) final voidsetGraphicsInfo(IGraphicsInfo value) static voidSetLicenseFile(String licenseFilePath) static voidSetLicenseKey(String key) voidvoidvoidsetReferenceStyle(ReferenceStyle value) voidsetResetAdjacentRangeBorder(boolean value) voidsetShowPivotTableFieldList(boolean value) static voidvoidstatic voidstatic voidsetWebRequestHandler(IWebRequestHandler webRequestHandler) toJson()toJson(SerializationOptions serializationOptions) voidtoJson(OutputStream stream) voidtoJson(OutputStream stream,
SerializationOptions serializationOptions) toSjsJson(SjsSaveOptions options) voidtoSjsJson(OutputStream stream) voidtoSjsJson(OutputStream stream,
SjsSaveOptions options) voidvoidvoidupdateExcelLink(String name) voidupdateExcelLink(String name,
IWorkbook sourceWorkbook) voidvoidoptions - 工作簿选项。重要:对于中国市场的许可证,请使用SetLicenseFile或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7环境变量中设置许可证。
licenseKey - 许可证密钥重要:对于中国市场的许可证,请使用SetLicenseFile或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7环境变量中设置许可证。
licenseKey - 许可证密钥options - 工作簿选项。getAllowDynamicArray in interface IWorkbooksetAllowDynamicArray in interface IWorkbookgetDeferUpdateDirtyState in interface IWorkbooksetDeferUpdateDirtyState in interface IWorkbookgetFullName in interface IWorkbookgetAfterSaveEvent in interface IWorkbookgetBeforeSaveEvent in interface IWorkbookgetNewSheetEvent in interface IWorkbookgetOpenedEvent in interface IWorkbookgetSheetActivateEvent in interface IWorkbookgetSheetBeforeDeleteEvent in interface IWorkbookgetSheetChangeEvent in interface IWorkbookgetSheetDeactivateEvent in interface IWorkbookgetSheetSelectionChange in interface IWorkbookIExcelOptions 对象。getOptions in interface IWorkbookgetBuiltInDocumentProperties in interface IWorkbookgetCustomDocumentProperties in interface IWorkbookgetCustomViews in interface IWorkbookgetWriteProtection in interface IWorkbookgetSignatures in interface IWorkbookvalue - 标签自定义类型的JSON序列化器。value - 自定义类型的JSON序列化器。getAutoParse in interface IWorkbooksetAutoParse in interface IWorkbookgetAutoRoundValue in interface IWorkbooksetAutoRoundValue in interface IWorkbookgetBookView in interface IWorkbookgetProtectStructure in interface IWorkbookgetProtectWindows in interface IWorkbookgetReferenceStyle in interface IWorkbooksetReferenceStyle in interface IWorkbookgetWorksheets in interface IWorkbookgetSheetTabs in interface IWorkbookISheetTabs 的实例,表示工作表选项卡的集合。getActiveSheet in interface IWorkbookgetIconSets in interface IWorkbookgetDefaultTableStyle in interface IWorkbookITableStyleCollection集合中获取。setDefaultTableStyle in interface IWorkbookgetCulture in interface IWorkbook区域信息必须同时包含国家和语言。例如:
setCulture in interface IWorkbookgetEnableCalculation in interface IWorkbooksetEnableCalculation in interface IWorkbookfunc - 自定义函数实例。func - 自定义函数实例。canOverride - 是否覆盖现有函数。getPivotCaches in interface IWorkbookISlicerCaches 对象。getSlicerCaches in interface IWorkbookgetUsedFonts in interface IWorkbookgetTableStyles in interface IWorkbookINames集合。isEncryptedFile in interface IWorkbookfileName - 文件名。isEncryptedFile in interface IWorkbookfileStream - 文件流。toJson in interface IWorkbookserializationOptions - SerializationOptions对象。toJson in interface IWorkbookstream - 输出流。serializationOptions - SerializationOptions对象。fromJson in interface IWorkbookjson - JSON字符串。deserializationOptions - DeserializationOptions 对象。fromJson in interface IWorkbookstream - 流的参数deserializationOptions - DeserializationOptions对象。fromSjsJson in interface IWorkbookjson - JSON字符串。fromSjsJson in interface IWorkbookjson - JSON字符串。openOptions - 打开SpreadJS .sjs文件时的打开选项。fromSjsJson in interface IWorkbookstream - JSON流。waitForCalculationToFinish in interface IWorkbookwebRequestHandler - IWebRequestHandler的新单例实例fromSjsJson in interface IWorkbookstream - JSON流。openOptions - 打开SpreadJS .sjs文件的打开选项。addDataSource in interface IWorkbookname - :数据源的别名dataSource - :可以是ResultSet对象、自定义对象和变量。processTemplate in interface IWorkbookprocessTemplate in interface IWorkbookcancellationToken - 用于监控取消请求的令牌。CancellationException - 当CancellationToken被取消时抛出。generateReport in interface IWorkbookIWorkbook 对象。generateReport in interface IWorkbookworksheets - 需要处理的工作表集合。IWorkbook 对象。getResetAdjacentRangeBorder in interface IWorkbooksetResetAdjacentRangeBorder in interface IWorkbookvalue - True 表示重置相邻范围的边界,False 表示否。重要:对于中国市场许可证,请使用SetLicenseFile或在GCEXCEL_JAVA_DEPLOY_LICENSE_V7环境变量中设置许可证。
key - 许可证密钥。如果您的许可证是从其他市场购买的,则不应调用此方法。
licenseFilePath - 包含许可证键的文件getGraphicsInfo in interface IWorkbooksetGraphicsInfo in interface IWorkbookgetSelectedSheets in interface IWorkbookgetExcelLinkSources in interface IWorkbookupdateExcelLinks in interface IWorkbookupdateExcelLink in interface IWorkbookupdateExcelLink in interface IWorkbookfileName - 文件的路径和名称。fileStream - 工作簿的文件流。fileName - 文件的路径和名称。sourceName - 数据源的名称。源名称可能是:fileName - 文件的路径和名称。worksheetName - 工作表名称。row - 范围的起始行。column - 范围的起始列。rowCount - 行数。columnCount - 列数。fileStream - 工作簿的fileStream。sourceName - 源数据的名称。源名称可能是:fileStream - 工作簿的文件流。worksheetName - 工作表名称。row - 范围的起始行。column - 范围的起始列。rowCount - 行的数量。columnCount - 列的数量。convertBarcodeToPicture in interface IWorkbookconvertBarcodeToPicture in interface IWorkbookimageType - 指定转换后图像的 ImageType。UnsupportedOperationException - 如果转换到 ImageType.EMF 或 ImageType.WMF 图像类型时。getShowPivotTableFieldList in interface IWorkbooksetShowPivotTableFieldList in interface IWorkbook
open(InputStream,OpenOptionsBase)替代。