/// <summary>//From:www.uzhanbao.com
/// 读取不规则的EXcel数据
/// </summary>
/// <param name="filepath"></param>
/// <returns></returns>
protected DataSet ReadExcelData(string filepath)
{
string connStr = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source=" + filepath + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
string sql_F = "SELECT * FROM [{0}]";
System.Data.OleDb.OleDbConnection conn = null;
System.Data.OleDb.OleDbDataAdapter da = null;
System.Data.DataTable tblSchema = null;
System.Collections.Generic.IList<string> tblNames = null;
conn = new System.Data.OleDb.OleDbConnection(connStr);
C#读取不规则的EXcel数据
最新推荐文章于 2023-05-26 16:51:08 发布