title: Pandas Create Excel with Table formatted as a Table
body: <p>I have a .csv file that I am converting into a table format using the following python script. In order to make this useful, I need to create a table within the Excel that holds the data (actually formatted as a table (Insert > Table). Is this possible within python? I feel like it should be relatively easy, but can't find anything on the internet. </p>
  
  <p>The idea here is that the python takes the csv file, converts it to xlsx with a table embedded on sheet1, and then moves it to the correct folder.</p>
  
  <pre><code>import os
  import shutil
  import pandas as pd
  
  src = r"C:\Users\xxxx\Python\filename.csv"
  src2 = r"C:\Users\xxxx\Python\filename.xlsx"
  
  read_file = pd.read_csv (src) - convert to Excel
  read_file.to_excel (src2, index = None, header=True)
  
  dest = path = r"C:\Users\xxxx\Python\repository"
  
  destination = shutil.copy2(src2, dest)
  </code></pre>