-
com.grapecity.documents.excel
-
- AsyncCustomFunction
- BaseCellType
- ButtonCellType
- CalcReference
- CancellationToken
- CancellationTokenSource
- CellColorSortField
- CellDecoration
- CellDecorationIcon
- CellInfo
- CellPadding
- CheckBoxCellType
- CheckBoxListCellType
- Color
- ColorUtilities
- ComboBoxCellItem
- ComboBoxCellType
- CornerFold
- CsvOpenOptions
- CsvParseContext
- CsvParseResult
- CsvSaveOptions
- CustomBorderStyle
- CustomFunction
- DataImportOptions
- DataImportResult
- DataValidationJsonError
- DateInfo
- DeserializationOptions
- DocumentProperties
- Event
- EventArgs
- FindOptions
- FontColorSortField
- FontInfo
- FormulaJsonError
- HyperLinkCellType
- IconSortField
- ImageSaveOptions
- ImageSource
- JsonError
- Margin
- OpenOptionsBase
- PageContentInfo
- PageInfo
- PagePrintedEventArgs
- PagePrintEventArgs
- PagePrintingEventArgs
- PageSettings
- Parameter
- PasteOption
- PdfSaveOptions
- PdfSecurityOptions
- PivotFilterOptions
- Point
- PrintManager
- RadioButtonListCellType
- RangeEventArgs
- RangeFindReplace
- RangeFindReplace.FindReplaceImpl
- RangePartialClasses
- RangePartialClasses.FindReplaceImpl
- RangeTemplateCellType
- Rectangle
- RepeatSetting
- ReplaceOptions
- SaveOptionsBase
- SelectFieldItem
- SerializationOptions
- SheetEventArgs
- SignatureDetails
- Size
- SjsOpenOptions
- SjsSaveOptions
- SortFieldBase
- SpecialCellsValue
- TableStyleFactory
- TextFormatInfo
- Theme
- Themes
- ThemeStorage
- ValueSortField
- WebRequestResult
- Workbook
- WorkbookOptions
- WriteProtection
- XlsmOpenOptions
- XlsmSaveOptions
- XlsxOpenOptions
- XlsxSaveOptions
- XltxOpenOptions
- XltxSaveOptions
-
- com.grapecity.documents.excel.drawing
- com.grapecity.documents.excel.expressions
- com.grapecity.documents.excel.forms
- com.grapecity.documents.excel.template
- com.grapecity.documents.excel.template.DataSource
XlsxOpenOptions
Class XlsxOpenOptions
- Direct Known Subclasses:
XlsmOpenOptions,XltxOpenOptions
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionfinal booleanGets whether to open the workbook in digital signature only mode.final booleanGets whether to autofit the row height after loading the file.final booleanGets whether to recalculate when getting formula value after loading the file.final EnumSet<ImportFlags>Gets the flags on loading data.final StringThe password for the xlsx file.final voidsetDigitalSignatureOnly(boolean value) Sets whether to open the workbook in digital signature only mode.final voidsetDoNotAutoFitAfterOpened(boolean value) Sets whether to autofit the row height after loading the file.final voidsetDoNotRecalculateAfterOpened(boolean value) Sets whether to recalculate when getting formula value after loading the file.final voidsetImportFlags(EnumSet<ImportFlags> value) Sets the flags on loading data.final voidsetPassword(String value) The password for the xlsx file.Methods inherited from class com.grapecity.documents.excel.OpenOptionsBase
getFileFormat, setFileFormat
-
Constructor Details
-
XlsxOpenOptions
public XlsxOpenOptions()Constructor
-
-
Method Details
-
getPassword
The password for the xlsx file. -
setPassword
The password for the xlsx file. -
getImportFlags
Gets the flags on loading data. Default is ImportFlags.NoFlag. -
setImportFlags
Sets the flags on loading data. Default is ImportFlags.NoFlag. -
getDoNotRecalculateAfterOpened
public final boolean getDoNotRecalculateAfterOpened()Gets whether to recalculate when getting formula value after loading the file.- Returns:
- True if recalculation is disabled; otherwise, false.
-
setDoNotRecalculateAfterOpened
public final void setDoNotRecalculateAfterOpened(boolean value) Sets whether to recalculate when getting formula value after loading the file.- Parameters:
value- True to disable recalculation; false to enable recalculation.
-
getDigitalSignatureOnly
public final boolean getDigitalSignatureOnly()Gets whether to open the workbook in digital signature only mode.In the digital signature only mode, existing signatures will be preserved unless you called
ISignature.Delete. But you can only sign existing signature lines, add invisible signatures, remove digital signature of signed signature lines, or remove invisible signatures in this mode. Other changes will be discarded.After modifying digital signatures, you need to save the workbook to commit changes.
Trueto open workbook in digital signature only mode.Otherwise, use normal mode. The default value isFalse. -
setDigitalSignatureOnly
public final void setDigitalSignatureOnly(boolean value) Sets whether to open the workbook in digital signature only mode.In the digital signature only mode, existing signatures will be preserved unless you called
ISignature.Delete. But you can only sign existing signature lines, add invisible signatures, remove digital signature of signed signature lines, or remove invisible signatures in this mode. Other changes will be discarded.After modifying digital signatures, you need to save the workbook to commit changes.
Trueto open workbook in digital signature only mode.Otherwise, use normal mode. The default value isFalse. -
getDoNotAutoFitAfterOpened
public final boolean getDoNotAutoFitAfterOpened()Gets whether to autofit the row height after loading the file.- Returns:
- True if auto-fitting row height is disabled; otherwise, false.
-
setDoNotAutoFitAfterOpened
public final void setDoNotAutoFitAfterOpened(boolean value) Sets whether to autofit the row height after loading the file.- Parameters:
value- True to disable auto-fitting row height; false to enable auto-fitting.
-