Export MySQL query to Excel file: Difference between revisions

Jump to navigation Jump to search

Export MySQL query to Excel file (edit)

Revision as of 14:51, 15 November 2021

3,855 bytes removed ,  15 November 2021
m
→‎Microsoft Excel (XLS or XLSX) & OpenDocument Spreadsheet (ODS) file limits
m (Text replacement - "http://errerrors.blogspot.com" to "https://errerrors.blogspot.com")
Tags: Mobile edit Mobile web edit
Line 2: Line 2:


== Microsoft Excel (XLS or XLSX) & OpenDocument Spreadsheet (ODS) file limits ==
== Microsoft Excel (XLS or XLSX) & OpenDocument Spreadsheet (ODS) file limits ==
不同試算表方案的工作表或儲存格的大小限制
[[Microsoft Excel#Microsoft Excel (XLS or XLSX) & OpenDocument Spreadsheet (ODS) file limits]]
<table border="1">
<tr>
  <th>Title</th>
  <th>File extension</th>
  <th>Data rows size</th>
  <th>Length of cell</th>
  <th>Available solutions</th>
</tr>
<tr>
  <td>Microsoft Excel Open XML Spreadsheet</td>
  <td>XLSX</td>
  <td>Maximum of worksheet size is 1,048,576 rows by 16,384 columns.<ref>[https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-US&rs=en-US&ad=US&fromAR=1 Excel specifications and limits]</ref><ref>[http://office.microsoft.com/zh-tw/excel-help/HP010073849.aspx Excel 的規格及限制] 工作表大小</ref><ref>[http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HA103980614.aspx Excel specifications and limits - Excel]</ref> </td>
  <td>(1) Length of formula contents: 8,192 characters <br />(2) Total number of characters that a cell can contain: 32,767 characters<ref>[https://errerrors.blogspot.com/2016/02/navicat.html Err: 解決 Navicat 「存放裝置空間不足，無法完成此操作」問題訊息]</ref></td>
  <td>Microsoft Excel 2007, EXCEL 2013 and [https://fileinfo.com/extension/xlsx more]</td>
</tr>
<tr>
  <td>Microsoft Excel Spreadsheet</td>
  <td>XLS</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>Microsoft Excel 2003 and [https://fileinfo.com/extension/xls more]</td>
</tr>
<tr>
  <td>OpenDocument Spreadsheet</td>
  <td>ODS</td>
  <td>Maximum of worksheet size is 1,048,576 (2^20) rows by 1024 columns for LibreOffice spreadsheet & OpenOffice.org Calc 3 <ref>[https://wiki.documentfoundation.org/Faq/Calc/022 Frequently asked questions - Calc - The Document Foundation Wiki]</ref><ref>[https://simple.wikipedia.org/wiki/OpenOffice_Calc OpenOffice Calc - Simple English Wikipedia, the free encyclopedia]</ref>. </td>
  <td>Total number of characters that a cell can contain: 32,767 characters for LibreOffice spreadsheet<ref>[https://wiki.documentfoundation.org/Faq/Calc/022 Frequently asked questions - Calc - The Document Foundation Wiki]</ref>.</td>
  <td>[http://www.libreoffice.org/ LibreOffice]([http://portableapps.com/apps/office/libreoffice_portable/ LibreOffice Portable])  spreadsheet 3.3.3+ & Apache [https://www.openoffice.org/ OpenOffice.org] Calc 3+ and [https://fileinfo.com/extension/ods more]</td>
</tr>
<tr>
  <td>[https://www.google.com/sheets/about/ Google spreadsheet]</td>
  <td></td>
  <td>"Up to 2 million cells for spreadsheets that are created in or converted to Google Sheets" <br />2,000,000 cells = 7,812 rows x 256 columns per sheet.<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant Google 文件、試算表和簡報的檔案大小限制 - 雲端硬碟說明] [https://support.google.com/drive/answer/37603?hl=en Files you can store in Google Drive - Google Drive Help]</ref></td>
  <td></td>
  <td></td>
</tr>
<tr>
  <td>[https://www.zoho.com/docs/sheet.html Zoho Sheet]
  <td></td>
  <td>"Up to 1 million cells for a single spreadsheet with a maximum number of 65536 rows and 256 columns per sheet."<ref>[https://www.zoho.com/docs/faq/online-spreadsheet.html Zoho Docs - FAQ on Online Spreadsheet]</ref></td>
  <td></td>
  <td></td>
</tr>
</table>
 
 
* Office 365: [http://office.microsoft.com/zh-tw/excel-help/HA102837464.aspx 資料模型的規格與限制 - Excel - Office.com] 適用: Excel 2013, Power BI for Office 365 Preview, Power Pivot in Excel 2013


== Methods ==
== Methods ==
Anonymous user
Retrieved from "https://wiki.planetoid.info/index.php/Special:MobileDiff/22444"

Navigation menu