string ss = @"E:\二次开发\测试文件1.xls";
using (FileStream file = File.OpenRead(ss))
{
//创建工作本
IWorkbook workbook = new HSSFWorkbook(file);
//IWorkbook workbook = new XSSFWorkbook(file);
if (workbook == null)
{
MessageBox.Show("没有找到改文件");
}
MessageBox.Show(workbook.NumberOfSheets.ToString());
//得到sheet
ISheet sheet = workbook.GetSheetAt(0);
for (int i = 0; i <sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
for (int j = 0; j <row.LastCellNum; j++)
{
ICell cell = row.GetCell(j);
string sssss = cell.ToString();
MessageBox.Show(sssss);
}
//Console.WriteLine();
}
}