CellWatchCollection.Add

Add(int, int)

Adds CellWatch with row and column.

public int Add(int row, int column)
ParameterTypeDescription
rowInt32The row index.
columnInt32The column index.

Return Value

Returns the position of this item in the collection.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

    public class CellWatchCollectionMethodAddWithInt32Int32Demo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Get the CellWatchCollection from the worksheet
            CellWatchCollection cellWatchCollection = worksheet.CellWatches;
            
            try
            {
                // Call the Add method with row and column indices (Int32, Int32)
                int index = cellWatchCollection.Add(5, 3); // Adding cell at row 6, column D (0-based)
                
                Console.WriteLine($"CellWatch added at index: {index}");
                
                // Verify the added cell watch
                CellWatch cellWatch = cellWatchCollection[index];
                Console.WriteLine($"Watching cell: {cellWatch.Row},{cellWatch.Column}");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error executing Add method: {ex.Message}");
            }
            
            // Save the result
            workbook.Save("CellWatchCollectionMethodAddWithInt32Int32Demo.xlsx");
        }
    }
}

See Also

Add(string)

Adds CellWatch with the name the of cell.

public int Add(string cellName)
ParameterTypeDescription
cellNameStringThe name of the cell.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellWatchCollectionMethodAddWithStringDemo
    {
        public static void Run()
        {
            // Create a workbook
            Workbook workbook = new Workbook();
            
            // Access first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Add some cell watches
            worksheet.CellWatches.Add("A1");
            worksheet.CellWatches.Add("B2");
            worksheet.CellWatches.Add("C3");
            
            // Display count of cell watches
            Console.WriteLine("Cell Watches Count: " + worksheet.CellWatches.Count);
            
            // Save the workbook
            workbook.Save("output.xlsx");
        }
    }
}

See Also