使用NPOI读Excel文件

来源：互联网发布：运动会班服创意知乎编辑：程序博客网时间：2024/05/17 09:26
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; }        }    }}
阅读全文
0 0