read objects from an excel sheet in csharp

main.cs
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
82 chars
3 lines

main.cs
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open("path_to_excel_file.xlsx", false))
{
    // Read the workbook part
    WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
    
    // Get the first worksheet
    WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
    
    // Get the sheet data
    SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();

    // Iterate through each row in the sheet
    foreach (Row row in sheetData.Elements<Row>())
    {
        // Iterate through each cell in the row
        foreach (Cell cell in row.Elements<Cell>())
        {
            // Read the cell value
            string cellValue = cell.CellValue.InnerText;
            
            // Do something with the cell value
            Console.WriteLine(cellValue);
        }
    }
}
852 chars
26 lines