Advertisement
Guest User

Untitled

a guest
May 1st, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1. #!/usr/bin/python
  2. # -*- coding: utf-8 -*-
  3.  
  4. #import psycopg2
  5. import sys
  6. import xlwt
  7.  
  8. con = None
  9.  
  10. '''try:
  11.    i=0
  12.    con = psycopg2.connect(database="testdb", user="postgres", password="pass123",  port="5432")
  13.  
  14.    cur = con.cursor()
  15.    cur.execute("SELECT * FROM company")'''
  16. kh = "Khouloud"
  17. aj = "AJMI"
  18. workbook = xlwt.Workbook()
  19. sheet = workbook.add_sheet("Sheet Name")
  20. '''while True:
  21.    
  22.        row = cur.fetchone()
  23.      
  24.        if row == None:
  25.            break
  26.          
  27.    print row[0], row[1], row[2]'''
  28. sheet.write(1,0, kh)
  29. sheet.write(1,1, aj)
  30. #    sheet.write(i,2, row[2])
  31. #    i+=1
  32. workbook.save("kh.xls")
  33. '''except psycopg2.DatabaseError, e:
  34.    print 'Error %s' % e    
  35.    sys.exit(1)
  36.  
  37.  
  38. finally:
  39.  
  40.    if con:
  41.        con.close()'''
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement