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的内容有问题,大家帮忙看看。