Cells.ClearRange

ClearRange(CellArea)

Clears contents and formatting of a range.

public void ClearRange(CellArea range)

Parameter	Type	Description
range	CellArea	Range to be cleared.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

    public class CellsMethodClearRangeWithCellAreaDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Populate cells with sample data
            for (int row = 0; row <= 2; row++)
            {
                for (int col = 0; col <= 2; col++)
                {
                    worksheet.Cells[row, col].Value = $"Data_{row}_{col}";
                }
            }

            // Define the CellArea to clear (rows 0-2, columns 0-2)
            CellArea clearArea = new CellArea();
            clearArea.StartRow = 0;
            clearArea.EndRow = 2;
            clearArea.StartColumn = 0;
            clearArea.EndColumn = 2;

            try
            {
                // Clear the specified range
                worksheet.Cells.ClearRange(clearArea);
                Console.WriteLine("Cleared cells in range: Rows 0-2, Columns 0-2");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error executing ClearRange method: {ex.Message}");
            }

            // Save the result
            workbook.Save("CellsMethodClearRangeWithCellAreaDemo.xlsx");
        }
    }
}

See Also

• struct CellArea
• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells

---

ClearRange(int, int, int, int)

Clears contents and formatting of a range.

public void ClearRange(int startRow, int startColumn, int endRow, int endColumn)

Parameter	Type	Description
startRow	Int32	Start row index.
startColumn	Int32	Start column index.
endRow	Int32	End row index.
endColumn	Int32	End column index.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsMethodClearRangeWithInt32Int32Int32Int32Demo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Cells cells = workbook.Worksheets[0].Cells;

            // Populate some test data
            cells[0, 0].PutValue(1);
            cells[0, 16383].PutValue(2);
            cells[1048575, 0].PutValue(3);
            cells[1048575, 16383].PutValue(4);

            // Clear the entire worksheet range
            cells.ClearRange(0, 0, 1048575, 16383);

            // Save the workbook
            workbook.Save("ClearRangeDemo.xlsx");

            Console.WriteLine("ClearRange demo executed successfully.");
        }
    }
}

See Also

• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells