将DataTable导出为CSV文件

最新推荐文章于 2023-12-20 10:11:56 发布

原创

最新推荐文章于 2023-12-20 10:11:56 发布 · 1k 阅读

2 ·

CC 4.0 BY-SA版权

    class Save_CSV
    {
   
   
        /// <summary>
        /// 将datatable导出为.CSV文件
        /// </summary>
        /// <param name="dt">需要导出的表</param>
        /// <param name="strPath">导出的路径</param>
        public string SaveCsv(DataTable  dt,string strPath)
        {
   
               
            if (File.Exists(strPath))
            {
   
   
                File.Delete(strPath);
            }
            //先打印标头
            StringBuilder strColu = new StringBuilder();
            StringBuilder strValue = new StringBuilder();
            int i = 0;
            try
            {
   
   
                StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312"));

                for (i = 0; i <= dt.Columns.Count - 1;