C#用NPOI读取excel

private static void GetPostAreaDic() { PostAreaDic.Clear(); string filepath = GetPostAreaExcel();//获取文件绝对路径 if (System.IO.File.Exists(filepath)) { using (Stream st = new System.IO.FileStream(filepath, FileMode.Open)) { NPOI.HSSF.UserModel.HSSFWorkbook workbook = new NPOI.HSSF.UserModel.HSSFWorkbook(st); for (int page = 0; page < 4; page++)//excel文件的工作表 { ISheet sheet = workbook.GetSheetAt(page); for (int i = 1; i <= sheet.LastRowNum; i++)//当前工作区的所有行 { IRow row = sheet.GetRow(i); double post = row.GetCell(1).NumericCellValue;//获取第i列的值(这里是数值类型) if (post < 100000) break; if (post > 0) { if (!PostAreaDic.ContainsKey(post)) { PostAreaDic.Add(post, page + 1); } } } } } } }