最近一直在处理工作表的问题,其间用到了C#读取表中数据的问题,其方法如下:
using Data=System.Data;
/// <summary>
/// 获取某个工作表中的数据
/// </summary>
/// <param name="fileName">文件名称及路径</param>
/// <param name="queryWorkSheetName">查询的工作表</param>
/// <returns>获取到的数据</returns>
public Data.DataTable GetDataFromWorkSheet(string fileName, string queryWorkSheetName)
{
Data.DataTable dtResult = null;
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=No; IMEX=1;\"";
string query = "select * from [" + queryWorkSheetName + "$]";
try
{
using (OleDbCommand oleCommand = new OleDbCommand(