static void Main(string[] args)

{

    var spreadsheetDocument = SpreadsheetDocument.Create("F:\\OpenXml.xlsx", SpreadsheetDocumentType.Workbook);

    var workbookpart = spreadsheetDocument.AddWorkbookPart();

    workbookpart.Workbook = new Workbook();

    WorksheetPart worksheetPart = workbookpart.AddNewPart();

    worksheetPart.Worksheet = new Worksheet(new SheetData());

    Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets());

    Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = , Name = "Sheet1" };

    sheets.Append(sheet);

    var sheetData = worksheetPart.Worksheet.GetFirstChild();

    for (int i = ; i < ; i++)

    {

        Row row = new Row();

        for (int j = ; j < ; j++)

        {

            Cell dataCell = new Cell();

            dataCell.CellValue = new CellValue($"{i + 1}行{j + 1}列");

            dataCell.DataType = new EnumValue(CellValues.String);

            row.AppendChild(dataCell);

        }

        sheetData.Append(row);

    }

    workbookpart.Workbook.Save();

    spreadsheetDocument.Close();

}

static void Main(string[] args)

{

    using (SpreadsheetDocument doc = SpreadsheetDocument.Open(@"F:\OpenXml.xlsx", false))

    {

        WorkbookPart wbPart = doc.WorkbookPart;

        Sheet mysheet = (Sheet)doc.WorkbookPart.Workbook.Sheets.ChildElements.FirstOrDefault();

        Worksheet worksheet = ((WorksheetPart)wbPart.GetPartById(mysheet.Id)).Worksheet;

        SheetData sheetData = (SheetData)worksheet.ChildElements.FirstOrDefault();

        foreach (var row in sheetData.ChildElements)

        {

            foreach (var cell in (row as Row).ChildElements)

            {

                var cellValue = (cell as Cell).CellValue;

                if (cellValue != null)

                {

                    Console.WriteLine(cellValue.Text);

                }

            }

        }

    }

}