import pymysql.cursors
import xlwt


connection = pymysql.connect(host='localhost',user='root',password='',db='test',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)

print ("Подключено!!!")

try:
        with connection.cursor() as cursor:
                sql="SELECT prod_name,prod_price From products"
                cursor.execute(sql)
                print ("cursor.description: ", cursor.description)
                print()
                for row in cursor:
                                 print (row)


finally:
 connection.close()