Editing Export MySQL query to Excel file (section)

== Troubleshooting of technical issues ==
=== If it costs too much time to convert to Excel file ===
The important steps before generating CSV file. These steps reduce the problems when the CSV file was converted to Excel file.
* 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<ref>[http://stackoverflow.com/questions/1504962/how-to-remove-new-line-characters-from-data-rows-in-mysql trim - How to remove new line characters from data rows in mysql? - Stack Overflow]</ref>: <pre>SELECT REPLACE(REPLACE(REPLACE(`my_column`, '\r\n', '   '), '\n', '   '), '\r', '   ') </pre>

=== Data format in result set became string after exported as Excel file===
* '''Number''' data types in result set became '''string''' after exported as XLSX file <ref>[https://exceljet.net/formula/convert-text-to-numbers Excel formula: Convert text to numbers | Exceljet]</ref>
* '''Date time''' data types in result set became '''string''' after exported as XLSX file<ref>[https://errerrors.blogspot.com/2016/12/excel-value-text.html Excel 如何轉換文字格式的日期時間格式 (使用 VALUE, TEXT 函數)]</ref>