Options Property

Options

Declaration

IExcelOptions Options { get; }

ReadOnly Property Options As IExcelOptions

Examples

IWorksheet worksheet = workbook.Worksheets[0];
IExcelOptions options = workbook.Options;
options.Formulas.EnableIterativeCalculation = true;
options.Formulas.MaximumIterations = 3;
options.Data.AutomaticGroupDateTimeInPivotTable = false;
worksheet.Range["A1"].Value = 1000;
worksheet.Range["A2"].Formula = "(A1+A2)/10";
workbook.Calculate();
object iterativeResult = worksheet.Range["A2"].Value;
bool automaticGrouping = options.Data.AutomaticGroupDateTimeInPivotTable;