private void button1_Click(object sender, EventArgs e)
{
try
{
string strConn;
strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source = c:\Users\Administrator\Desktop\cstest.xlsx;Extended Properties='Excel 8.0;HDR=no;IMEX=1'";
OleDbConnection OleConn = new OleDbConnection(strConn);
OleConn.Open();
String sql = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
DataSet OleDsExcle = new DataSet();
OleDaExcel.Fill(OleDsExcle, "Sheet1");
DataTable dt = OleDsExcle.Tables[0]; string fn = @"C:\Users\Administrator\Desktop\txt.txt";
StreamReader sr = new StreamReader(fn, Encoding.GetEncoding("gb2312"));
string s = sr.ReadToEnd();
sr.Dispose();
StreamWriter sw = new StreamWriter(fn); int w;
int i;
string t;
for (i = 0; i <= 6; i++)
{ t = dt.Rows[i][3].ToString();
w = s.IndexOf(t);
s.Remove(w, t.Length); }
sw.WriteLine(s);
sw.Flush();
sw.Close();
OleConn.Close();
}
catch (Exception ex)
{
label1.Text = ex.Message;
}
}我txt.txt文件内容为:老虎老鼠长颈鹿鸟猴子大象长颈鹿猫
excel的D列为老虎 长颈鹿 老鼠 猫 长颈鹿 大象 猴子 我希望操作之后,txt.txt文件的内容被删除只剩下:鸟
调试发现s的内容有问题,大家帮忙看看。
{
try
{
string strConn;
strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source = c:\Users\Administrator\Desktop\cstest.xlsx;Extended Properties='Excel 8.0;HDR=no;IMEX=1'";
OleDbConnection OleConn = new OleDbConnection(strConn);
OleConn.Open();
String sql = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
DataSet OleDsExcle = new DataSet();
OleDaExcel.Fill(OleDsExcle, "Sheet1");
DataTable dt = OleDsExcle.Tables[0]; string fn = @"C:\Users\Administrator\Desktop\txt.txt";
StreamReader sr = new StreamReader(fn, Encoding.GetEncoding("gb2312"));
string s = sr.ReadToEnd();
sr.Dispose();
StreamWriter sw = new StreamWriter(fn); int w;
int i;
string t;
for (i = 0; i <= 6; i++)
{ t = dt.Rows[i][3].ToString();
w = s.IndexOf(t);
s.Remove(w, t.Length); }
sw.WriteLine(s);
sw.Flush();
sw.Close();
OleConn.Close();
}
catch (Exception ex)
{
label1.Text = ex.Message;
}
}我txt.txt文件内容为:老虎老鼠长颈鹿鸟猴子大象长颈鹿猫
excel的D列为老虎 长颈鹿 老鼠 猫 长颈鹿 大象 猴子 我希望操作之后,txt.txt文件的内容被删除只剩下:鸟
调试发现s的内容有问题,大家帮忙看看。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货