导出CSV正确打开Office(保存编号为TEXT)

发布时间：2020-12-14 19:37:58 所属栏目：资源来源：网络整理

导读：我正在使用OPEN-OFFICE来工作和保存CSV.我使用逗号分隔符和”’,但是,保存CSV时,所有的数字都没有被封装,如何强制Open-Office将数字视为文本,并将其封装起来. "store","website","attribute_set","type","sku","name","price","categories","description","q

我正在使用OPEN-OFFICE来工作和保存CSV.我使用逗号分隔符和”’,但是,保存CSV时,所有的数字都没有被封装,如何强制Open-Office将数字视为文本,并将其封装起来.

"store","website","attribute_set","type","sku","name","price","categories","description","qty","sizet","is_in_stock","status","visibility","tax_class_id"
"admin","base","test","simple","T010013-012","Test12","12","test/test","Desc12",12,"S","1","Enabled","Catalog,Search","Taxable Goods"
"admin","T010013-013","Test13","13","Desc13",13,"M","T010013-014","Test14","14","Desc14",14,"L","T010013-015","Test15","15","Desc15",15,"XL","T010013-016","Test16","16","Desc16",16,"XXL","configurable","T010013","TestParent","5","DescParent","30","","Taxable Goods"

感谢您的帮助.
PS：我正在为Magento使用MAGMI脚本.上传产品

解决方法

这需要两个步骤：

>格式化保存数字的单元格作为文本(因为整个列将需要该格式,只需将该格式应用于完整的列,因此如果添加行,则不需要格式化每个新单元格);
>修改导出过滤器设置以引用所有文本单元格：

使用此设置,Calc应保存此工作表：

如下：

"bar","42"
"foo","57"

BTW,Calc完全符合标准,默认情况下不引用每个数字.至少RFC 4180不需要引用每个字段.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!