Home
Random
Log in
Settings
About LemonWiki共筆
Disclaimers
LemonWiki共筆
Search
Troubleshooting of common Excel errors in Mandarin: Difference between revisions
Language
Watch
View history
Edit
← Older edit
Revision as of 15:11, 14 July 2025
edit
Planetoid
(
talk
|
contribs
)
Bureaucrats
,
Administrators
15,160
edits
m
→
解決 Excel 檔案另存成 CSV 檔案時,內容都變成亂碼
Tag
:
wikieditor
← Older edit
Latest revision as of 07:46, 24 April 2026
edit
undo
Planetoid
(
talk
|
contribs
)
Bureaucrats
,
Administrators
15,160
edits
→
Excel 匯入 CSV 檔案後,遇到欄位錯置
Tags
:
Mobile edit
Mobile web edit
Line 20:
Line 20:
原因:
原因:
* 如果 CSV 檔案內的欄位值包含換行符號 (Return symbol),Excel
開啟時會出現錯誤:原本應該同一欄位,卻換行變成第二筆資料。
* 如果 CSV 檔案內的欄位值包含換行符號 (Return symbol),Excel
開啟時會出現錯誤:原本應該同一欄位,卻變成下一筆資料。
解決方法:
解決方法: