title: Python, Excel, and SQLlite3
body: <p>I'm struggling with a particular script, I've tried googling the problem but I've become stuck...</p>
  
  <p>I was wondering if anyone could possibly help me out with the SQL formulas. I've posted this to Reddits r/python as well, and post any answer found there, here for those who may need it in the future!</p>
  
  <p>The current script is here: <a href="https://gist.github.com/adamrees89/b73a60bc01170601ced7adc7a8e971f7" rel="nofollow noreferrer">https://gist.github.com/adamrees89/b73a60bc01170601ced7adc7a8e971f7</a></p>
  
  <p>At the moment, the script reads a sample excel file, reads the value and formatting of all the cells on each sheet and records the values and formatting to an SQLlite3 file.</p>
  
  <p>Currently, the script reads all the values and formatting fine, creates a table within SQL for each sheet with no problems (Confirmed this with DB Browser for SQLite), but there are no rows of data within the tables.</p>
  
  <p>I think there is a problem with my 'templateCell()' function:</p>
  
  <pre><code>def templateCell(s,sn,c,r):
  #__init__ will gather the cell format data
  cellRef = c + r
  val = s[cellRef].value
  fname = s[cellRef].font.name
  fsize = s[cellRef].font.size
  fbold = int(s[cellRef].font.bold == 'true')
  fital = int(s[cellRef].font.italic == 'true')
  ccolour = s[cellRef].fill.start_color.index
  print("Cell Reference is: {},".format(cellRef))
  c.execute("INSERT INTO {tn} VALUES ({a},{b},{c},{d},{e},{f})".format(tn=sn,a=cellRef,b=val,c=fname,d=fbold,e=fital,f=ccolour))
  </code></pre>
  
  <p>Or more specifically the c.execute function on line 11, where it is supposed to create the row in the database for each cell. Variables are:</p>
  
  <pre><code>s = sheet
  sn =  sheetname (function of sheet)
  c = column
  r = row
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Edit 1: The Excel file is available here: <a href="https://github.com/adamrees89/WindowsContextMenuTools/files/1238849/testExcel.xlsx" rel="nofollow noreferrer">testExcel.xlsx</a></p>