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;
}