How to Write to Excel Files in .NET with C#

// Ensure you have installed IronXL via NuGet package manager before running this code.
using IronXL;

namespace ExcelTutorial
{
    class Program
    {
        static void Main(string[] args)
        {
            // Step 1: Load the Excel workbook
            WorkBook workbook = WorkBook.Load("sample.xlsx");
            WorkSheet sheet = workbook.DefaultWorkSheet;

            // Step 2: Write a value to cell A1
            sheet["A1"].Value = "Hello, Excel!";
            workbook.SaveAs("sample1.xlsx");

            // Step 3: Write values to a specified range B2 to B9
            for (int i = 2; i <= 9; i++)
            {
                sheet[$"B{i}"].Value = $"Value {i}";
            }
            workbook.SaveAs("sample2.xlsx");

            // Step 4: Dynamic value insertion using a for loop across a specified range C3 to C7
            for (int i = 3; i <= 7; i++)
            {
                sheet[$"C{i}"].Value = i * 10; // Example: set cell C3 to C7 with multiples of 10
            }
            workbook.SaveAs("sample3.xlsx");

            // Step 5: Replace all occurrences of a specific text throughout the worksheet
            sheet.ReplaceText("Hello", "Hi");
            workbook.SaveAs("sample4.xlsx");

            // Additional dynamic text replacement in specific range, if needed
            // (Assume we want to replace 'Value' to 'Data' from cells B2 to B9)
            for (int i = 2; i <= 9; i++)
            {
                if (sheet[$"B{i}"].Value.ToString().Contains("Value"))
                {
                    sheet[$"B{i}"].Value = sheet[$"B{i}"].Value.ToString().Replace("Value", "Data");
                }
            }
            // Save again if desired after this operation
            // workbook.SaveAs("sample5.xlsx");
        }
    }
}

' Ensure you have installed IronXL via NuGet package manager before running this code.
Imports IronXL

Namespace ExcelTutorial
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			' Step 1: Load the Excel workbook
			Dim workbook As WorkBook = WorkBook.Load("sample.xlsx")
			Dim sheet As WorkSheet = workbook.DefaultWorkSheet

			' Step 2: Write a value to cell A1
			sheet("A1").Value = "Hello, Excel!"
			workbook.SaveAs("sample1.xlsx")

			' Step 3: Write values to a specified range B2 to B9
			For i As Integer = 2 To 9
				sheet($"B{i}").Value = $"Value {i}"
			Next i
			workbook.SaveAs("sample2.xlsx")

			' Step 4: Dynamic value insertion using a for loop across a specified range C3 to C7
			For i As Integer = 3 To 7
				sheet($"C{i}").Value = i * 10 ' Example: set cell C3 to C7 with multiples of 10
			Next i
			workbook.SaveAs("sample3.xlsx")

			' Step 5: Replace all occurrences of a specific text throughout the worksheet
			sheet.ReplaceText("Hello", "Hi")
			workbook.SaveAs("sample4.xlsx")

			' Additional dynamic text replacement in specific range, if needed
			' (Assume we want to replace 'Value' to 'Data' from cells B2 to B9)
			For i As Integer = 2 To 9
				If sheet($"B{i}").Value.ToString().Contains("Value") Then
					sheet($"B{i}").Value = sheet($"B{i}").Value.ToString().Replace("Value", "Data")
				End If
			Next i
			' Save again if desired after this operation
			' workbook.SaveAs("sample5.xlsx");
		End Sub
	End Class
End Namespace