コード例 #1
0
        // --------------------------------------------------------------------------------------------------------------------------
        /// <summary>
        /// Add a line to the file, using reflection to read source data from the given type.
        /// </summary>
        public void AddLineFromData <T>(T data)
        {
            Type t = typeof(T);
            List <CSVColToPropertyMap> propList = CSVLine.GetPropList(t, ColumnMap);

            string[] vals = new string[ColumnMap.Count];
            foreach (var p in propList)
            {
                int index = ColumnMap.GetIndex(p.ColName);
                if (index != -1)
                {
                    object val = p.PropInfo.GetValue(data, null);

                    string useVal = val?.ToString() ?? ""; // FixCSVData(val?.ToString() ?? "");

                    if (p.PropInfo.PropertyType == typeof(string))
                    {
                        // Just quote all string fields...
                        // Also make sure to escape any existing quotes.
                        useVal = useVal.Replace("\"", "\"\"");
                        useVal = "\"" + useVal + "\"";
                    }
                    vals[index] = useVal;
                }
            }

            Lines.Add(new CSVLine(ColumnMap, vals));
        }
コード例 #2
0
        // --------------------------------------------------------------------------------------------------------------------------
        public void AddLine(params string[] values)
        {
            CSVLine l     = new CSVLine(this.ColumnMap);
            int     index = 0;

            foreach (var v in values)
            {
                l[index] = v;
                ++index;
            }

            AddLine(l);
        }
コード例 #3
0
        // --------------------------------------------------------------------------------------------------------------------------
        public CSVFile(string path, string separator = ",", bool includeHeader = true, bool trimWhitespace = true)
        {
            if (!File.Exists(path))
            {
                throw new FileNotFoundException($"The file at path: {path} does not exist!");
            }
            string[] splitWith = new[] { separator };

            Separator = separator;

            using (var fs = new FileStream(path, FileMode.Open, FileAccess.Read))
                using (StreamReader r = new StreamReader(fs, Encoding.UTF8))
                {
                    // r.Read(

                    string   line       = GetNextLine(r);
                    string[] firstParts = line.Split(splitWith, StringSplitOptions.None);

                    if (includeHeader)
                    {
                        int index = 0;
                        foreach (var p in firstParts)
                        {
                            var cmap = new CSVColumnMapping()
                            {
                                Index = index,
                                Name  = GetColumnValue(firstParts, index, trimWhitespace)
                            };
                            Columns.Add(cmap);
                            ++index;
                        }
                        // it.MoveNext();
                    }
                    else
                    {
                        // The first line is to be treated as data, so we will do that, but generate column names.
                        for (int i = 0; i < firstParts.Length; i++)
                        {
                            var cmap = new CSVColumnMapping()
                            {
                                Index = i,
                                Name  = $"Column_{i + 1}",
                            };
                            Columns.Add(cmap);
                        }
                    }



                    // Now we can process all of the data......
                    Lines = new List <CSVLine>();
                    CSVColumnMap useCols = new CSVColumnMap(Columns);

                    while ((line = GetNextLine(r)) != null)
                    {
                        CSVLine csvLine = new CSVLine(useCols, line, separator);
                        Lines.Add(csvLine);
                    }
                }

            return;
        }
コード例 #4
0
 // --------------------------------------------------------------------------------------------------------------------------
 public void AddLine(CSVLine line)
 {
     Lines.Add(line);
 }