利用NPOI读取excel (xls 和 xlsx)
软件开发
发表时间:2016-10-05
更新时间:2016-10-06
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace TestNPOI
{
class Program
{
static void Main(string[] args)
{
//IWorkbook workbook = new HSSFWorkbook(File.OpenRead("D:/test.xls"));
IWorkbook workbook = new XSSFWorkbook(File.OpenRead("D:/test.xlsx"));
//获取excel的第一个sheet
var sheet = workbook.GetSheetAt(0);
for (int i = sheet.FirstRowNum ; i < sheet.LastRowNum; i++)
{
var row = sheet.GetRow(i);
Console.Write("Row:" + '\t');
for (int j = row.FirstCellNum; j < row.LastCellNum; j++)
{
if (row.GetCell(j) != null)
{
var cellString = row.GetCell(j).ToString();
Console.Write(cellString+'\t');
}
}
Console.WriteLine();
}
workbook = null;
sheet = null;
Console.ReadLine();
}
}
}