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

Close() public method

public Close ( ) : void
return void
        public void Close()
        {
            xlWorkBook.Close(false, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);
        }

Usage Example

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