Question 113220 in Mysql Question posted in
The official MySQL documentation can be found here.

How to export mysql data as xlsx?

How to export the data from mysql as xlsx, mysql workbranch only support export as CSV as i see in workbranch.
I wan to have some programme which can directly get an mysql stored procedures result as .XLSX format file. Any Idea?

Tags:

3

Answers


  1. 0

    If you’re using python, you can use pandas to read the MySQL database into a dataframe and then export it to an excel file using the to_excel function.

    Login or Signup to reply.
  2. 0

    This worked for me — You need to create the csv file first

    import mysql.connector

db= mysql.connector.connect(host='localhost',user='username',
      password='password',
      database="dbname")

cur=db.cursor()

QUERY='SELECT * FROM tablename;'

cur.execute(QUERY)
result=cur.fetchall()
path = "..."
result.to_csv(f"{path}.csv")
    Login or Signup to reply.
  3. 0

    SELECT actor.actor_id
    ,actor.first_name
    ,actor.last_name
    ,actor.last_update
    FROM sakila.actor
    INTO OUTFILE ‘C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/actor.txt’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’ LINES TERMINATED BY ‘rn’

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search