read an excel file in csharp

main.cs
using Excel = Microsoft.Office.Interop.Excel;

class Program
{
    static void Main(string[] args)
    {
        // Create an Excel application object
        Excel.Application excelApp = new Excel.Application();

        // Open the Excel file
        Excel.Workbook workbook = excelApp.Workbooks.Open("path_to_your_excel_file");

        // Get the first worksheet
        Excel.Worksheet worksheet = workbook.Sheets[1];

        // Get the used range of the worksheet
        Excel.Range range = worksheet.UsedRange;

        // Iterate over the cells in the range
        foreach (Excel.Range cell in range)
        {
            // Access the cell value
            string cellValue = cell.Value2.ToString();

            // Do something with the cell value
            Console.WriteLine(cellValue);
        }

        // Close the workbook and release resources
        workbook.Close();
        excelApp.Quit();
        Marshal.ReleaseComObject(worksheet);
        Marshal.ReleaseComObject(workbook);
        Marshal.ReleaseComObject(excelApp);
    }
}
1060 chars
37 lines