using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using NPOI.XSSF.UserModel;
using System.IO;
namespace readerexcel
{
class Program
{
static void Main(string[] args)
{
IWorkbook workbook = null; //新建IWorkbook对象
string fileName = "G:\\规划.xlsx";
FileStream fileStream = new FileStream(@"G:\\规划.xlsx", FileMode.Open, FileAccess.Read);
if (fileName.IndexOf(".xlsx") > 0) // 2007版本
{
workbook = new XSSFWorkbook(fileStream); //xlsx数据读入workbook
}
else if (fileName.IndexOf(".xls") > 0) // 2003版本
{
workbook = new HSSFWorkbook(fileStream); //xls数据读入workbook
}
ISheet sheet = workbook.GetSheetAt(0); //获取第一个工作表
IRow row;// = sheet.GetRow(0); //新建当前工作表行数据
//row = sheet.GetRow(1);
//for (int j = 0; j < row.LastCellNum; j++)
//{
// string cellValue = row.GetCell(j).ToString(); //获取i行j列数据
// Console.WriteLine(cellValue);
//}
//row = sheet.GetRow(3);
//for (int j = 0; j < row.LastCellNum; j++)
//{
// string cellValue = row.GetCell(j).ToString(); //获取i行j列数据
// Console.WriteLine(cellValue);
//}
//for (int i = 5; i <= sheet.LastRowNum; i++) //对工作表每一行
//{
// int k = sheet.LastRowNum;
// Console.WriteLine(k);
// row = sheet.GetRow(i); //row读入第i行数据
// if (row != null)
// {
// for (int j = 0; j < row.LastCellNum; j++) //对工作表每一列
// {
// string cellValue = row.GetCell(j).ToString(); //获取i行j列数据
// Console.WriteLine(cellValue);
// }
// }
//}
Console.ReadLine();
fileStream.Close();
}
}
}
c#读取excel
最新推荐文章于 2024-07-09 10:27:57 发布