C# Write to Excel [Without Using Interop] Code Example Tutorial

using IronXL;

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

// Get the default worksheet from the workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Define a range of cells from A2 to A8 in the worksheet.
IronXL.Range range = workSheet["A2:A8"];

// Initialize a variable to keep track of the total sum of numeric values in the range.
decimal total = 0;

// Iterate over each cell in the defined range.
foreach (var cell in range)
{
    // Print out the row index and value of each cell.
    Console.WriteLine("Cell {0} has value '{1}'", cell.RowIndex, cell.Text);

    // Check if the cell contains a numeric value.
    if (cell.IsNumeric)
    {
        // Add the cell's numeric value to the total. 
        // Using DecimalValue to avoid floating point precision issues.
        total += cell.DecimalValue;
    }
}

// Check if a cell (A11) contains the same total as calculated from the range.
// This line assumes A11 is supposed to have a sum formula or manually set value that equals the sum of A2:A8.
// Ensure A11 has a numeric value before accessing its DecimalValue.
if (workSheet["A11"].IsNumeric && workSheet["A11"].DecimalValue == total)
{
    // Print a success message if the calculated total matches the value in A11.
    Console.WriteLine("Basic Test Passed");
}

Imports IronXL



' Load the workbook from an Excel file.

Private workBook As WorkBook = WorkBook.Load("test.xlsx")



' Get the default worksheet from the workbook.

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Define a range of cells from A2 to A8 in the worksheet.

Private range As IronXL.Range = workSheet("A2:A8")



' Initialize a variable to keep track of the total sum of numeric values in the range.

Private total As Decimal = 0



' Iterate over each cell in the defined range.

For Each cell In range

	' Print out the row index and value of each cell.

	Console.WriteLine("Cell {0} has value '{1}'", cell.RowIndex, cell.Text)



	' Check if the cell contains a numeric value.

	If cell.IsNumeric Then

		' Add the cell's numeric value to the total. 

		' Using DecimalValue to avoid floating point precision issues.

		total += cell.DecimalValue

	End If

Next cell



' Check if a cell (A11) contains the same total as calculated from the range.

' This line assumes A11 is supposed to have a sum formula or manually set value that equals the sum of A2:A8.

' Ensure A11 has a numeric value before accessing its DecimalValue.

If workSheet("A11").IsNumeric AndAlso workSheet("A11").DecimalValue = total Then

	' Print a success message if the calculated total matches the value in A11.

	Console.WriteLine("Basic Test Passed")

End If

// The following code snippet demonstrates how to set a cell value in an Excel worksheet
// and then save the workbook as a new file named "test.xlsx".
// Ensure you have the necessary library references and using directives 
// for interacting with Excel files, such as using a library like EPPlus or ClosedXML.

// Assuming 'workSheet' is an initialized variable representing the worksheet where we want to set the value.
// Example: var workSheet = package.Workbook.Worksheets.Add("Sheet1");
// Assuming 'workBook' is an initialized variable representing the workbook that contains the worksheet.
// Example: var workBook = new ExcelPackage().Workbook;

// Set the value of cell B1 in the worksheet to 11.54
workSheet.Cells["B1"].Value = 11.54;

// Save the current workbook to a new file named "test.xlsx"
workBook.SaveAs(new FileInfo("test.xlsx"));

// Note: Ensure to handle any necessary disposal of resources and exception handling as per your application's need.

' The following code snippet demonstrates how to set a cell value in an Excel worksheet

' and then save the workbook as a new file named "test.xlsx".

' Ensure you have the necessary library references and using directives 

' for interacting with Excel files, such as using a library like EPPlus or ClosedXML.



' Assuming 'workSheet' is an initialized variable representing the worksheet where we want to set the value.

' Example: var workSheet = package.Workbook.Worksheets.Add("Sheet1");

' Assuming 'workBook' is an initialized variable representing the workbook that contains the worksheet.

' Example: var workBook = new ExcelPackage().Workbook;



' Set the value of cell B1 in the worksheet to 11.54

workSheet.Cells("B1").Value = 11.54



' Save the current workbook to a new file named "test.xlsx"

workBook.SaveAs(New FileInfo("test.xlsx"))



' Note: Ensure to handle any necessary disposal of resources and exception handling as per your application's need.

using IronXL;

var workbook = WorkBook.Load("example.xlsx");
var sheet = workbook.DefaultWorkSheet;
Console.WriteLine(sheet["A1"].Text);

Imports IronXL



Private workbook = WorkBook.Load("example.xlsx")

Private sheet = workbook.DefaultWorkSheet

Console.WriteLine(sheet("A1").Text)