midrange.com -- source code scratchpad

midrange.com code scratchpad

Name:

python on IBM i

Scriptlanguage:

Python

Tabwidth:

Date:

11/13/2015 10:17:39 pm

IP:

Logged

Description:

my first try at python3 to xlsx
need to install xlsxwriter and supply userid and password

I think all the formatting holds....

Code:


    import ibm_db                                       

    import xlsxwriter                                   

                                                        

    db_name  = '*LOCAL'                                 

    username = 'USERID'                                

    password = 'PASSWORD'                               

                                                        

    wb = xlsxwriter.Workbook('/tmp/example-qcustcdt.xlsx')     

    ws = wb.add_worksheet('QCustCDT')                   

                                                        

    conn = ibm_db.connect(db_name, username, password)  

    sql = 'SELECT * FROM QIWS.QCUSTCDT'                 

    if conn:                                            

      stmt = ibm_db.exec_immediate(conn, sql)           

      num_columns = ibm_db.num_fields(stmt)             

      for num in range(0, num_columns):                      

        ws.write_string(0, num, ibm_db.field_name(stmt, num))

      x=1                                                    

      while ibm_db.fetch_row(stmt):                          

        for num in range(0, num_columns):                    

          bd  = ibm_db.result(stmt, num)                     

          ws.write_string(x, num, str(bd))                   

        x+=1                                                 

    else:                                                    

     print('Connection Failed')                              

                                                             

    ibm_db.close(conn)                                       

    wb.close()

generated in 0.013s

valid xhtml & css