使用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)        {            //读取Excel文件            using (Stream s = File.OpenRead("11.xls"))            {                HSSFWorkbook work = new HSSFWorkbook(s);//获取表                HSSFSheet sheet = work.GetSheetAt(0);//获取页                int rowNum = sheet.LastRowNum;//获取有多少行                StringBuilder sb = new StringBuilder();                for (int i = 0; i <= rowNum; i++)//小于等于                {                    HSSFRow row = sheet.GetRow(i);                    string str = "";                    for (int j = 0; j < row.LastCellNum; j++)//小于                    {                        HSSFCell cell = row.GetCell(j);                        //判断这个列是不是数字类型                        if (cell.CellType == HSSFCell.CELL_TYPE_NUMERIC)                        {                            str = cell.NumericCellValue + " ";                        }                        else if (cell.CellType == HSSFCell.CELL_TYPE_STRING)                        {                            str = cell.StringCellValue + " ";                        }                        sb.Append(str + " ");                    }//end for                }//end for                Console.WriteLine(sb.ToString());            }            Console.ReadKey();        }    }}