c#如何获取Excel指定多列的值
展开全部
直接读取Excel啊。
网上有很多的代码。
大概代码可以如下:
string connString = "Driver={Driver do Microsoft Excel(*.xls)};DriverId=790;SafeTransactions=0;ReadOnly=1;MaxScanRows=16;Threads=3;MaxBufferSize=2048;UserCommitSync=Yes;FIL=excel 8.0;PageTimeout=5;";
connString += "DBQ=" + this.txtEmailList.Text.Trim();
OdbcConnection conn = new OdbcConnection(connString);
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = conn;
string sql = "select * from [Sheet1$]";
cmd.CommandText = sql;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
StringBuilder sb = new StringBuilder();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strEmail = ds.Tables[0].Rows[i]["次数"].ToString().Trim();
}
希望楼主早日解决问题。。。。
网上有很多的代码。
大概代码可以如下:
string connString = "Driver={Driver do Microsoft Excel(*.xls)};DriverId=790;SafeTransactions=0;ReadOnly=1;MaxScanRows=16;Threads=3;MaxBufferSize=2048;UserCommitSync=Yes;FIL=excel 8.0;PageTimeout=5;";
connString += "DBQ=" + this.txtEmailList.Text.Trim();
OdbcConnection conn = new OdbcConnection(connString);
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = conn;
string sql = "select * from [Sheet1$]";
cmd.CommandText = sql;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
StringBuilder sb = new StringBuilder();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strEmail = ds.Tables[0].Rows[i]["次数"].ToString().Trim();
}
希望楼主早日解决问题。。。。
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询