private void AddMissingFields(CsvEntry entry, List <string> missingFieldNames) { foreach (var missingFieldName in missingFieldNames) { entry.AddValue(missingFieldName, null, false); } }
public void TestToString() { var key1 = "key1"; var value1 = "10.0"; var key2 = "key2"; var value2 = "value2"; var entry = new CsvEntry(); entry.AddValue(key1, value1, true); entry.AddValue(key2, value2, false); var expectedString = "10.0,value2"; Assert.AreEqual(expectedString, entry.ToString()); }
public void TestAddDimension() { var key = "key"; var value = "10.0"; var entry = new CsvEntry(); entry.AddValue(key, value, true); Assert.AreEqual(0, entry.MeasureValues.Count); Assert.AreEqual(1, entry.DimensionValues.Count); Assert.IsTrue(entry.DimensionValues.ContainsKey(key)); Assert.AreEqual(value, entry.DimensionValues[key]); }
public CsvData ReadFile(string fileName) { var csvData = new CsvData(); var csvEntries = new List <CsvEntry>(); var csvReaderConfiguration = new Configuration() { Delimiter = CSV_DELIMITER }; using (var streamReader = File.OpenText(fileName)) using (var csvReader = new CsvHelper.CsvReader(streamReader, csvReaderConfiguration)) { csvReader.Read(); csvReader.ReadHeader(); var header = csvReader.Context.HeaderRecord; while (csvReader.Read()) { var csvEntry = new CsvEntry(); foreach (var name in header) { bool isDimension = false; if (dimensionColumns.Contains(name)) { isDimension = true; } var value = csvReader.GetField(name); csvEntry.AddValue(name, value, isDimension); } csvEntries.Add(csvEntry); } csvData.FieldNames = header; } csvData.Entries = csvEntries; return(csvData); }