C# execl 导入

最新推荐文章于 2024-10-21 15:06:42 发布

iteye_3657

最新推荐文章于 2024-10-21 15:06:42 发布

阅读量98

点赞数

CC 4.0 BY-SA版权

文章标签： C C++ C# Excel Microsoft

本文链接：https://blog.youkuaiyun.com/iteye_3657/article/details/81880812

读取：将Excel中的数据读入到 DataSet 中

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;

class ExcelReader
{
private DataSet myData;

public ExcelReader(String Path)
{
String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + ";Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strConn);
String strCom = "SELECT * FROM [Sheet1$]";
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
myData = new DataSet();
myCommand.Fill(myData, "[Sheet1$]");
myConn.Close();
}

public DataSet GetData()
{
return myData;
}
}