static void Main(string[] args) { DonerCollection data; try { logger = Logger.CreateLogger(true); //Test(); // string filePath = @"TestData\"; string filePath = System.Configuration.ConfigurationManager.AppSettings["SpreadSheetLocation"]; string[] files = Directory.GetFiles(filePath, "*.xls*"); data = new DonerCollection(); ReadExcel(files, data); //TestMerge(); //TestLogger(); //TestFileNames(files); //TestDonationQueries(); data.PrintDoners(); // TestPrintDonationsOfAaron(data); data.ConsolidateDoners(); data.PrintDoners(); data.PrintDonationCollectionDates(); if (reportTypes.Contains("Donors")) CreateReportForDoners(data); if (reportTypes.Contains("Monthly")) CreateMonthlyReports(data); //TestExcelWriter(ref data); } catch (Exception e) { logger.WriteError("Exception occurred during execution: \n {0}, {1}", e.Message, e.StackTrace); } finally { logger.Close(); } }