print ("cursor.description: ", cursor.description)
print()
for row in cursor:
  print (row)

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()

from sqlalchemy import create_engine
import pymysql
import pandas as pd

conn = create_engine('mysql+pymysql://mysql_user:mysql_password@mysql_host/mysql_db')

df = pd.read_sql("SELECT * FROM table_name WHERE ...", conn)
df.to_excel(r'/path/to/result.xlsx', index=False)