GrapeCity.Documents.Excel.IDataOptions

IDataOptions Interface

Represents the options related to data import and data analysis.

This interface provides data-related workbook settings, such as whether Date/Time columns are grouped automatically in PivotTables.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IDataOptions

Public Interface IDataOptions

Examples

IDataOptions dataOptions = workbook.Options.Data;
dataOptions.AutomaticGroupDateTimeInPivotTable = false;
bool automatic = dataOptions.AutomaticGroupDateTimeInPivotTable;

Properties

Name	Description
AutomaticGroupDateTimeInPivotTable	Gets or sets whether Date/Time columns are grouped automatically in PivotTables. This option controls whether Date/Time fields are grouped automatically when they are used in PivotTables.

Name

Description

AutomaticGroupDateTimeInPivotTable

Gets or sets whether Date/Time columns are grouped automatically in PivotTables.

This option controls whether Date/Time fields are grouped automatically when they are used in PivotTables.