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

概述我正在使用OPEN-OFFICE来工作和保存CSV.我使用逗号分隔符和”’,但是,保存CSV时,所有的数字都没有被封装,如何强制Open-Office将数字视为文本,并将其封装起来. "store","website","attribute_set","type","sku","name","price","categories","description","qty","sizet","is_i 我正在使用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不需要引用每个字段.

总结

以上是内存溢出为你收集整理的导出CSV正确打开Office(保存编号为TEXT)全部内容，希望文章能够帮你解决导出CSV正确打开Office(保存编号为TEXT)所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。