[]
此类继承 XlsxOpenOptions 提供的 XLSX 打开选项设置,例如密码、导入标志、重新计算行为、行自动调整行为和仅数字签名模式,并使用 OpenFileFormat.Xlsm 作为目标格式。
XlsmOpenOptions options = new XlsmOpenOptions();
String password = getWorkbookPassword();
options.setPassword(password);
workbook.open("path/to/workbook.xlsm", options);
getDigitalSignatureOnly, getDoNotAutoFitAfterOpened, getDoNotRecalculateAfterOpened, getImportFlags, getInvalidFormulaHandling, getPassword, setDigitalSignatureOnly, setDoNotAutoFitAfterOpened, setDoNotRecalculateAfterOpened, setImportFlags, setInvalidFormulaHandling, setPasswordgetFileFormat, setFileFormatXlsmOpenOptions 对象。此构造函数创建用于打开 XLSM 工作簿的选项对象,并将文件格式设置为 OpenFileFormat.Xlsm。
XlsmOpenOptions options = new XlsmOpenOptions();
String password = getWorkbookPassword();
options.setPassword(password);
workbook.open("path/to/workbook.xlsm", options);