Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static WorksheetPart GetWorksheetPartByName( SpreadsheetDocument document, string sheetName )
- {
- IEnumerable<Sheet> sheets =
- document.WorkbookPart.Workbook.GetFirstChild<Sheets>().
- Elements<Sheet>().Where( s => s.Name == sheetName );
- if ( sheets?.Count() == 0 )
- {
- // The specified worksheet does not exist.
- return null;
- }
- string relationshipId = sheets?.First().Id.Value;
- WorksheetPart worksheetPart = ( WorksheetPart ) document.WorkbookPart.GetPartById( relationshipId );
- return worksheetPart;
- }
Add Comment
Please, Sign In to add comment