导入MySQL数据库以使用单独工作表中的所有表格进行Excel

Question

Do you know how can I export whole MySQL database to Excel with maintaining table structure? I can use phpMyAdmin or Linux command line. If I use CSV I get table below table, so it's rather inefficient. I tried XML, but Excel can't read it.

Answer 1

Try this extension phpExcel .

which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.

Update If you asking a tool My suggestion is NaviCat