时间:2021-05-20
本文实例讲述了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#程序设计有所帮助。
声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。
本文实例讲述了C#导出GridView数据到Excel文件类。分享给大家供大家参考。具体如下:这段C#代码自定义了一个封装类,用于将GridView数据导出到E
本文实例讲述了C#自定义导出数据到Excel的类。分享给大家供大家参考。具体如下:C#自定义Excel操作类,可以用于将DataTable导出到Excel文件,
本文实例讲述了C#操作CSV文件类。分享给大家供大家参考。具体分析如下:这个C#类用于转换DataTable为CSV文件、CSV文件转换成DataTable,如
本文实例讲述了C#实现导出List数据到xml文件的方法。分享给大家供大家参考,具体如下:C#导出List数据到xml文件,这里主要用到的是:XmlSerial
本文实例讲述了C#导出数据到Excel文件的方法。分享给大家供大家参考。具体实现方法如下://////导出到Excel类,项目需引用Microsodt.Offi