NPOI读取Excel，导入数据到Excel练习01

NPOI 2.2.0.0,初级读取导入Excel

1.读取Excel，将数据绑定到dgv上

        private void button1_Click(object sender, EventArgs e)
        {
            List<Book> books = new List<Book>();
            //1.读取Excel文件
            using (FileStream fsReder = File.OpenRead("练习.xlsx"))
            {
                //2.创建工作簿
                IWorkbook wk = new XSSFWorkbook("练习.xlsx");
                //IWorkbook wk=new XSSFWorkbook(fsReder);
                //获取第一个工作表
                ISheet sheet = wk.GetSheetAt(0);
                //3.遍历每一行,行和列的索引都是从0开始
                for (int i = 3; i < sheet.LastRowNum; i++)
                {
                    IRow row = sheet.GetRow(i);
                    //MessageBox.Show(row.GetCell(0).ToString());
                    //4.读取每一行的数据，加到对象中
                    books.Add(new Book()
                    {
                        Name = row.GetCell(0).ToString(),
                        One = row.GetCell(1).ToString(),
                        Two = row.GetCell(2).ToString(),
                        Three = row.GetCell(3).ToString(),
                        Four = row.GetCell(4).ToString(),
                        Five = row.GetCell(5).ToString(),
                        Six = row.GetCell(6).ToString(),

                    });
                }
            }
            //5.绑定数据
            dgv.DataSource = books;
            dgv.AutoGenerateColumns = false;
            dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            MessageBox.Show("操作完成");
        }

　　2.将数据导入到Excel中

        private void button2_Click(object sender, EventArgs e)
        {
            List<Book> books = new List<Book>()
            {
                new Book() {Name = "火影忍者",One  ="34",Two = "56",Three = "67",Four = "78",Five = "99",Six = "54"},
                new Book() {Name = "海贼王",  One ="64",Two = "79",Three = "97",Four = "74",Five = "29",Six = "56"},
                new Book() {Name = "死神",One  ="94",Two = "51",Three = "57",Four = "64",Five = "90",Six = "74"},
                new Book() {Name = "游戏王",One  ="94",Two = "30",Three = "56",Four = "45",Five = "58",Six = "46"},
            };
            //1.创建工作簿
            using (FileStream fsWrite = File.OpenWrite("1.xlsx"))
            {
                IWorkbook wk = new XSSFWorkbook();
                //2.创建第一个工作表
                ISheet sheet = wk.CreateSheet("第一张表");
                //第一行设置标题
                IRow rowHead = sheet.CreateRow(0);

                rowHead.CreateCell(0).SetCellValue("图书名");                
                rowHead.CreateCell(1).SetCellValue("一月");              
                rowHead.CreateCell(2).SetCellValue("二月");           
                rowHead.CreateCell(3).SetCellValue("三月");
                rowHead.CreateCell(4).SetCellValue("四月");
                rowHead.CreateCell(5).SetCellValue("五月");
                rowHead.CreateCell(6).SetCellValue("六月");

                //3.在工作表的最后一行下，循环创建工作表的每一行，添加数据
                for (int i = 1; i < books.Count; i++)
                {
                    IRow row = sheet.CreateRow(i);
                    row.CreateCell(0).SetCellValue(books[i].Name);
                    row.CreateCell(1).SetCellValue(books[i].One);
                    row.CreateCell(2).SetCellValue(books[i].Two);
                    row.CreateCell(3).SetCellValue(books[i].Three);
                    row.CreateCell(4).SetCellValue(books[i].Four);
                    row.CreateCell(5).SetCellValue(books[i].Five);
                    row.CreateCell(6).SetCellValue(books[i].Six);
                }
                wk.Write(fsWrite);
            }

            MessageBox.Show("操作完成");
        }