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();
}
}
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
});
}
}