title: export data from sqlite to Excel file in multiple tabs in python
body: <pre><code>......
  ......
  ofile  = open('test.csv', "wb")
  writer = csv.writer(ofile)
  conn=sqlite3.connect('test.sqlite')
  c=conn.cursor()
  c.execute("select * from emp")
  mysel=c.execute("select * from emp")
  for row in mysel:
      print row
      writer.writerow(row)
  ofile.close()
  .....
  .....
  </code></pre>
  
  <p>above code is working fine and i am getting results as csv.</p>
  
  <p>Problem starts when i want to write data in csv in mulitple tabs. i checked on this site and people are saying there is no option. i have to use Excel.</p>
  
  <p>to get data populated in different tabs, am trying the below code with </p>
  
  <pre><code>import xlsxwriter
  ofile = xlsxwriter.Workbook('mac.xlsx')
  worksheet1 = ofile.add_worksheet()
  conn=sqlite3.connect('test.sqlite')
  c=conn.cursor()
  c.execute("select * from emp")
  mysel=c.execute("select * from emp ")
  for row in mysel:
      print row
      worksheet1.write("A1",row)
      #worksheet1.write(" ",row)
      #worksheet1.write(row)
  ofile.close()
  </code></pre>
  
  <p>no success, please help me to sort the issue, i hope my goal (<strong>write data in to excel from sqlite3 using python in multiple tabs</strong>) is clear. please share your experienced thoughts  </p>
  
  <p>1) can i do this using xlsxwriter
  2) should i use any other library 
  3) is there any simple way to do it</p>
  
  <p>please help</p>