Read Excel Files in C#

readme.md

Learn how to read Excel files in C#: https://blog.aspose.com/2021/10/10/how-to-read-excel-files-in-csharp/

read-excel-file.cs

// Load Excel file
Workbook wb = new Workbook("excel.xlsx");

// Get all worksheets
WorksheetCollection collection = wb.Worksheets;

// Loop through all the worksheets
for (int worksheetIndex = 0; worksheetIndex < collection.Count; worksheetIndex++)
{

    // Get worksheet using its index
    Worksheet worksheet = collection[worksheetIndex];

    // Print worksheet name
    Console.WriteLine("Worksheet: " + worksheet.Name);

    // Get number of rows and columns
    int rows = worksheet.Cells.MaxDataRow;
    int cols = worksheet.Cells.MaxDataColumn;

    // Loop through rows
    for (int i = 0; i < rows; i++)
    {

        // Loop through each column in selected row
        for (int j = 0; j < cols; j++)
        {
            // Pring cell value
            Console.Write(worksheet.Cells[i, j].Value + " | ");
        }
        // Print line break
        Console.WriteLine(" ");
    }
}

read-worksheet.cs

// Load Excel file
Workbook wb = new Workbook("excel.xlsx");

// Get worksheet using its index
Worksheet worksheet = wb.Worksheets[0];

// Print worksheet name
Console.WriteLine("Worksheet: " + worksheet.Name);

// Get number of rows and columns
int rows = worksheet.Cells.MaxDataRow;
int cols = worksheet.Cells.MaxDataColumn;

// Loop through rows
for (int i = 0; i < rows; i++)
{
    // Loop through each column in selected row
    for (int j = 0; j < cols; j++)
    {
        // Pring cell value
        Console.Write(worksheet.Cells[i, j].Value + " | ");
    }
    // Print line break
    Console.WriteLine(" ");
}