static DataSet Parse(string fileName)
{
string connectionString = string.Format("provider=Microsoft.Jet.OLEDB.4.0; data source={0};Extended Properties=Excel 8.0;", fileName);
DataSet data = new DataSet();
foreach (var sheetName in GetExcelSheetNames(connectionString))
{
using (OleDbConnection con = new OleDbConnection(connectionString))
{
var dataTable = new DataTable();
string query = string.Format("SELECT * FROM [{0}]", sheetName);
con.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(query, con);
adapter.Fill(dataTable);
data.Tables.Add(dataTable);
}
}
return data;
}
static string[] GetExcelSheetNames(string connectionSt
C#导入Excel到DataSet(客户端无需安装Office)
最新推荐文章于 2024-07-09 10:27:57 发布
该篇博客介绍了如何在C#中使用OleDb连接读取Excel文件内容到DataSet,无需客户端安装Office。通过`Parse`方法和`GetExcelSheetNames`方法,可以遍历并导入Excel所有工作表的数据。
摘要由CSDN通过智能技术生成