| private getWorksheet ( string worksheetName ) : Microsoft.Office.Interop.Excel.Worksheet | ||
| worksheetName | string | |
| return | Microsoft.Office.Interop.Excel.Worksheet | |
private Excel.Worksheet getWorksheet(string worksheetName)
{
Excel.Worksheet worksheet;
try
{
worksheet = _workbook.Worksheets[worksheetName];
}
catch (Exception)
{
worksheet = _workbook.Worksheets.Add();
worksheet.Name = worksheetName;
}
worksheet.Visible = Excel.XlSheetVisibility.xlSheetVeryHidden;
return worksheet;
}
