Beispiel #1
0
        public void ProcessInputs(List <ICSVModel> inputData, IConfigReader configReader)
        {
            List <CodesCSVItemModel> itemsList = new List <CodesCSVItemModel>();

            foreach (var csvModel in inputData)
            {
                //Parse the CSV file
                csvModel.Process();

                //Append the records to the final list
                itemsList.AddRange(csvModel.CSVRecords);
            }

            SpreadsheetGenerator sg = new SpreadsheetGenerator();

            var columnsInPage       = int.Parse(configReader.GetConfiguration("MaximumSpreadsheetColumnsToUse"));
            var spreadsheetDataRows = sg.ConstructNonFormattedSpreadsheetData(itemsList, columnsInPage);

            sg.ConvertToRichlyFormattedSpreadsheet(spreadsheetDataRows, configReader.GetOutputFileName(), configReader);

            //foreach (var i in a)
            //{
            //    Console.WriteLine();
            //    foreach (var j in i)
            //        Console.WriteLine(j.Code);
            //}
            //var a = configReader.GetLibSettings("SpreadsheetColumnsToCreate");
            //Console.WriteLine(a);
            //foreach (var item in itemsList)
            //    Console.WriteLine(item);
            //Console.ReadLine();
        }