Export MySQL query to Excel file: Difference between revisions

Jump to navigation Jump to search
m
Line 56: Line 56:
Condition 2: If the rows count of MySQL query is less than 65,535 rows. You can use [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] & MS Excel.
Condition 2: If the rows count of MySQL query is less than 65,535 rows. You can use [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] & MS Excel.


==== Step 2: Import CSV to XLSX/XLS file format. ====
==== Step 2: Convert CSV to XLSX/XLS file format. ====


* MS Excel
* MS Excel
Line 63: Line 63:
** [http://errerrors.blogspot.com/2014/05/mac-office-excel-csv-microsoft-excel.html Err: Mac Office Excel 匯入中文 CSV 檔案 (Microsoft Excel for Mac 2011)] {{Mac}}
** [http://errerrors.blogspot.com/2014/05/mac-office-excel-csv-microsoft-excel.html Err: Mac Office Excel 匯入中文 CSV 檔案 (Microsoft Excel for Mac 2011)] {{Mac}}
* [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc]
* [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc]


==== Step 3: Data verification ====
==== Step 3: Data verification ====

Navigation menu