柚子@2010

因为他们运行时容器是不同的，之间的缓存很难交互。

注意，虽然可以OleDb的方式读取，但是读取的时候顺序可能和Excel文件不一样，如第一个遇到的表未必是Excel文件中第一个表，第一个读到的列未必是表中的第一列。
万无一失的办法是用Excel的COM控件
简单封装了一个类似SqlDataReader的类，注意要引用Excel的COM库，Microsoft Excel12.0 Object Library
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Microsoft.Office.Interop.Excel;
using System.Reflection;
using ICMS.Ut.Utility;

namespace ICMS.Ut.FileUtility
{
/// <summary>
/// 模拟读取一个Excel文件
/// </summary>
public class ExcelDataReader : IDisposable
{
private Application app = null;
private Workbook wb = null;
private Worksheet sheet = null;
private string[] rowContents = null;
private int r = 0;
private int rowCnt = 0;
private int columnCnt = 0;

public int RowCnt
{
get { return rowCnt; }
}

public int ColumnCnt
{
get { return columnCnt; }
}

public string GetString(int k)
{
if (k >= columnCnt)
return null;
else
return rowContents[k];
}

public bool Read()
{
if (r >= rowCnt)
return false;
else
{
bool flag = false;
for (int i = 0; i < columnCnt; i++)
{
rowContents[i] = readContent(r, i);
if (!Checker.IsNullOrEmpty(rowContents[i]))
flag = true;
}
if (!flag)
{
rowCnt = r;
return false;
}
else
{
r++;
return true;
}
}
}

private string readContent(int r, int c)
{
Range range = (Range)(sheet.Cells[r + 1, c + 1]);
if (range.Value2 == null)
return null;
else
return range.Value2.ToString().Trim();
}

public ExcelDataReader(string filePath, IList<string> head)
{
app = new Application();
wb = app.Workbooks.Open(filePath, Type.Missing, true, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
sheet = (Worksheet)wb.Sheets[1];
rowContents = new string[sheet.Columns.Count];

rowCnt = sheet.Rows.Count;
columnCnt = sheet.Columns.Count;

for (int i = 0; i < sheet.Columns.Count; i++)
{
string v = readContent(0, i);
if (Checker.IsNullOrEmpty(v))
{
columnCnt = i;
break;
}
else head.Add(v);
}

r = 1;
}

#region IDisposable 成员

public void Dispose()
{
if (wb != null)
{
wb.Close(Type.Missing, Type.Missing, Type.Missing);
wb = null;
}
if (app != null)
{
app.Quit();
app = null;
}
}

#endregion
}
}