Exemplos de A3001_Office_Excel.Common ExcelReport.SimpleCopy em C# (CSharp)

Exemplo n.º 1

Arquivo: Test.cs Projeto: mahuidong/my-csharp-sample

        /// <summary>
        /// 测试 复制与隐藏.
        /// </summary>
        public void TestCopyAndHide()
        {
            Console.WriteLine("测试 Excel 复制与隐藏 开始！");

            string fileName =
                System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase
                + @"ExcelFiles\测试复制与隐藏.xls";

            ExcelReport service = new ExcelReport();

            // 打开 Excel.
            service.OpenExcel();

            // 打开 Excel 文件.
            service.OpenExcelFile(fileName);

            // 复制
            service.SimpleCopy(
                "测试复制与隐藏",
                "复制后",
                "A3");

            // 隐藏
            service.HideSheet("测试复制与隐藏");

            // 保存 Excel 文件.
            service.SaveExcelFile();

            // 关闭 Excel.
            service.CloseExcel();

            Console.WriteLine("测试 Excel 复制与隐藏 结束！");
        }