title: C# wrap text programmatically from excel
body: <p>I have a c# console program that downloads an <code>.xls</code> file that gets converted to <code>.csv</code> file using </p>
  
  <pre><code>string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + sourceFile + ";" + "Extended Properties=\"Excel 8.0;HDR=Yes;\"";
  
  OleDbConnection conn = null;
  StreamWriter wrtr = null;
  OleDbCommand cmd = null;
  OleDbDataAdapter da = null;
  try
  {
      conn = new OleDbConnection(strConn);
      conn.Open();
  
  
      cmd = new OleDbCommand("SELECT * FROM [" + worksheetName + "$]", conn);
      cmd.CommandType = CommandType.Text;
      wrtr = new StreamWriter(targetFile);
  
      da = new OleDbDataAdapter(cmd);
      DataTable dt = new DataTable();
      da.Fill(dt);
  </code></pre>
  
  <p>In one of the columns, the text needs to be word wrapped. How can I do that? Data looks like this</p>
  
  <p><code>"The District of Columbia<br>
  ZIP 11101.<br>
  "</code><br>
  The column should actually be <code>"The District of Columbia ZIP 11101."</code></p>