c#导入导出

class Program
    {
        static void Main(string[] args)
        {
            List<Student> stu = new List<Student>()
            {
                new Student{ Id=1,Name="耀",Age=56},
                new Student{ Id=1,Name="耀",Age=56},
                new Student{ Id=1,Name="耀",Age=56},
                new Student{ Id=1,Name="耀",Age=56},
                new Student{ Id=1,Name="耀",Age=56},
                new Student{ Id=1,Name="耀",Age=56},
            };
            var dic = new Dictionary<string, string>();
            dic.Add("Id", "编号");
            dic.Add("Name", "姓名");
            dic.Add("Age", "年龄");

            Expormgj(stu,@"F:\A.xls" );
            Console.Read();
            //导入

            var dic1 = new Dictionary<string, string>();
            dic1.Add("Id", "编号");
            dic1.Add("Name", "姓名");
            dic1.Add("Age", "年龄");

            Console.Read();
                  

        }

        public static void jfnf(List<Student> stusa, string FileName)
        {
            var warkwook = new HSSFWorkbook();
            var hf = warkwook.CreateSheet("Sheet");
            var sf = hf.CreateRow(0);

            var gd = sf.CreateCell(0);
            gd.SetCellValue("Id");

            var gsg = sf.CreateCell(1);
            gsg.SetCellValue("name");
           
        }
        public static void Expormgj(List<Student> stus, string FileName)
        {
            //创建工作簿
            var workbook = new HSSFWorkbook();
            //创建表
            var table = workbook.CreateSheet("sheet1");
            //创建行
            var head = table.CreateRow(0);
            //创建单元格
            var Idcell = head.CreateCell(0);
            Idcell.SetCellValue("编号");

            var Namecell = head.CreateCell(1);
            Namecell.SetCellValue("姓名");

            var agesjj = head.CreateCell(2);
            agesjj.SetCellValue("年龄");

            int i = 0;

            foreach (var s in stus)
            {
                var data = table.CreateRow(i++);

                var datacell = data.CreateCell(0);
                datacell.SetCellValue(s.Id);

                var datacell2 = data.CreateCell(1);
                datacell2.SetCellValue(s.Name);

                var datacell3 = data.CreateCell(2);
                datacell3.SetCellValue(s.Age);
            }
            using (FileStream fs = new FileStream(FileName, FileMode.Create))
            {
                workbook.Write(fs);
            }

          
        }
    }
    class Student
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }

    }