[]
Represents options for processing Excel workbooks.
This interface provides access to workbook-level settings that control Excel behavior, such as formula-related options and data-related options.
public interface IExcelOptions
Public Interface IExcelOptions
IExcelOptions options = workbook.Options;
options.Formulas.EnableIterativeCalculation = true;
options.Data.AutomaticGroupDateTimeInPivotTable = false;
| Name | Description |
|---|---|
| Data | Gets options related to Excel data processing. Returns an IDataOptions object that provides settings for data import and data analysis. |
| Formulas | Gets the formula-related options. |