|
private static GetWorkSheetPart ( DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart, |
||
| workbookPart | DocumentFormat.OpenXml.Packaging.WorkbookPart | Workbook part |
| definedName | Object with informations about a area | |
| return | DocumentFormat.OpenXml.Packaging.WorksheetPart | |
private static WorksheetPart GetWorkSheetPart(WorkbookPart workbookPart, DefinedNameVal definedName)
{
//get worksheet based on defined name
string relId = workbookPart.Workbook.Descendants<Sheet>()
.Where(s => definedName.SheetName.Equals(s.Name))
.First()
.Id;
return (WorksheetPart)workbookPart.GetPartById(relId);
}
