During the course of time, I often required to write solutions which involve reading CSV (Comma Separated Values) Files. After repeating the same thing for a few times, I decided to write a component that will parse the CSV file and return a DataTable.

To use the the component is really simple. First you need to declare the object,

    CsvDataSource.CsvDataSource src = new CsvDataSource.CsvDataSource();

and then read the CSV file. There are three possible way to read the CSV:

    //Using comma as character separator, first line is NOT treated as column names
    DataTable dt1 = src.ReadFile("input.csv"); 

    //Using comma as separator character, first line is treated as column names
    DataTable dt2 = src.ReadFile("input.csv", true); 

    //Using pipe (|) as separator character, first line is treated as column names
    DataTable dt3 = src.ReadFile("input.csv", true, '|');

The complete source code as follows: Download the class source code.

Simple demo using Command Line Application:

/* Demo of CsvDataSource using Command Line Application
 * (c) 2007 Hardono Arifanto
 * http://sodeve.net
 */
using System;
using System.Collections.Generic;
using System.Text;
using CsvDataSource;
using System.Data;

namespace CsvDataSourceDemo
{
    class Program
    {
        private static void printHelp()
        {
            Console.WriteLine(@"Demo for CsvDataSource.
    Usage: CsvDataSourceDemo [inputfile.csv]");
        }
        static void Main(string[] args)
        {
            DataTable dt;
            if (args.Length > 0)
            {
                CsvDataSource.CsvDataSource src = new CsvDataSource.CsvDataSource();
                dt = src.ReadFile(args[0],true,',');
                //Display the DataTable content
                foreach (DataColumn dc in dt.Columns)
                {
                    Console.Write(dc.ColumnName + "t");
                }
                Console.WriteLine();
                foreach (DataRow dr in dt.Rows)
                {
                    for(int i=0; i < dt.Columns.Count; i++)
                    {
                        Console.Write(dr[i] + "t");
                    }
                    Console.WriteLine();
                }
            }
            else
                printHelp();
        }
    }
}

Share and Enjoy

 

Possibly Related Posts

No related posts.

 

net read csv file (13), read csv file in net (6), read csv c# sodeve (2), reading csv file in net (2), csv files net (2), read csv file net (2), net csv file (2), read csv file through net (1), read csv file class net (1), vb net working with csv files (1), read a comma seperated file in asp net (1), query csv file net (1), net read csv file from solution (1), net read a csv (1), net csv file reader (1), read csv file to datatable get column names (1), Read csv file with net (1), vb net read the csv fie in to datatable (1), vb net parsing csv files first row column names (1), vb net csvdatasource (1), using csvfilereader in net (1), reading first row csv file in asp net (1), reading csv file from net (1), reading a csv file in net (1), read gmail using vb net (1), read gmail csv using net (1), read csv to datatable asp net (1), read csv of office 2007 file in data table vb net (1), read csv files using net (1), net component to read a csv file (1)

Advertise Here