利用数据库读写Excel文件
public DataSet ExcelToDS(string Path)
{
// string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";//版本兼容问题
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Path + ";Extended Properties=Excel 12.0;";//仿数据库连接
OleDbConnection conn2 = new OleDbConnection(strConn);//连接数据库(EXCEL)
conn2.Open();//打开连接
string strExcel