MySQL database to Excel (1 table to 1 worksheet)

How to export MySQL database to excel document that 1 table in database is saved to 1 worksheet in xls document.

I am using Navicat, MySQL Maestro and SQLyog and all o开发者_开发知识库f them export one table per document.

Thank You

---

I know that in Navicat you can use export all tables from database to excel if you select "Excel file (.xls)" instead of "Excel spreadsheet (.xls)" and then for every table in your database add path to the same excel file :)