Пример #1
0
 public static CreateExcelTest GetCreateExcelTest()
 {
     if (createExcel == null)
     {
         return(createExcel = new CreateExcelTest());
     }
     return(createExcel);
 }
Пример #2
0
        private void OpenExcel()
        {
            string FilePath = @"C:\Users\14439\Desktop\yingpanhao\钻屑法模板.xlsx";

            workBook  = File.Exists(FilePath) ? new Workbook(FilePath) : new Workbook();
            workSheet = workBook.Worksheets[0];

            workBook_excel  = CreateExcelTest.GetCreateExcelTest().GetWorkBookExcel();
            workSheet_excel = workBook_excel.Worksheets[0];
            //将模板拷贝到报表excel
            workSheet_excel.Copy(workSheet);
            workBook_excel.Save(excelFilePath, SaveFormat.Xlsx);
        }
Пример #3
0
        //打开报表模板sheet2
        private void OpenExcel()
        {
            string FilePath = @"C:\Users\14439\Desktop\yingpanhao\微震模板.xlsx";

            workBook  = File.Exists(FilePath) ? new Workbook(FilePath) : new Workbook();
            workSheet = workBook.Worksheets[0];

            workBook_excel = CreateExcelTest.GetCreateExcelTest().GetWorkBookExcel();

            if (workBook_excel.Worksheets["Sheet2"] != null)
            {
                workSheet_excel = workBook_excel.Worksheets["Sheet2"];
            }
            else
            {
                workBook_excel.Worksheets.Add("Sheet2");
                workSheet_excel = workBook_excel.Worksheets["Sheet2"];
            }

            workSheet_excel.Copy(workSheet);
            workBook_excel.Save(excelFilePath, SaveFormat.Xlsx);
        }