public static void ListToExcel(List<dynamic> ts, string[] RowName, string[] ListCorrespondRow, bool IsRowName = false)

        {

            //创建工作簿对象

            IWorkbook workbook = new HSSFWorkbook();

            //创建工作表

            ISheet sheet = workbook.CreateSheet("onesheet");

            IRow row0 = sheet.CreateRow();

            for (int i = ; i < RowName.Length; i++)

            {

                row0.CreateCell(i).SetCellValue(RowName[i]);

            }

            for (int r = ; r <= ts.Count; r++)

            {

                //创建行row

                IRow row = sheet.CreateRow(r);

                dynamic tsc = ts[r-];string sJson = JsonConvert.SerializeObject(tsc);

                dynamic sObj = JsonConvert.DeserializeObject<dynamic>(sJson);

                var sObjLen = sObj.GetType().GetProperties();

                for (int j = ; j < ListCorrespondRow.Length; j++)

                {

                    //通过【】来取值  但必须要通过json转成的对象才可以这样取

                    row.CreateCell(j).SetCellValue(Convert.ToString(sObj[ListCorrespondRow[j]]));

                }

                //foreach (System.Reflection.PropertyInfo p in tsc.GetType().GetProperties())

                //{

                //    //row.CreateCell().SetCellValue(p.GetValue(tsc));

                //}

                //for (int j = 0; j < sObjLen.Length; j++)

                //{

                    //利用反射将对象里面的值添加到excel里面 添加的顺序是按照对象里面字段的顺序 注意和列名保持一致

                //    row.CreateCell(j).SetCellValue(sObjLen[j].GetValue(tsc));

                //}

            }

            //创建流对象并设置存储Excel文件的路径

            using (FileStream url = File.OpenWrite(@"C:/Users/13002/source/repos/练习/练习/WordDot/test3.xls"))

            {

                //导出Excel文件

                workbook.Write(url);

                //Response.Write("<script>alert('写入成功！')</script>");

            };

            ////workbook.Write();

            ////创建文件流

            //MemoryStream bookStream = new MemoryStream();

            ////文件写入流（向流中写入字节序列）

            //workbook.Write(bookStream);

            ////输出之前调用Seek（偏移量，游标位置) 把0位置指定为开始位置

            //bookStream.Seek(0, SeekOrigin.Begin);

            //return bookStream;

        }

foreach (System.Reflection.PropertyInfo p in tsc.GetType().GetProperties())

{

    row.CreateCell().SetCellValue(p.GetValue(tsc));

}