How to Write Data to Excel File in C#

A detailed guide on how to write data to an Excel file in C# using the EPPlus library, making it easy to store and manage data in Excel spreadsheets.

In this guide, we will use the EPPlus library to write data to an Excel file. This library allows us to create, edit, and save data to Excel files effortlessly using C#.

Step 1: Install the EPPlus Library

First, install the EPPlus library via NuGet Package Manager. Run the following command in the Package Manager Console:

Install-Package EPPlus

Step 2: Write C# Code to Write Data to Excel File

using OfficeOpenXml;
using System.IO;

namespace ExcelWriteExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // Define the path to the Excel file
            string filePath = @"C:\Users\Public\Documents\output.xlsx";

            // Create a new Excel file
            FileInfo fileInfo = new FileInfo(filePath);
            using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
            {
                // Create a new worksheet
                ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");

                // Write data to cells in the worksheet
                worksheet.Cells[1, 1].Value = "ID";
                worksheet.Cells[1, 2].Value = "Name";
                worksheet.Cells[1, 3].Value = "Age";

                worksheet.Cells[2, 1].Value = 1;
                worksheet.Cells[2, 2].Value = "John Doe";
                worksheet.Cells[2, 3].Value = 25;

                worksheet.Cells[3, 1].Value = 2;
                worksheet.Cells[3, 2].Value = "Jane Smith";
                worksheet.Cells[3, 3].Value = 30;

                // Save the Excel file
                excelPackage.Save();
            }

            System.Console.WriteLine("Data written to Excel file successfully!");
        }
    }
}

Detailed Explanation

1. using OfficeOpenXml;: Import the EPPlus library.
2. FileInfo fileInfo = new FileInfo(filePath);: Define the path of the Excel file.
3. ExcelPackage excelPackage = new ExcelPackage(fileInfo): Create a new Excel file.
4. excelPackage.Workbook.Worksheets.Add("Sheet1"): Create a new worksheet named "Sheet1".
5. worksheet.Cells[1, 1].Value = "ID";: Write data to the cell at row 1, column 1.
6. excelPackage.Save(): Save the Excel file.

System Requirements

• .NET Framework 4.5 or later
• Latest version of the EPPlus library

How to install the library to run the above C# code

1. Open your C# project in Visual Studio.
2. Go to Tools > NuGet Package Manager > Package Manager Console.
3. Type Install-Package EPPlus and press Enter.

Tips

• Ensure you have write permissions for the selected directory.
• Check the version of EPPlus to ensure compatibility with your project.