How to Clear Cells

using IronXL;

// This line of code loads an existing Excel workbook named "sample.xlsx"
// into a WorkBook object, allowing you to manipulate the workbook's contents.
WorkBook workBook = WorkBook.Load("sample.xlsx");

// This line retrieves a worksheet named "Data" from the WorkBook object.
// It creates a WorkSheet object representing the "Data" worksheet 
// for subsequent operations.
WorkSheet workSheet = workBook.GetWorkSheet("Data");

// Clears the content of cell A1 in the "Data" worksheet.
// This method ensures that the specific cell is emptied of any existing data or formula.
workSheet["A1"].ClearContents();

// Saves the modified workbook to a new file named "clearSingleCell.xlsx".
// This stores the changes made to the workbook, such as the cleared cell, to a new file.
workBook.SaveAs("clearSingleCell.xlsx");

Imports IronXL

' This line of code loads an existing Excel workbook named "sample.xlsx"
' into a WorkBook object, allowing you to manipulate the workbook's contents.
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' This line retrieves a worksheet named "Data" from the WorkBook object.
' It creates a WorkSheet object representing the "Data" worksheet 
' for subsequent operations.
Private workSheet As WorkSheet = workBook.GetWorkSheet("Data")

' Clears the content of cell A1 in the "Data" worksheet.
' This method ensures that the specific cell is emptied of any existing data or formula.
workSheet("A1").ClearContents()

' Saves the modified workbook to a new file named "clearSingleCell.xlsx".
' This stores the changes made to the workbook, such as the cleared cell, to a new file.
workBook.SaveAs("clearSingleCell.xlsx")

using IronXL;

// Load the workbook from the specified Excel file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the worksheet named "Data" from the workbook
WorkSheet workSheet = workBook.GetWorkSheet("Data");

// Clear the contents of a single cell (A1)
workSheet["A1"].ClearContents();

// Clear the contents of the entire column (B)
workSheet.GetColumn("B").ClearContents();

// Clear the contents of the entire row (4)
// Note: Row indices are zero-based, so 3 corresponds to the 4th row
workSheet.GetRow(3).ClearContents();

// Clear the contents of a two-dimensional range (D6:F9)
workSheet["D6:F9"].ClearContents();

// Save the modified workbook to a new Excel file
workBook.SaveAs("clearCellRange.xlsx");

Imports IronXL

' Load the workbook from the specified Excel file
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Get the worksheet named "Data" from the workbook
Private workSheet As WorkSheet = workBook.GetWorkSheet("Data")

' Clear the contents of a single cell (A1)
workSheet("A1").ClearContents()

' Clear the contents of the entire column (B)
workSheet.GetColumn("B").ClearContents()

' Clear the contents of the entire row (4)
' Note: Row indices are zero-based, so 3 corresponds to the 4th row
workSheet.GetRow(3).ClearContents()

' Clear the contents of a two-dimensional range (D6:F9)
workSheet("D6:F9").ClearContents()

' Save the modified workbook to a new Excel file
workBook.SaveAs("clearCellRange.xlsx")

using IronXL;

// This code demonstrates how to load an Excel workbook, clear all worksheets within it, and save the modified workbook.

// Load the workbook from a specified Excel file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Clear all worksheets from the workbook
// This removes all sheets within the workbook, leaving it empty.
workBook.WorkSheets.Clear();

// Save the modified (cleared) workbook to a new file
workBook.SaveAs("useClear.xlsx");

Imports IronXL

' This code demonstrates how to load an Excel workbook, clear all worksheets within it, and save the modified workbook.

' Load the workbook from a specified Excel file
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Clear all worksheets from the workbook
' This removes all sheets within the workbook, leaving it empty.
workBook.WorkSheets.Clear()

' Save the modified (cleared) workbook to a new file
workBook.SaveAs("useClear.xlsx")