14,962
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
→One step conversion: ex MySQL query -> Excel file
No edit summary |
|||
| Line 6: | Line 6: | ||
Methods of exporting MySQL query -> XLS/XLSX file: PHP scripts or other MySQL client softwares e.g. | Methods of exporting MySQL query -> XLS/XLSX file: PHP scripts or other MySQL client softwares e.g. | ||
* [https://phpexcel.codeplex.com/ PHPExcel]: PHP scripts | * [https://phpexcel.codeplex.com/ PHPExcel]: PHP scripts | ||
* [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL] for {{Win}} | * Using [[Database management tools]] e.g. [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL] for {{Win}}, ''$'' [https://www.navicat.com/cht Navicat GUI] for {{Win}} & {{Mac}} | ||
Notice the limit of Excel XLS file format: | {{exclaim}} Notice the limit of Excel XLS file format: | ||
# "Total number of characters that a cell can contain: 32,767 characters" | # "Total number of characters that a cell can contain: 32,767 characters" | ||
#* Using [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php MySQL SUBSTRING() function] ex: {{kbd | key = <nowiki>SUBSTRING(string_column, 1, 32767)</nowiki>}} for EXCEL 97<ref>[https://support.microsoft.com/en-us/kb/296053 Summary of capability limitations in Excel 97]</ref>-2007<ref>[https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa?CorrelationId=1de7e8d2-91e2-4eec-8868-4dc8cbd23463&ui=en-US&rs=en-US&ad=US Excel specifications and limits]</ref> (XLS 檔) | #* Using [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php MySQL SUBSTRING() function] ex: {{kbd | key = <nowiki>SUBSTRING(string_column, 1, 32767)</nowiki>}} for EXCEL 97<ref>[https://support.microsoft.com/en-us/kb/296053 Summary of capability limitations in Excel 97]</ref>-2007<ref>[https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa?CorrelationId=1de7e8d2-91e2-4eec-8868-4dc8cbd23463&ui=en-US&rs=en-US&ad=US Excel specifications and limits]</ref> (XLS 檔) | ||