C# Excel 讀取 NPOI

NPOI載點:http://npoi.codeplex.com/
只限分析.xls格式

string strFilePath = string.Format(@"D:\old桌面\testWed2\NewFolder\test1.xls");
HSSFWorkbook wk;

using (FileStream fs = new FileStream(strFilePath, FileMode.Open))
{
    wk = new HSSFWorkbook(fs);
}

//取得sheet名稱
HSSFSheet hst;
hst = (HSSFSheet)wk.GetSheetAt(0);
string strSheetname = hst.SheetName;

//單行單行的取得sheet理的資料
HSSFRow hr;
hr = (HSSFRow)hst.GetRow(0);

string a = hr.Cells[0].ToString();
string b = hr.Cells[1].ToString();