110,530
社区成员
发帖
与我相关
我的任务
分享
try
{
//DataTable excelTable;
//创建一个数据链接
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
DataTable dt = myConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine((String)dr["TABLE_NAME"]);
}
string strCom = "select * from [" + "AAA$" + "]";
//打开数据链接,得到一个数据集
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
//创建一个 DataSet对象
DataSet myDataSet = new DataSet();
//得到自己的DataSet对象
myCommand.Fill(myDataSet, "[UDC$]");
//关闭此数据链接
myConn.Close();
//myDataSet.Tables[0].Rows[1][1] = "AAAAAA";
TxtWriter(myDataSet, Convert.ToString(File.GetLastWriteTime(path)));
}
catch
{
richTextBox1.Text = richTextBox1.Text + path + "\n";
errn += 1;
}