Exemple #1
0
 /// <summary>
 /// Initializes a new instance of the <see cref="CsvRow"/> class.
 /// </summary>
 /// <param name="file">
 /// The file.
 /// </param>
 public CsvRow(CsvFile file)
 {
     this.File   = file;
     this.Values = new object[file.Columns.Count];
 }
Exemple #2
0
        /// <summary>
        /// Loads from the specified stream reader.
        /// </summary>
        /// <param name="s">The stream reader.</param>
        /// <param name="cultureInfo">The culture info.</param>
        /// <returns>
        /// A <see cref="CsvFile" />.
        /// </returns>
        /// <exception cref="System.ArgumentNullException">s;The stream reader must be specified.</exception>
        /// <exception cref="System.InvalidOperationException">Invalid header.</exception>
        /// <exception cref="System.FormatException">Wrong number of columns on line  + lineNumber</exception>
        public static CsvFile Load(StreamReader s, CultureInfo cultureInfo = null)
        {
            if (s == null)
            {
                throw new ArgumentNullException("s", "The stream reader must be specified.");
            }

            if (cultureInfo == null)
            {
                cultureInfo = CultureInfo.InvariantCulture;
            }

            var separator = cultureInfo.TextInfo.ListSeparator;

            var headerLine = s.ReadLine();

            if (headerLine == null)
            {
                throw new InvalidOperationException("Invalid header.");
            }

            var headers = SplitLine(headerLine, separator[0]);
            int n       = headers.Length;

            // Create a string collection for each column
            var items = new ValueList[n];

            for (int i = 0; i < n; i++)
            {
                items[i] = new ValueList();
            }

            // Read all rows
            int lineNumber = 1;

            while (!s.EndOfStream)
            {
                lineNumber++;
                var line = s.ReadLine();
                if (line == null)
                {
                    continue;
                }

                var fields = SplitLine(line, separator[0]);
                if (fields.Length != n)
                {
                    throw new FormatException("Wrong number of columns on line " + lineNumber);
                }

                for (int i = 0; i < n; i++)
                {
                    items[i].Add(fields[i]);
                }
            }

            var file = new CsvFile();

            // Determine the type of each column from the data
            for (int i = 0; i < n; i++)
            {
                string name, unit;
                SplitHeader(headers[i], out name, out unit);

                file.Columns.Add(new CsvColumn(name, unit, items[i].GetSmallestCommonType(cultureInfo)));
            }

            // Parse the values (and box them)
            for (int j = 0; j < items[0].Count; j++)
            {
                var item = new CsvRow(file);
                for (int i = 0; i < file.Columns.Count; i++)
                {
                    item.Values[i] = file.Columns[i].Convert(items[i][j], cultureInfo);
                }

                file.Rows.Add(item);
            }

            return(file);
        }