title: want to create excel file using python by preserving all the rows and columns in text format
body: <p>I'm trying to create an excel file using pandas, but the cells remains in general format, whereas I want all the data to be in formatted text.</p>
  
  <pre><code>df1 = pd.read_csv(file1, sep='|', dtype=str,  encoding='utf-8')
  
  writer = pd.ExcelWriter(refile1, engine='xlsxwriter', options={'encoding':'utf-8'})
  df1.to_excel(writer, sheet_name='Attendee List', startrow=3, startcol=1, index=False, header=True, encoding='utf-8',)
  workbook  = writer.book
  </code></pre>