title: Opening .dat (tab delimited file) in Excel, save as .xls
body: <p>I am trying to open a .dat file in Excel, which is tab delimited, and then have it save out as a .xls file.</p>
  
  <p>So far, I can read in the file and save it as the .xls file but for some reason, all the values are in the first column and it does not tab delimit them.</p>
  
  <p>(If I open up the file in Excel without my program, it tab-delimits perfectly)</p>
  
  <p>These are the two lines of code that I am using to open and resave the file.</p>
  
  <pre><code>xlWorkBook = xlApp.Workbooks.Open(f, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);  
  xlWorkBook.SaveAs(filename + ".xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
  </code></pre>