using (var workbook = SpreadsheetDocument.Create(filename, SpreadsheetDocumentType.Workbook)) { WorkbookPart workbookPart = workbook.AddWorkbookPart(); workbook.WorkbookPart.Workbook = new Workbook(); WorksheetPart worksheetPart = workbook.WorkbookPart.AddNewPart(); worksheetPart.Worksheet = new Worksheet(new SheetData()); Sheets sheets = workbook.WorkbookPart.Workbook.AppendChild(new Sheets()); Sheet sheet = new Sheet() { Id = workbook.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" }; sheets.Append(sheet); workbook.Save(); }
using (var workbook = SpreadsheetDocument.Open(filename, false)) { var worksheetPart = workbook.WorkbookPart.WorksheetParts.First(); var sheetData = worksheetPart.Worksheet.ElementsThis code reads data from the first worksheet of an existing Excel workbook and prints it to the console. Both of these examples use the Open XML SDK library for working with Excel files.().First(); foreach (var row in sheetData.Elements ()) { foreach (var cell in row.Elements
()) { var cellValue = cell.InnerText; Console.Write(cellValue + "\t"); } Console.Write("\n"); } } |