public static List <Worksheet> GetAllWorksheets(SpreadsheetDocument spreadsheet) { var worksheets = new List <Worksheet>(); var worksheetParts = ExcelSpreadsheet.GetAllWorksheetParts(spreadsheet); foreach (WorksheetPart itemWorksheetPart in worksheetParts) { worksheets.Add(itemWorksheetPart.Worksheet); } return(worksheets); }
public static List <WorksheetPart> GetAllWorksheetParts(SpreadsheetDocument spreadsheet) { var worksheetParts = new List <WorksheetPart>(); var sheets = ExcelSpreadsheet.GetSheets(spreadsheet); foreach (Sheet itemSheet in sheets) { String SheetID = itemSheet.Id; WorksheetPart wsPart = (WorksheetPart)spreadsheet.WorkbookPart.GetPartById(SheetID); worksheetParts.Add(wsPart); } return(worksheetParts); }