代码 import pandas as pd import pymysql conn = pymysql.connect( user="root", password="Chinais9?", database="test", charset="utf8" ) df = pd.read_sql( "select * from journal limit 100", con=conn ) df.to_excel("期刊100.xlsx", index=False)