Guest User

Untitled

a guest
Mar 21st, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. private static WorksheetPart GetWorksheetPartByName( SpreadsheetDocument document, string sheetName )
  2. {
  3. IEnumerable<Sheet> sheets =
  4. document.WorkbookPart.Workbook.GetFirstChild<Sheets>().
  5. Elements<Sheet>().Where( s => s.Name == sheetName );
  6.  
  7. if ( sheets?.Count() == 0 )
  8. {
  9. // The specified worksheet does not exist.
  10.  
  11. return null;
  12. }
  13.  
  14. string relationshipId = sheets?.First().Id.Value;
  15.  
  16. WorksheetPart worksheetPart = ( WorksheetPart ) document.WorkbookPart.GetPartById( relationshipId );
  17.  
  18. return worksheetPart;
  19. }
Add Comment
Please, Sign In to add comment