How to Write an Excel File in C#

// Ensure you have installed the IronXL library via NuGet package manager
using IronXL;
using System;

class ExcelManipulation
{
    static void Main()
    {
        // Load the existing Excel file
        var workbook = WorkBook.Load("path_to_your_excel_file.xlsx");

        // Get the first worksheet
        var sheet = workbook.WorkSheets.First();

        // Select a range of cells
        var range = sheet["A1:A10"];

        double total = 0;

        // Iterate through the range and print values
        foreach (var cell in range)
        {
            Console.WriteLine(cell.Value);

            // Add cell value to total if it's numeric
            if (double.TryParse(cell.Value.ToString(), out double number))
            {
                total += number;
            }
        }

        // Validate if the sum of range matches a specific cell's value
        var specificCell = sheet["B1"];
        if (total == Convert.ToDouble(specificCell.Value))
        {
            Console.WriteLine("The sum matches the value in B1.");
        }
        else
        {
            Console.WriteLine("The sum does not match the value in B1.");
        }

        // Modify cell B2 value and save the workbook
        sheet["B2"].Value = 11.54;

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

        Console.WriteLine("Excel file has been modified and saved as 'modified.xlsx'.");
    }
}

' Ensure you have installed the IronXL library via NuGet package manager
Imports IronXL
Imports System

Friend Class ExcelManipulation
	Shared Sub Main()
		' Load the existing Excel file
		Dim workbook = WorkBook.Load("path_to_your_excel_file.xlsx")

		' Get the first worksheet
		Dim sheet = workbook.WorkSheets.First()

		' Select a range of cells
		Dim range = sheet("A1:A10")

		Dim total As Double = 0

		' Iterate through the range and print values
		For Each cell In range
			Console.WriteLine(cell.Value)

			' Add cell value to total if it's numeric
			Dim number As Double
			If Double.TryParse(cell.Value.ToString(), number) Then
				total += number
			End If
		Next cell

		' Validate if the sum of range matches a specific cell's value
		Dim specificCell = sheet("B1")
		If total = Convert.ToDouble(specificCell.Value) Then
			Console.WriteLine("The sum matches the value in B1.")
		Else
			Console.WriteLine("The sum does not match the value in B1.")
		End If

		' Modify cell B2 value and save the workbook
		sheet("B2").Value = 11.54

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

		Console.WriteLine("Excel file has been modified and saved as 'modified.xlsx'.")
	End Sub
End Class