.Net Core使用OpenXML導(dǎo)出、導(dǎo)入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);
 }
 }
 }
 }
}