title: how to change excel column format in text when i use streamwriter to create a excel file in c#
body: <p>how to change excel column format in text when i use streamwriter to create a excel file in c#
  here is my code</p>
  
  <pre><code>           `string p1 = @"C:\\EXCEL\\DATA\\data" + System.DateTime.Now.ToString("dd-MM-yyyy HH-mm-ss") + ".xls";
              System.IO.FileInfo objFileInfo = new System.IO.FileInfo(p1);
              StreamWriter wr = new StreamWriter(p1);
              cmd = new OracleCommand("here is my query",con);
              DataTable dt = new DataTable();
              DataSet DS = new DataSet();
              OracleDataAdapter AD = new OracleDataAdapter(cmd);
              OracleDataAdapter da = new OracleDataAdapter(cmd);
              da.Fill(dt);
              da.Fill(DS);
              for (int i = 0; i &lt; (DS.Tables[0].Rows.Count); i++)
                   {
                      for (int j = 0; j &lt; dt.Columns.Count; j++)
                           {
                             if (dt.Rows[i][j] != null)
                                 {
                                   wr.Write(Convert.ToString(dt.Rows[i][j]).ToString() + "\t");
                                  }
                                  else
                                  {
                                    wr.Write("\t");
                                  }
                              }
                              wr.WriteLine();
                           }`
  </code></pre>
  
  <p>please suggess
  thanks in advance</p>