Guide to Reading Excel Files Using C#

// Step 1: Install the EPPlus library
// You can install it via the NuGet Package Manager Console using the following command:
// Install-Package EPPlus

using OfficeOpenXml;
using System;
using System.IO;

class Program
{
    static void Main(string[] args)
    {
        // Path to the Excel file
        var filePath = "example.xlsx";

        // Check if the file exists
        if (File.Exists(filePath))
        {
            // Load the Excel file
            using (var package = new ExcelPackage(new FileInfo(filePath)))
            {
                // Get the first sheet
                var worksheet = package.Workbook.Worksheets[0];

                // Iterate through each row and column to read data
                for (int row = 1; row <= worksheet.Dimension.End.Row; row++)
                {
                    for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
                    {
                        Console.Write(worksheet.Cells[row, col].Text + "\t"); // Print the value of each cell
                    }
                    Console.WriteLine(); // Move to the next line after reading a row
                }
            }
        }
        else
        {
            Console.WriteLine("File does not exist.");
        }
    }
}