Excel中的CSV文件无法正确呈现 [英] CSV file in Excel is not rendering correctly

问题描述

这是excel文件的内容：

 Windows Excel，AndroMoney，20140227
Id，Valuta，Importo，Categoria，Sottocategoria，Data，Spese（Trasferimento Out），Entrate（Trasferimento In），Note，Periodicita ，Progetto，Pagatore / Beneficiario，uid
19，EUR， -  1079.63，SYSTEM，INIT_AMOUNT，10100101， ，，，，116EUR-1079.63_26_102，
20，EUR， -  2662.9，SYSTEM，INIT_AMOUNT，10100101 信用卡，，，，，117EUR-2662.9_26_102
960，EUR，0，SYSTEM，INIT_AMOUNT，10100101 ，奥地利银行，，，，，，265C6BD548CE41FEA0250BF4E19C392F
1，EUR，8，食物 ，现金，，，，，，1EUR8_1_1
  

这里是Excel如何显示其内容：

在另一个 post 他们说这是因为使用 而不是;

是否可以在不改变操作系统设置的情况下解决问题？

解决方案

/ p>

将扩展名从CSV更改为TXT，使用excel打开文件，定义，作为分隔符字符

This is the content of the excel file:

"Windows Excel","AndroMoney","20140227"
"Id","Valuta","Importo","Categoria","Sottocategoria","Data","Spese(Trasferimento Out)","Entrate(Trasferimento In)","Note","Periodicita'","Progetto","Pagatore/Beneficiario","uid"
"19","EUR","-1079.63","SYSTEM","INIT_AMOUNT","10100101","","Bank","","","","","116EUR-1079.63_26_102"
"20","EUR","-2662.9","SYSTEM","INIT_AMOUNT","10100101","","Credit Card","","","","","117EUR-2662.9_26_102"
"960","EUR","0","SYSTEM","INIT_AMOUNT","10100101","","Bank austria","","","","","265C6BD548CE41FEA0250BF4E19C392F"
"1","EUR","8","Food","Breakfast","20130326","Cash","","","","","","1EUR8_1_1"

And here is how Excel shows its content:

In another post they say it's due to the usage of the , instead of ;

Is it possible to solve the problem without changing Operating System settings?

解决方案

I use a trick.

Change the extencion from CSV to TXT, the open the file with excel, define , as the delimitator character

这篇关于Excel中的CSV文件无法正确呈现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！