一个通用的List集合导出excel的通用方法

        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(0);
            for (int i = 0; i < rowname.length; i++)
            {
                row0.createcell(i).setcellvalue(rowname[i]);
            }
            for (int r = 1; r <= ts.count; r++)
            {
                //创建行row
                irow row = sheet.createrow(r);
                dynamic tsc = ts[r-1];string sjson = jsonconvert.serializeobject(tsc);
                dynamic sobj = jsonconvert.deserializeobject<dynamic>(sjson);
                var sobjlen = sobj.gettype().getproperties();
                for (int j = 0; 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));
}