C# (CSharp) AddinHelper.Excel.DuplicateWorksheet Examples

Example #1

File: TaskPane_ITRs.cs Project: chrhodes/Office

        private static void DuplicateInputSheet()
        {
            Workbook activeWorkbook = Globals.ThisAddIn.Application.ActiveWorkbook;

            var _with5 = Globals.ThisAddIn;

            ExcelHlp.DuplicateWorksheet("SourceITRs", "ITRInfo", "SourceITRs");
            activeWorkbook.Sheets["ITRInfo"].Columns[Common.cITRInfo_CommentColumns].Delete();

            ExcelHlp.DuplicateWorksheet("SourceITRs", "ITRInfoWithResources", "ITRInfo");
            activeWorkbook.Sheets["ITRInfoWithResources"].Columns[Common.cITRITRInfoWithResources_CommentColumns].Delete();

            ExcelHlp.DuplicateWorksheet("SourceITRs", "FormatedITRs", "SourceITRs");
        }