.Net Core使用OpenXML导出、导入Excel

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 = 1, Name = "Sheet1" }; sheets.Append(sheet); var sheetData = worksheetPart.Worksheet.GetFirstChild(); for (int i = 0; i < 10; i++) {  Row row = new Row();  for (int j = 0; j < 10; 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);    }   }  } }}