/// <summary>
///
/// </summary>
/// <param name="document"></param>
/// <param name="sheetIndex"></param>
/// <returns></returns>
public static Worksheet GetWorksheet(this SpreadsheetDocument document, int sheetIndex)
{
int sheetCount = document.GetWorksheetCount();
if (sheetIndex < 0 || sheetIndex > sheetCount)
{
throw new ArgumentOutOfRangeException("请确认输入的索引是否正确");
}
//返回指定工作表
Sheet sheet = document.WorkbookPart.Workbook.Descendants <Sheet>().ElementAt(sheetIndex);
WorksheetPart workSheetPart = (WorksheetPart)document.WorkbookPart.GetPartById(sheet.Id);
return(workSheetPart.Worksheet);
}
