[ C# ] DataTable CSV 읽고 쓰기

테스트 환경

VisualStudio  2008 / 2010

CSV 파일 내용

CSV 열기

 
        public DataTable LoadCSV(string fileName )
        {
            DataTable table = new DataTable();
 
            string[] buff = File.ReadAllLines(fileNae, Encoding.UTF8);
            
            foreach (string d in buff)
            {
                string[] split = d.Split(',');
 
                if (split.Length > 0)
                {
                    if (split[0] == "X")
                    {
                        foreach (string colName in split)
                        {
                            table .Columns.Add(colName);   
                        }
                    }                    else
                    {
                        table .Rows.Add(split);                    }
                }
            }
 
            return table;
        }

CSV 저장

public bool SaveCSV(string fileName, DataTable table)
        {
            List<string> buff = new List<string>();
 
            string[] columnNames = table.Columns.Cast<DataColumn>().
                                  Select(column => column.ColumnName).
                                  ToArray();
 
            string line = string.Join(",", columnNames);
            buff.Add(line);
 
            foreach (DataRow row in table.Rows)
            {
                string[] fields = row.ItemArray.Select(field => field.ToString()).
                                    ToArray();
 
                line = string.Join(",", fields);
                buff.Add(line);
            }
 
            File.WriteAllLines(fileName, buff.ToArray(), Encoding.UTF8);
 
 
            return true;
        }