internal static void ManipulateColumns(List <string> commonHeaderTemplate) { foreach (string file in Directory.EnumerateFiles(ConfigurationManager.AppSettings["PremierLeagueData"], "*.csv")) { InteropExcel.GetValues(file, commonHeaderTemplate); } }
internal static void CheckColumnsOrder() { List <string> templateModel = new List <string>(); List <string> dataModel = new List <string>(); int k = 0; #warning hardcode...data/output content foreach (string file in Directory.EnumerateFiles(@"D:\Andrei\Cariera\Proiecte Git\csv-parser\csv-parser\Data\Output\PremierLeague", "*.csv")) { List <string> fileColumns = CSVParser_IO.ReadCSV(file); List <string> fileHeaderColumn = new List <string>(); int numberofcolumns = InteropExcel.GetNumberOfColumns(file); for (int i = 0; i < numberofcolumns; i++) { fileHeaderColumn.Add(fileColumns[i]); } foreach (var elem in fileHeaderColumn) { if (k == 0) { templateModel.Add(elem); } else { dataModel.Add(elem); } } if (k > 0) { if (templateModel.SequenceEqual(dataModel)) { Console.WriteLine("OK"); } else { Console.WriteLine("NOT OK"); } } k = k + 1; dataModel = new List <string>(); } }
internal static void RemoveColumns(List <string> commonHeaderTemplate) { foreach (string file in Directory.EnumerateFiles(ConfigurationManager.AppSettings["PremierLeagueData"], "*.csv")) { List <string> fileColumns = CSVParser_IO.ReadCSV(file); List <string> fileHeaderColumn = new List <string>(); int numberofcolumns = InteropExcel.GetNumberOfColumns(file); for (int i = 0; i < numberofcolumns; i++) { fileHeaderColumn.Add(fileColumns[i]); } List <string> extraColumns = new List <string>(); foreach (var item in fileHeaderColumn) { if (!commonHeaderTemplate.Contains(item)) { extraColumns.Add(item); } } InteropExcel.RemoveColumns(file, extraColumns); } }