MySQLdb to Excel

Question

I have a Django project which has a mysql database backend. How can I export contents from my db to an Excel (xls, xlsx) format?

export to csv - see http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format — JamesO, Jul 11 '11 at 12:22

score 0 · Answer 1 · answered Jul 11 '11 at 12:22

0

phpMyAdmin has an Export tab, and you can export in CSV. This can be imported into Excel.

answered Jul 11 '11 at 12:22

Scott C Wilson

16,711
9
54
76

Yes, I know that, but how can I directly export xls or xlsx without phpMyAdmin? – user823148 Jul 11 '11 at 12:23

score 0 · Answer 2 · answered Jul 11 '11 at 12:23

0

http://pypi.python.org/pypi/xlwt

answered Jul 11 '11 at 12:23

Denis

6,117
6
35
56

score 0 · Answer 3 · answered Jul 11 '11 at 12:46

0

If you need a xlsx (excel 2007) exporter, you can use openpyxl. Otherwise xlwt is an option.

answered Jul 11 '11 at 12:46

shanyu

8,990
5
55
68

score 0 · Answer 4 · answered Jul 11 '11 at 15:10

Openpyxl is a great choice, but if you don't wanna go through a new thing you can simply write you own exporting function:

for example you can export things in CSV format like this:

def CVSExport(database_array):
  f_csv = open('mydatabase.csv', 'w')
  for row in database_array:
    f_csv.write('"%s";;;;;"%s"\n'%(row[0], row[1]))
  f_csv.close()

when you open exported file by excel you should set ";;;;;" as separator.

MySQLdb to Excel

4 Answers4