title: Python xlwings copy paste with format
body: <p>Apologies for no coding provided, this is really a generic question.</p>
  
  <p>I'm using Python xlwings library, and trying to copy a sheet from one workbook to another new workbook, then hard-code the sheet in the newly created workbook. Effectively same as "Copy / Paste Values and source formatting".</p>
  
  <p>I wasn't able to find any documentation on this, and thank you in advance for your help!</p>
  
  <p>edit: someone mentioned that I should include an example. Here it is but it's kind hard to show the format in an Excel file. the following code will copy/paste "sht" into a new workbook but the "new_sht" will contain formulas. I'm trying to hard-code all the values while preserving the number format (eg. with thousands separator, percentage sign, etc)</p>
  
  <pre><code>import xlwings as xw
  wb = xw.Book('example1.xlsx')
  sht = wb.sheets['sheet1']
  new_wb = xw.Book()
  new_sht = new_wb.sheets[0]
  sht.api.Copy(Before = new_sht.api)
  </code></pre>