使用NPOI读Excel文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop.Excel;
using NPOI.HSSF.UserModel;
using System.IO;

namespace NPOIDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            //创建一个工作表
            HSSFWorkbook work = new HSSFWorkbook();
            //创建一个页
            HSSFSheet sheet = work.CreateSheet();
            //创建一个行
            List<Person> list = new List<Person>();
            list.Add(new Person() { Age = 18, Name = "张三" });
            list.Add(new Person() { Age = 19, Name = "李四" });
            list.Add(new Person() { Age = 5, Name = "王五" });

            for (int i = 0; i < list.Count; i++)
            {
                Person p = list[i];
                HSSFRow row = sheet.CreateRow(i);
                row.CreateCell(0, HSSFCell.CELL_TYPE_NUMERIC).SetCellValue(p.Age);
                row.CreateCell(1, HSSFCell.CELL_TYPE_STRING).SetCellValue(p.Name);
            }

            using (Stream s = new FileStream("Demo.xls", FileMode.OpenOrCreate))
            {
                work.Write(s);
            }
            Console.WriteLine("ok");
            Console.ReadKey();
        }
    }

    public class Person
    {
        private string _name;

        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }

        private int _age;

        public int Age
        {
            get { return _age; }
            set { _age = value; }
        }
    }
}