public void IsSheetCountCorrect()
{
string path = @"C:\Users\PHCCUser\Desktop\PMS Data\2017\DW_2017\LAB_TestsPerformed_2017\Lab Data Oct-2017_Sample-collected-orders_Tests.xlsx";
IExcelOperations excelOps = new ExcelDataReaderLib();
Assert.Equal(2, excelOps.GetSheetNames(path).Count);
}
public void IsReadingAllColumns()
{
string path = @"C:\Users\PHCCUser\Desktop\PMS Data\2017\DW_2017\LAB_TestsPerformed_2017\Lab Data Oct-2017_Sample-collected-orders_Tests.xlsx";
List <string> sheetNames = new List <string>()
{
"Lab_Order_Collected _Samples",
"Lab Test at PHCC_Oct 2017"
};
IExcelOperations excelOps = new ExcelDataReaderLib();
var sheets = excelOps.GetSheetNames(path);
for (int i = 0; i < sheetNames.Count; i++)
{
Assert.Contains(sheetNames[i], sheets);
}
}
static void Main(string[] args)
{
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
IExcelOperations excelOps = new ExcelDataReaderLib();
//var values = excelOps.GetSheetNames(
// @"C:\Users\PHCCUser\Desktop\PMS Data\2017\DW_2017\LAB_TestsPerformed_2017\Lab Data Oct-2017_Sample-collected-orders_Tests.xlsx");
var values = excelOps.GetFirstRow(
@"C:\Users\PHCCUser\Desktop\PMS Data\2017\DW_2017\LAB_TestsPerformed_2017\Lab Data Oct-2017_Sample-collected-orders_Tests.xlsx");
stopWatch.Stop();
PrintHeaders(values);
System.Console.WriteLine(stopWatch.ElapsedMilliseconds);
System.Console.ReadLine();
}
