ErrorCheckOptionCollection.Item

ErrorCheckOptionCollection indexer

Gets ErrorCheckOption object by the given index.

public ErrorCheckOption this[int index] { get; }
ParameterDescription
indexThe index

Return Value

Return ErrorCheckOption object

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class ErrorCheckOptionCollectionPropertyItemDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            ErrorCheckOptionCollection opts = worksheet.ErrorCheckOptions;
            int optionIdx = opts.Add();
            
            // Demonstrate Item property usage
            ErrorCheckOption opt = opts[optionIdx];
            
            opt.SetErrorCheck(ErrorCheckType.TextNumber, false);
            opt.AddRange(CellArea.CreateCellArea("A1", "B3"));

            workbook.Save("ErrorCheckOptionDemo.xlsx");
        }
    }
}

See Also