解析excel表格为DataSet

最新推荐文章于 2021-04-30 16:24:35 发布

weixin_30641465

最新推荐文章于 2021-04-30 16:24:35 发布

阅读量74

点赞数

原文链接：http://www.cnblogs.com/zhang-wenbin/p/5773595.html

版权

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using Log;
namespace Common
{
public class ExcelInputHelper
{
public static ExcelInputHelper Self = new ExcelInputHelper();

public static DataSet ExecleDataSet(string filePath)
{
string OleDbConnection = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filePath + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
OleDbConnection conn = new OleDbConnection(OleDbConnection);
try
{
conn.Open();
}
catch (Exception ee)
{
if (ee.Message.Contains("外部表不是预期的格式"))
{
OleDbConnection = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + filePath + ";Extended Properties='Excel 12.0; HDR=YES; IMEX=1'";
conn.ConnectionString = OleDbConnection;
conn.Open();
}
else
{
Log.Log4NetUtility.Error(Self, "无法打开文件");
return null;
}
}

DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
odda.Fill(ds);
conn.Close();
return ds;
}
}
}

转载于:https://www.cnblogs.com/zhang-wenbin/p/5773595.html