15,013
edits
Microsoft Excel: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with " == 不同試算表方案的工作表或儲存格的大小限制 == * {{Gd}} EXCEL 2007, EXCEL 2013: ** (約100萬列) 1,048,576 列 * 16,384 欄 = 17,179,869,184 個儲存...") |
No edit summary |
||
| Line 17: | Line 17: | ||
* (1) "Total number of characters that a cell can contain: 32,767 characters" Using [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php MySQL SUBSTRING() function] ex: {{kbd | key = <nowiki>SUBSTRING(string_column, 1, 32767)</nowiki>}} for EXCEL 97<ref>[https://support.microsoft.com/en-us/kb/296053 Summary of capability limitations in Excel 97]</ref>-2007<ref>[https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa?CorrelationId=1de7e8d2-91e2-4eec-8868-4dc8cbd23463&ui=en-US&rs=en-US&ad=US Excel specifications and limits]</ref> ''unverified'' | * (1) "Total number of characters that a cell can contain: 32,767 characters" Using [http://www.w3resource.com/mysql/string-functions/mysql-substring-function.php MySQL SUBSTRING() function] ex: {{kbd | key = <nowiki>SUBSTRING(string_column, 1, 32767)</nowiki>}} for EXCEL 97<ref>[https://support.microsoft.com/en-us/kb/296053 Summary of capability limitations in Excel 97]</ref>-2007<ref>[https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa?CorrelationId=1de7e8d2-91e2-4eec-8868-4dc8cbd23463&ui=en-US&rs=en-US&ad=US Excel specifications and limits]</ref> ''unverified'' | ||
* (2) "Worksheet size: 1,048,576 rows": Using {{kbd | key =LIMIT}} for EXCEL 2007 | * (2) "Worksheet size: 1,048,576 rows": Using {{kbd | key =LIMIT}} for EXCEL 2007 | ||
相關文章 | |||
* [http://errerrors.blogspot.tw/2015/07/excel.html Err: 解決從資料庫輸出 Excel 檔案，遇到非常大數字的科學符號和有效位數的問題] | |||
== Import CSV to EXCEL == | == Import CSV to EXCEL == | ||
| Line 61: | Line 65: | ||
* {{kbd | key =<nowiki>IF</nowiki>}} 回傳的空值，也會被列入計算加 1 {{exclaim}} version: Excel 2013 | * {{kbd | key =<nowiki>IF</nowiki>}} 回傳的空值，也會被列入計算加 1 {{exclaim}} version: Excel 2013 | ||
== references == | |||
<references/> | |||
[[Category:spreadsheet]] [[Category:Excel]] | [[Category:spreadsheet]] [[Category:Excel]] | ||
[[Category:Data Science]] | [[Category:Data Science]] | ||