Question

C#如何高效读取EXCEL文件

Answer 1

List<Employee> employeeList = new List<Employee>(); DataTable ExcelTable;
string sExcelFile = @"E:\documents\data.xls";
ExcelData excelData = new ExcelData();
string tableName = "num$";//schemaTable.Rows[2][2].ToString().Trim(); ;//获取 Excel 的表名，默认值是sheet1
ExcelTable = excelData.GetExcelData(sExcelFile, tableName);
int i = 0;
int comp = 0;
foreach (DataRow dr in ExcelTable.Rows)
{
if (i == 0)//第一行为标题 {
int count=dr.ItemArray.Count();
for (int j = 0; j < count; j++)
{
if ("CompName".Equals(dr[j].ToString()))
{
comp = j;
break;
}
}
i++; continue; }

if (dr.Table.Rows.Count < 1)
{
break;
}
Employee e = new Employee(); if (!string.IsNullOrEmpty(dr[comp].ToString())) {
e.EmployeeTel = dr[comp].ToString();
}employeeList .Add(e);

Answer 2

搜索下NPOI