Exemplos de Microsoft.Office.Interop.Excel.AddWorksheet em C# (CSharp)

Exemplo n.º 1

Arquivo: TeamFileSummaryModule.cs Projeto: PSDevGithub/PSExcelAddin2010

 public override void CreateModuleSheets(InteropExcel.Workbook ActiveWorkbook)
 {
     try
     {
         ActiveWorkbook.AddWorksheet("TeamApproval", InteropExcel.XlSheetVisibility.xlSheetVisible);
         ActiveWorkbook.AddWorksheet("_parameter", InteropExcel.XlSheetVisibility.xlSheetVeryHidden);
     }
     catch (Exception ex)
     {
         ExceptionHandler.HandleException(ex);
     }
 }

Exemplo n.º 2

Arquivo: SqlStatementsModule.cs Projeto: PSDevGithub/PSExcelAddin2010

 public override void CreateModuleSheets(InteropExcel.Workbook ActiveWorkbook)
 {
     try
     {
         ActiveWorkbook.AddWorksheet("_sqlstatements", InteropExcel.XlSheetVisibility.xlSheetVisible);
     }
     catch (Exception ex)
     {
         ExceptionHandler.HandleException(ex);
     }
 }

Exemplo n.º 3

Arquivo: CurrentTeamModule.cs Projeto: PSDevGithub/PSExcelAddin2010

        public override void CreateModuleSheets(InteropExcel.Workbook ActiveWorkbook)
        {
            try
            {
                ActiveWorkbook.AddWorksheet("_parameter", InteropExcel.XlSheetVisibility.xlSheetVisible);
                ActiveWorkbook.AddWorksheet("CurrentTeam", InteropExcel.XlSheetVisibility.xlSheetVisible);
                ActiveWorkbook.AddWorksheet("Report", InteropExcel.XlSheetVisibility.xlSheetVisible);

            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(ex);
            }
        }