[]
        
(Showing Draft Content)

XlsxOpenOptions

Class XlsxOpenOptions

java.lang.Object
com.grapecity.documents.excel.OpenOptionsBase
com.grapecity.documents.excel.XlsxOpenOptions
Direct Known Subclasses:
XlsmOpenOptions, XltxOpenOptions

public class XlsxOpenOptions extends OpenOptionsBase
Option class for opening xlsx file.
  • Constructor Details

    • XlsxOpenOptions

      public XlsxOpenOptions()
      Constructor
  • Method Details

    • getPassword

      public final String getPassword()
      The password for the xlsx file.
    • setPassword

      public final void setPassword(String value)
      The password for the xlsx file.
    • getImportFlags

      public final EnumSet<ImportFlags> getImportFlags()
      Gets the flags on loading data. Default is ImportFlags.NoFlag.
    • setImportFlags

      public final void setImportFlags(EnumSet<ImportFlags> value)
      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.

      True to open workbook in digital signature only mode.Otherwise, use normal mode. The default value is False.

    • 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.

      True to open workbook in digital signature only mode.Otherwise, use normal mode. The default value is False.

    • 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.