[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

ImportFlags

Enum Class ImportFlags

java.lang.Object
java.lang.Enum<ImportFlags>
com.grapecity.documents.excel.ImportFlags
All Implemented Interfaces:
Serializable, Comparable<ImportFlags>, Constable
public enum ImportFlags extends Enum<ImportFlags>
Specifies which parts of a worksheet are imported when a workbook is opened.

Use this enumeration with XlsxOpenOptions.setImportFlags(EnumSet) and similar open options APIs to limit the imported content to specific worksheet aspects, such as cell data, formulas, styles, tables, merged cells, or shapes. Combine multiple values in an EnumSet to import multiple aspects together.


 XlsxOpenOptions options = new XlsxOpenOptions();
 options.setImportFlags(EnumSet.of(ImportFlags.Data, ImportFlags.Formulas));
 EnumSet<ImportFlags> importFlags = options.getImportFlags();

  • Enum Constant Details

    • Data

      public static final ImportFlags Data
      Imports cell values from the worksheet.

    • Formulas

      public static final ImportFlags Formulas
      Imports formulas and their cell values from the worksheet.

    • Table

      public static final ImportFlags Table
      Read the tables.

    • MergeArea

      public static final ImportFlags MergeArea
      Imports merged-cell regions from the worksheet.

    • Style

      public static final ImportFlags Style
      Read the styles.

    • ConditionalFormatting

      public static final ImportFlags ConditionalFormatting
      Imports conditional formatting from the worksheet.

    • DataValidation

      public static final ImportFlags DataValidation
      Imports data validation settings from the worksheet.

    • PivotTable

      public static final ImportFlags PivotTable
      Read the pivot tables.

    • Shapes

      public static final ImportFlags Shapes
      Read all the shapes.

  • Method Details

    • values

      public static ImportFlags[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static ImportFlags valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null