【.NET】C# List导出为Excel方法

        /// 

        /// list导出为Excel
        /// 
        /// 
        /// 
        public static void DataExport(List list, string filePath)
        {
            if (list.Count > 0)
            {
                //用于创建文件
                using (FileStream fileStream = new FileStream(filePath, FileMode.OpenOrCreate))
                {
                    //用于写入内容
                    using (StreamWriter streamWriter = new StreamWriter(new BufferedStream(fileStream), Encoding.Default))
                    {
                        //表头
                        string tbhead = "";
                        var entity = list[0].GetType();
                        PropertyInfo[] piList = entity.GetProperties();
                        foreach (PropertyInfo pi in piList)
                        {
                            tbhead += pi.Name + "t";
                        }
                        //取完表头，换行
                        tbhead = tbhead.Substring(0, tbhead.Length - 1) + "n";
                        //表头写入
                        streamWriter.Write(tbhead);
                        foreach (var v in list)
                        {
                            string tbbody = "导入数据";
                            StringBuilder tbBody = new StringBuilder();
                            for (int i = 0; i < piList.Length; i++)
                            {

                                object value = piList[i].GetMethod.Invoke(v, null);
                                tbBody.Append(value);//内容
                                tbBody.Append("t");//自动跳到下一单元格

                            }
                            tbbody = tbBody.ToString();
                            tbbody = tbbody.Substring(0, tbbody.Length - 1) + "n";//取完一行内容，换行
                            streamWriter.Write(tbbody);//内容写入
                        }
                    }
                }
            }
        }

通过List导出到excel其中列的名称为List中接受的泛型集合对象的属性名称