一聚教程网:一个值得你收藏的教程网站

热门教程

一个读写csv文件的C#类

时间:2022-06-25 07:49:21 编辑:袖梨 来源:一聚教程网

 
 代码如下复制代码
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
 
namespace CSVDemo
{
  ///
  /// CSVUtil is a helper class handling csv files.
  ///
  public class CSVUtil
  {
    private CSVUtil()
    {
    }
    //write a new file, existed file will be overwritten
    public static void WriteCSV(string filePathName,Listls)
    {
      WriteCSV(filePathName,false,ls);
    }
    //write a file, existed file will be overwritten if append = false
    public static void WriteCSV(string filePathName,bool append, Listls)
    {
      StreamWriter fileWriter=new StreamWriter(filePathName,append,Encoding.Default);
      foreach(String[] strArr in ls)
      {
        fileWriter.WriteLine(String.Join (“,",strArr) );
      }
      fileWriter.Flush();
      fileWriter.Close();
       
    }
    public static ListReadCSV(string filePathName)
    {
      Listls =new List();
      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;
    }
     
  }
}
 

热门栏目