using System;

​

using DocumentFormat.OpenXml;

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

using System.Collections;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        String fileName = "C:\\Users\\RC023990\\Desktop\\DEA_LUGLIO\\150_CAMPANIA_LUGL_24.XLSX";

        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))

    {

        WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart ?? spreadsheetDocument.AddWorkbookPart();

        IEnumerable worksheetParts = workbookPart.WorksheetParts;

        IEnumerator numerator = worksheetParts.GetEnumerator();

foreach(var part in worksheetParts)

{

        IEnumerable sheetsData = ((WorksheetPart)part).Worksheet.Elements<SheetData>();

        foreach(var sheetData in worksheetParts)

        {

            string text;

​

            foreach (Row r in ((SheetData)sheetData).Elements<Row>())

            {

                foreach (Cell c in r.Elements<Cell>())

                {

                    text = c?.CellValue?.Text;

                    Console.Write(text + " ");

                }

            }

       }

}

​

        Console.WriteLine();

        //Console.ReadKey();

    }

    }

}