14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
m
→Microsoft Excel (XLS or XLSX) & OpenDocument Spreadsheet (ODS) file limits
| Line 21: | Line 21: | ||
<td>Microsoft Excel Spreadsheet</td> | <td>Microsoft Excel Spreadsheet</td> | ||
<td>XLS</td> | <td>XLS</td> | ||
<td>Maximum of worksheet size is 65,536 rows by 256 columns. <br />{{exclaim}} Because first row is column name, actual data size is 65,535 rows. <ref>[http://superuser.com/questions/366468/what-is-the-maximum-allowed-rows-in-a-microsoft-excel-xls-or-xlsx What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx - Super User]</ref><ref>[https://support.office.com/en-us/article/Worksheet-compatibility-issues-f9c80c5b-5afc-40da-a841-b888746abd40 Worksheet compatibility issues - Excel].</ref></td> | <td>Maximum of worksheet size is 65,536 rows by 256 columns. <br />{{exclaim}} Because first row is occupied by column name, actual data size is 65,535 rows. <ref>[http://superuser.com/questions/366468/what-is-the-maximum-allowed-rows-in-a-microsoft-excel-xls-or-xlsx What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx - Super User]</ref><ref>[https://support.office.com/en-us/article/Worksheet-compatibility-issues-f9c80c5b-5afc-40da-a841-b888746abd40 Worksheet compatibility issues - Excel].</ref></td> | ||
<td></td> | <td></td> | ||
<td>Microsoft Excel 2003 and [https://fileinfo.com/extension/xls more]</td> | <td>Microsoft Excel 2003 and [https://fileinfo.com/extension/xls more]</td> | ||