C#导出数据到CSV文件的通用类实例

本文实例讲述了C#导出数据到csv文件的通用类。分享给大家供大家参考。具体如下：

通过这个类可以很简单的定义数据格式，并导出到csv文件

//这里写了一个通用的类
using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Reflection;
using System.IO;
using System.Data.Odbc;
namespace Com.DRPENG.SDXY.UI.Common
{
public class CSVHelper
{
 #region Fields
 string _fileName;
 DataTable _dataSource;//数据源
 string[] _titles = null;//列标题
 string[] _fields = null;//字段名
 #endregion
 #region .ctor
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="dataSource">数据源</param>
 public CSVHelper()
 {
 }
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="titles">要输出到 Excel 的列标题的数组</param>
 /// <param name="fields">要输出到 Excel 的字段名称数组</param>
 /// <param name="dataSource">数据源</param>
 public CSVHelper(string[] titles, string[] fields, DataTable dataSource)
  : this(titles, dataSource)
 {
  if (fields == null || fields.Length == 0)
   throw new ArgumentNullException("fields");
  if (titles.Length != fields.Length)
   throw new ArgumentException("titles.Length != fields.Length", "fields");
  _fields = fields;
 }
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="titles">要输出到 Excel 的列标题的数组</param>
 /// <param name="dataSource">数据源</param>
 public CSVHelper(string[] titles, DataTable dataSource)
  : this(dataSource)
 {
  if (titles == null || titles.Length == 0)
   throw new ArgumentNullException("titles");
  _titles = titles;
 }
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="dataSource">数据源</param>
 public CSVHelper(DataTable dataSource)
 {
  if (dataSource == null)
   throw new ArgumentNullException("dataSource");
  // maybe more checks needed here (IEnumerable, IList, IListSource, ) ???
  // 很难判断，先简单的使用 DataTable
  _dataSource = dataSource;
 }
 #endregion
 #region public Methods
 #region 导出到CSV文件并且提示下载
 /// <summary>
 /// 导出到CSV文件并且提示下载
 /// </summary>
 /// <param name="fileName"></param>
 public void DataToCSV(string fileName)
 {
  // 确保有一个合法的输出文件名
  //if (fileName == null || fileName == string.Empty || !(fileName.ToLower().EndsWith(".csv")))
  // fileName = GetRandomFileName();
  string data = ExportCSV();
  HttpContext.Current.Response.ClearHeaders();
  HttpContext.Current.Response.Clear();
  HttpContext.Current.Response.Expires = 0;
  HttpContext.Current.Response.BufferOutput = true;
  HttpContext.Current.Response.Charset = "GB2312";
  HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
  HttpContext.Current.Response.AppendHeader("Content-Disposition", string.Format("attachment;filename={0}.csv", System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8)));
  HttpContext.Current.Response.ContentType = "text/h323;charset=gbk";
  HttpContext.Current.Response.Write(data);
  HttpContext.Current.Response.End();
 }
 #endregion
 /// <summary>
 /// 获取CSV导入的数据
 /// </summary>
 /// <param name="filePath">文件路径</param>
 /// <param name="fileName">文件名称(.csv不用加)</param>
 /// <returns></returns>
 public DataTable GetCsvData(string filePath,string fileName)
 {
  string path = Path.Combine(filePath, fileName + ".csv");
  string connString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + filePath + ";Extensions=asc,csv,tab,txt;";
  try
  {
   using (OdbcConnection odbcConn = new OdbcConnection(connString))
   {
    odbcConn.Open();
    OdbcCommand oleComm = new OdbcCommand();
    oleComm.Connection = odbcConn;
    oleComm.CommandText = "select * from [" + fileName + "#csv]";
    OdbcDataAdapter adapter = new OdbcDataAdapter(oleComm);
    DataSet ds = new DataSet();
    adapter.Fill(ds, fileName);
    return ds.Tables[0];
    odbcConn.Close();
   }
   if (File.Exists(path))
   {
    File.Delete(path);
   }
  }
  catch (Exception ex)
  {
   if (File.Exists(path))
   {
    File.Delete(path);
   }
   throw ex;
  }
 }
 #endregion
 #region 返回写入CSV的字符串
 /// <summary>
 /// 返回写入CSV的字符串
 /// </summary>
 /// <returns></returns>
 private string ExportCSV()
 {
  if(_dataSource==null)
   throw new ArgumentNullException("dataSource");
  StringBuilder strbData = new StringBuilder();
  if (_titles == null)
  {
   //添加列名
   foreach (DataColumn column in _dataSource.Columns)
   {
    strbData.Append(column.ColumnName + ",");
   }
   strbData.Append("\n");
   foreach (DataRow dr in _dataSource.Rows)
   {
    for (int i = 0; i < _dataSource.Columns.Count; i++)
    {
     strbData.Append(dr[i].ToString() + ",");
    }
    strbData.Append("\n");
   }
   return strbData.ToString();
  }
  else
  {
   foreach (string columnName in _titles)
   {
    strbData.Append(columnName + ",");
   }
   strbData.Append("\n");
   if (_fields == null)
   {
    foreach (DataRow dr in _dataSource.Rows)
    {
     for (int i = 0; i < _dataSource.Columns.Count; i++)
     {
      strbData.Append(dr[i].ToString() + ",");
     }
     strbData.Append("\n");
    }
    return strbData.ToString();
   }
   else
   {
    foreach (DataRow dr in _dataSource.Rows)
    {
     for (int i = 0; i < _fields.Length; i++)
     {
      strbData.Append(_fields[i].ToString() + ",");
     }
     strbData.Append("\n");
    }
    return strbData.ToString();
   }
  }
 }
 #endregion
 #region 得到一个随意的文件名
 /// <summary>
 /// 得到一个随意的文件名
 /// </summary>
 /// <returns></returns>
 private string GetRandomFileName()
 {
  Random rnd = new Random((int)(DateTime.Now.Ticks));
  string s = rnd.Next(Int32.MaxValue).ToString();
  return DateTime.Now.ToShortDateString() + "_" + s + ".csv";
 }
 #endregion
}
}

希望本文所述对大家的C#程序设计有所帮助。