c# 中wpfexcel_C# WPF 读写Excel文件

public classExcelHelper : IDisposable

{private string fileName = null; //文件名

private IWorkbook workbook = null;private FileStream fs = null;private booldisposed;public ExcelHelper(string fileName)//构造函数，读入文件名

{this.fileName =fileName;

disposed= false;

}///将excel中的数据导入到DataTable中/// excel工作薄sheet的名称

/// 第一行是否是DataTable的列名

/// 返回的DataTable

public DataTable ExcelToDataTable(string sheetName, boolisFirstRowColumn)

{

ISheet sheet= null;

DataTable data= newDataTable();int startRow = 0;try{

fs= newFileStream(fileName, FileMode.Open, FileAccess.Read);

workbook=WorkbookFactory.Create(fs);if (sheetName != null)

{

sheet=workbook.GetSheet(sheetName);//如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheet

if (sheet == null)

{ <