midrange.com code scratchpad
Name:
Q&D xlsx format export example.
Scriptlanguage:
Python
Tabwidth:
4
Date:
11/16/2021 08:49:24 pm
IP:
Logged
Description:
Q&D xlsx format export example.
Code:
  1. #!/usr/bin/env python3
  3. import ibm_db_dbi as db2
  4. import xlsxwriter as xl
  5.  
  6. query = "select cusnum, lstnam, init, cdtlmt from qiws.qcustcdt where cdtlmt > 100"
  7.  
  8.  
  9. conn = db2.connect()
  10. cur = conn.cursor()
  11. cur.execute(query)
  12.  
  13. wb = xl.Workbook('sample.xlsx')
  14. ws = wb.add_worksheet('Uno')
  15.  
  16. # Header row
  17. header = wb.add_format()
  18. header.set_bold()
  19. ws.set_row(0,None,header)
  20. ws.write(0,0,'Account')
  21. ws.write(0,1,'Last Name')
  22. ws.write(0,2,'Initials')
  23. ws.write(0,3,'Credit Limit')
  24.  
  25. for row_num, row_data in enumerate(cur):
  26.    for col_num, value in enumerate(row_data):
  27.        ws.write(row_num + 1,col_num, value)
  28.        
  29. wb.close()
© 2004-2019 by midrange.com generated in 0.006s valid xhtml & css