2021-3-9 保存scv格式文件

publicvoidSaveCSV(DataTabledt,string fullPath)
        {
            FileInfo fi =newFileInfo(fullPath);
if(!fi.Directory.Exists)
            {
                fi.Directory.Create();
            }
            FileStream fs =new FileStream(fullPath, System.IO.FileMode.Create, System.IO.FileAccess.Write);
            //StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.UTF8);
            string data = "";
//寫出列名稱for(int i = 0; i < dt.Columns.Count; i  )
            {
                data =dt.Columns[i].ColumnName.ToString();
if (i < dt.Columns.Count - 1)
                {
                    data =",";
                }
            }

            sw.WriteLine(data);
            //寫出各行數據for(int i = 0; i < dt.Rows.Count; i  )
            {
                data ="";
for(int j = 0; j < dt.Columns.Count; j  )
                {
                    stringstr= dt.Rows[i][j].ToString();
                    str = str.Replace("\"","\"\"");//替換英文冒號 英文冒號需要換成兩個冒號if(str.Contains(',') || str.Contains('"') || str.Contains('\r') || str.Contains('\n'))//含逗號 冒號 換行符的需要放到引號中                    {
                        str =string.Format("\"{0}\"", str);
                    }

                    data =str;
if (j < dt.Columns.Count - 1)
                    {
                        data =",";
                    }
                }
                sw.WriteLine(data);
            }
            sw.Close();
            fs.Close();
        }

下方是button的click事件

privatevoidSaveBtn_Click(object sender, EventArgs e)
        {
            var pList = xmlHelp.XmlDeSerializer("User");//序列化獲取list數據，可用其他方法創建表格，xmlHelp是一個類
            DataTable dt =new DataTable();
            dt.Columns.Add("姓名",typeof(string));
            dt.Columns.Add("性別",typeof(string));
            dt.Columns.Add("年齡",typeof(string));
            dt.Columns.Add("編號",typeof(string));

foreach(varitemin pList)
            {
                dt.Rows.Add(item.Name, item.Sex, item.Age, item.Id);
            }

            xmlHelp.SaveCSV(dt, "Use");//縂之衹要調用SaveCSV添加datatable和string格式的路逕命名即可保存

}