GrapeCity.Documents.Excel.ImportFlags

ImportFlags Enum

Specifies which parts of a worksheet are imported when a workbook is opened.

Use this enumeration with ImportFlags 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 by using a bitwise OR expression to import multiple aspects together.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

[Flags]
public enum ImportFlags

<Flags>
Public Enum ImportFlags

Examples

XlsxOpenOptions options = new XlsxOpenOptions();
options.ImportFlags = ImportFlags.Data | ImportFlags.Formulas;
ImportFlags importFlags = options.ImportFlags;

Fields

Name	Description
ConditionalFormatting	Imports conditional formatting from the worksheet.
Data	Imports cell values from the worksheet.
DataValidation	Imports data validation settings from the worksheet.
Formulas	Imports formulas and their cell values from the worksheet.
MergeArea	Imports merged-cell regions from the worksheet.
NoFlag	No option.
PivotTable	Read the pivot tables.
Shapes	Read all the shapes.
Style	Read the styles.
Table	Read the tables.