14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→two steps conversion ex: MySQL query -> CSV file -> Excel file
(→Tools) |
|||
| Line 9: | Line 9: | ||
=== two steps conversion ex: MySQL query -> CSV file -> Excel file=== | === two steps conversion ex: MySQL query -> CSV file -> Excel file=== | ||
ex: (1) MySQL query -> CSV/XLS file (2) CSV --> XLSX or XLS --> XLSX. | ex: (1) MySQL query -> CSV/XLS file (2) CSV --> XLSX or XLS --> XLSX. | ||
step (1) MySQL query -> CSV/XLS file | |||
* PHPExcel or MySQL client softwares | * PHPExcel or MySQL client softwares | ||
* [http://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html MySQL :: MySQL 5.7 Reference Manual :: 8.4.3 Dumping Data in Delimited-Text Format with mysqldump] | * [http://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html MySQL :: MySQL 5.7 Reference Manual :: 8.4.3 Dumping Data in Delimited-Text Format with mysqldump] | ||
step (2) CSV --> XLSX or XLS --> XLSX. | |||
* MS Excel | * MS Excel | ||
* [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] | * [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] | ||