Megawastu.Valas.KursProvider.Application.ExcelKursReader.Open C# (CSharp) Method

        public void Open()
        {
            //xlApp.Visible = true;
            //xlApp.UserControl = true;
            xlApp = new Excel.ApplicationClass();
            xlWorkBook = xlApp.Workbooks.Open(excelPath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);

            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        }

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