public void Should_return_list_of_kurs()
{
ExcelKursReader reader = new ExcelKursReader();
reader.Open();
Rates allKurs = reader.GetAllRates();
Assert.IsFalse(allKurs.rates.Count == 0);
foreach (var kurs in allKurs.rates)
{
Console.WriteLine("{0} : {1} {2}", kurs.currency, kurs.ask, kurs.bid);
}
reader.Close();
// test open again
reader.Open();
allKurs = reader.GetAllRates();
Assert.IsFalse(allKurs.rates.Count == 0);
foreach (var kurs in allKurs.rates)
{
Console.WriteLine("{0} : {1} {2}", kurs.currency, kurs.ask, kurs.bid);
}
reader.Close();
}
public void Should_terminate_unclosed_excel()
{
ExcelKiller excelKiller = new ExcelKiller();
ExcelKursReader reader = new ExcelKursReader();
reader.Open();
Process[] AllProcesses = Process.GetProcessesByName("excel");
foreach (var item in AllProcesses)
{
Console.WriteLine(item.ProcessName);
//item.Kill();
}
excelKiller.KillExcelProcessForThisApp();
Thread.Sleep(2000);
AllProcesses = Process.GetProcessesByName("excel");
Assert.AreEqual(0, AllProcesses.Length);
}
public void SetUp()
{
Console.WriteLine(ConfigurationManager.AppSettings["excel_location"]);
_reader = new ExcelKursReader(ConfigurationManager.AppSettings["excel_location"]);
_reader.Open();
}