Export MySQL query to Excel file: Difference between revisions

Export MySQL query to Excel file (edit)

84 bytes added , 9 August 2017

m

14,970

edits

@@ Line 31: / Line 31: @@
 == Methods ==
 === One step conversion: ex MySQL query -> Excel file ===
-Methods of exporting MySQL query -> XLS/XLSX file
+Methods of exporting MySQL query -> XLS/XLSX file: PHP scripts or other MySQL client softwares
-* [https://phpexcel.codeplex.com/ PHPExcel]
+* {{Gd}} Quick to export: Free [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL] for {{Win}}
-* other MySQL client softwares e.g. free [https://www.quest.com/products/toad-for-mysql/ Toad for MySQL], ''$'' [https://www.navicat.com/cht Navicat GUI]
+* [https://phpexcel.codeplex.com/ PHPExcel]: PHP scripts
+* ''$'' [https://www.navicat.com/cht Navicat GUI] for {{Win}} & {{Mac}}
 Notice the limit of Excel XLS file format: