Python Imports database content into Excel

Each time the data to the operating guide, if not using tools, is directly generated in the CSV format files, such files do not support the ' sheet ', and each time there is a manual, rather unscientific, try Python to generate Excel files.

It's a bit rough, but it's a good start!

Improved version: Database content to Excel

       #!/usr/bin/env python
 
       import xlwt
       import   mysqldb
       WBK=XLWT. Workbook ()
       sheet=wbk.add_sheet (' Sheet 1 ')
       sheet.write (0,0, ' Company ')
       sheet.write (0,1, ' city ')
       Row=1
       conn=mysqldb.connect (host= ' xxx ', user= ' xxx ', passwd= ' xxx ', db= ' gh ')
       cursor=conn.cursor ()
       Cursor.execute (' select * from customers ') to
       com,city in Cursor.fetchall ():
               sheet.write (row,0,com)
               Sheet.write (row,1,city)
                row+=1
        wbk.save (city.xls
        ) cursor.close () Conn.commit () Conn.close ()