• C# DataTable转为TXT文档


    public static void SaveCSV(DataTable dt, string fullPath)
            {
                var fi = new FileInfo(fullPath); if (!fi.Directory.Exists) { fi.Directory.Create(); }
                var fs = new FileStream(fullPath, FileMode.Append, FileAccess.Write);            //StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);            
                var sw = new StreamWriter(fs, Encoding.UTF8);
                var data = "";            //写出列名称           
                if (s == 0)
                {
                    ++s;
                    for (var i = 0; i < dt.Columns.Count; i++)
                    {
                        data += dt.Columns[i].ColumnName;
                        if (i < dt.Columns.Count - 1)
                        {
                            data += ",";
                        }
                    }
                    sw.WriteLine(data);
                }
                //写出各行数据        
                for (var i = 0; i < dt.Rows.Count; i++)
                {
                    data = "";
                    for (var j = 0; j < dt.Columns.Count; j++)
                    {
                        var str = dt.Rows[i][j].ToString();
                        str = str.Replace(""", """"); //替换英文冒号 英文冒号需要换成两个冒号   
                        if (str.Contains(',') || str.Contains('"') || str.Contains('
    ') || str.Contains('
    ')) //含逗号 冒号 换行符的需要放到引号中          
                        {
                            str = string.Format(""{0}"", str);
                        }
                        data += str;
                        if (j < dt.Columns.Count - 1)
                        {
                            data += ",";
                        }
                    }
                    sw.WriteLine(data);
                }
                sw.Close();
                fs.Close();
    
    
            }
    

      

  • 相关阅读:
    CSS 去掉文字选中状态
    解决MAC系统升级导致COCOAPODS失效问题
    qr-mili Tekniskt stöd
    JavaScript 随笔
    Https 单向验证 双向验证
    git 常用指令
    h5或者微信端吊起app
    创建本地服务器环境
    jenkins 关闭和重启的实现
    jenkins 忘记用户名和密码
  • 原文地址:https://www.cnblogs.com/zhuzhi0819/p/12878166.html
Copyright © 2020-2023  润新知