美文网首页
C# 导出数据成CSV文件

C# 导出数据成CSV文件

作者: Will_板凳 | 来源:发表于2020-03-26 22:17 被阅读0次
     public bool ExportPatientStatisticsDetails(ExportPatientDetailDto patientDetails)
            {
                try
                {
                    var patientList = patientDetails.PatientTableList;
    
                    if (File.Exists(@"D:\患者统计表.csv"))
                    {
                        File.Delete(@"D:\患者统计表.csv");
                    }
                    StringBuilder strColu = new StringBuilder();
                    StringBuilder strValue = new StringBuilder();
                    StreamWriter sw = new StreamWriter(new FileStream(@"D:\患者统计表.csv",FileMode.CreateNew),Encoding.GetEncoding("GB2312"));
                    strColu.Append("部位,患者数,比例");
                    sw.WriteLine(strColu);
                    foreach (var dr in patientList)
                    {
                        strValue.Remove(0, strValue.Length);//移出
                        strValue.Append(dr.NameOfDistributionType + ",");
                        strValue.Append(dr.NumberOfPatients + ",");
                        strValue.Append(dr.Proportion);
                        sw.WriteLine(strValue);
                    }
                    sw.Close();
                    return  true;
    
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                    return false;
                }
    
            }
    

    备注:

    传入的参数类,可根据需求定制

     public class ExportPatientDetailDto
        {
            public List<PatientStatisticsOutputDto> PatientTableList { get; set; }
        }
    
    public class PatientStatisticsOutputDto
        {
            public string NameOfDistributionType { get; set; }
    
            public int NumberOfPatients { get; set; }
    
            public double Proportion { get; set; }
    
        }
    

    相关文章

      网友评论

          本文标题:C# 导出数据成CSV文件

          本文链接:https://www.haomeiwen.com/subject/hzwhuhtx.html