Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Export MySQL query to Excel file (XLS or XLSX file) == Tools == * [https://phpexcel.codeplex.com/ PHPExcel] * other MySQL client softwares == Technical issues: If it costs t...") |
No edit summary |
||
| Line 4: | Line 4: | ||
* [https://phpexcel.codeplex.com/ PHPExcel] | * [https://phpexcel.codeplex.com/ PHPExcel] | ||
* other MySQL client softwares | * other MySQL client softwares | ||
two steps conversion: ex | |||
* CSV --> XLSX or | |||
* XLS --> XLSX | |||
== Technical issues: If it costs too much time to convert to Excel file == | == Technical issues: If it costs too much time to convert to Excel file == | ||
Revision as of 14:04, 9 November 2015
Export MySQL query to Excel file (XLS or XLSX file)
Tools
- PHPExcel
- other MySQL client softwares
two steps conversion: ex
- CSV --> XLSX or
- XLS --> XLSX
Technical issues: If it costs too much time to convert to Excel file
First steps for CSV file. The CSV file will be converted to Excel file more convenient.
- Add delimiter character between different column ex: comma symbol (,) or tab symbol
- Add enclosure character ex: double quote symbol (") or single quote symbol (')
- Add escape character escape the column value if contains the enclosure character
- Remove return symbol:
SELECT REPLACE(REPLACE(REPLACE(`my_column`, '\r\n', ' '), '\n', ' '), '\r', ' ')