一个读写csv文件的C#类

时间:2017-06-02 21:53 来源:网管之家整理 字体:[ ] 评论:

本文实例为大家分享了一个读写csv文件的C#类,供大家参考,具体内容如下

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;

namespace CSVDemo
{
  /// <summary>
  /// CSVUtil is a helper class handling csv files.
  /// </summary>
  public class CSVUtil
  {
    private CSVUtil()
    {
    }
    //write a new file, existed file will be overwritten
    public static void WriteCSV(string filePathName,List<String[]>ls)
    {
      WriteCSV(filePathName,false,ls);
    }
    //write a file, existed file will be overwritten if append = false
    public static void WriteCSV(string filePathName,bool append, List<String[]> ls)
    {
      StreamWriter fileWriter=new StreamWriter(filePathName,append,Encoding.Default);
      foreach(String[] strArr in ls)
      {
        fileWriter.WriteLine(String.Join (“,",strArr) );
      }
      fileWriter.Flush();
      fileWriter.Close();
      
    }
    public static List<String[]> ReadCSV(string filePathName)
    {
      List<String[]> ls = new List<String[]>();
      StreamReader fileReader=new  StreamReader(filePathName); 
      string strLine="";
      while (strLine != null)
      {
        strLine = fileReader.ReadLine();
        if (strLine != null && strLine.Length>0)
        {
          ls.Add(strLine.Split(','));
          //Debug.WriteLine(strLine);
        }
      } 
      fileReader.Close();
      return ls;
    }
    
  }
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持网管之家。

顶一下(0) 踩一下(0)
热门标签:
Top_arrow