title: How to write an data array to excel in a row instead of in a column using pandas in Python
body: <pre><code>a= [1,2,3,4,5]
  df=DataFrame(a)
  </code></pre>
  
  <p>.... #setup excelwriter and dataframe</p>
  
  <pre><code>df.to_excel(writer, sheet_name=sheetname,startrow=1, startcol=1, header=False, index=False)
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>1\n
  2\n
  3\n
  4\n
  5
  </code></pre>
  
  <p>How can I get output as:</p>
  
  <pre><code>1    2    3    4    5
  </code></pre>