title: how to import data from SQLITE to excel using xlsxwriter in python
body: <pre><code>import sqlite3
  from xlsxwriter.workbook import Workbook
  workbook = Workbook('output2.xlsx')
  worksheet = workbook.add_worksheet()
  
  conn=sqlite3.connect('test.sqlite')
  c=conn.cursor()
  c.execute("select * from abc")
  mysel=c.execute("select * from abc ")
  for row in mysel:
   print row
   worksheet.write(0, 0, row[0])
  workbook.close()
  </code></pre>
  
  <p>here is layout of SQLITE database table</p>
  
  <pre><code>id  sno
  1   100
  2   200
  3   300
  4   400
  </code></pre>
  
  <p>with worksheet.write(0, 0, row[0]) i get output as <strong>4</strong> in First cell of excel file.</p>
  
  <p>with worksheet.write(0, 0, row[1]) i get output as <strong>400</strong> in First cell of excel file</p>
  
  <p>am not able to figure out the <strong>FOR LOOP</strong> issue. </p>
  
  <p>please help</p>