예제 #1
0
        public void TestClearToolSheet()
        {
            using (ExcelCore excelCore = new ExcelCore())
            {
                excelCore.OpenExcel(@"C:\Users\Administrator\Desktop\WorkFiles\Letter Automation\Control turnaround.xlsx", false);
                excelCore.SelectSheet("Sheet1");

                IList <Row> rows = excelCore.GetSheetByRow();
            }
        }
예제 #2
0
        public void ExcelCoreTest()
        {
            using (ExcelCore excelCore = new ExcelCore())
            {
                excelCore.OpenExcel(@"C:\Users\Administrator\Desktop\TestExcel\Letter Automation V1.19.1.xlsm", false);
                IList <string> sheetNames = excelCore.GetSheetNames();
                excelCore.SelectSheet("Data");
                //DeptComboBox
                IList <Cell> language = excelCore.GetRangeByName("Language");

                IList <Cell> departmentLevel = excelCore.GetRange(new Cell()
                {
                    ColumnName = "K", RowIndex = 42
                },
                                                                  new Cell()
                {
                    ColumnName = "K", RowIndex = 46
                });

                IList <Cell> clientLevel = excelCore.GetRange(new Cell()
                {
                    ColumnName = "L", RowIndex = 40
                },
                                                              new Cell()
                {
                    ColumnName = "L", RowIndex = 41
                });

                IList <Cell> EELetterlevel = excelCore.GetRange(new Cell()
                {
                    ColumnName = "M", RowIndex = 40
                },
                                                                new Cell()
                {
                    ColumnName = "M", RowIndex = 48
                });

                IList <Cell> EETransactionlevel = excelCore.GetRange(new Cell()
                {
                    ColumnName = "N", RowIndex = 40
                },
                                                                     new Cell()
                {
                    ColumnName = "N", RowIndex = 72
                });
            }
        }