Editing
Microsoft Excel
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== Batch convert TXT/CSV to EXCEL == 原始檔案: 欄位值用雙引號框起來(enclosure)、不同欄位資料用定位鍵 {{kbd | key = Tab}} 間隔、檔案編碼 UTF8 沒有 BOM <pre> "column_1" \t "column_2" \t "column_3" </pre> 批次轉檔的方案比較 # {{Gd}} ''$'' [http://www.dbf2002.com/csv-converter/ Advanced CSV Converter] v 5.55 ok #* 轉檔時可以選擇 UTF-8 編碼,輸出的中文 Excel 不會亂碼。 #* 但是不能辨識欄位值前後的雙引號 符號,所以原始檔案需要先去除欄位值前後的雙引號 符號。 #* 試用版只能匯出 50 筆資料。 # [http://www.softinterface.com/Convert-XLS/Convert-XLS.htm ConvertXLS] v. 8.54 中文亂碼 {{exclaim}} # [https://bytescout.com/products/enduser/spreadsheettools/spreadsheettools.html Bytescout Spreadsheet Tools ] v. 1.10.0.21 中文亂碼 {{exclaim}} # [https://drive.google.com/ Google 雲端硬碟] 上傳 CSV 檔前,要勾選「轉換上傳檔案 -- 將已上傳的檔案轉換成 Google 文件編輯器格式」。上傳後,再下載會變成 Excel 格式。 {{access | date = 2016-12-30}}
Summary:
Please note that all contributions to LemonWiki共筆 are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see
LemonWiki:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
Tools
What links here
Related changes
Special pages
Page information