[]
This class inherits the XLSX-related save settings provided by XlsxSaveOptions, such as password protection, formula handling, shared formula export, and excluding unused content, and uses SaveFileFormat.Xlsm as the target format.
XlsmSaveOptions options = new XlsmSaveOptions();
String password = getWorkbookPassword();
options.setPassword(password);
options.setIgnoreFormulas(true);
workbook.save("path/to/output.xlsm", options);
getExcludeEmptyRegionCells, getExcludeUnusedNames, getExcludeUnusedStyles, getExportSharedFormula, getIgnoreFormulas, getIncludeAutoMergedCells, getIncludeBindingSource, getIsCompactMode, getPassword, setExcludeEmptyRegionCells, setExcludeUnusedNames, setExcludeUnusedStyles, setExportSharedFormula, setIgnoreFormulas, setIncludeAutoMergedCells, setIncludeBindingSource, setIsCompactMode, setPassword, toStringgetFileFormat, setFileFormatXlsmSaveOptions object.Creates save options for exporting a workbook as an XLSM file. The file format is initialized to SaveFileFormat.Xlsm, and the returned options object can be further configured and passed to Workbook.save(String,SaveOptionsBase).
XlsmSaveOptions options = new XlsmSaveOptions();
String password = getWorkbookPassword();
options.setPassword(password);
workbook.save("path/to/file.xlsm", options);