CSV导出:保存前导零 [英] CSV Exporting: Preserving leading zeros
问题描述
我正在使用一个.NET应用程序,该应用程序导出CSV文件以在Excel中打开,并且在Excel中打开该文件时保留前导零点有问题。我使用了 http://creativyst.com/Doc/Articles中提及的方法/CSV/CSV01.htm#CSVAndExcel
I'm working on a .NET application which exports CSV files to open in Excel and I'm having a problem with preserving leading zeros when the file is opened in Excel. I've used the method mentioned at http://creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVAndExcel
直到用户决定将CSV文件保存在Excel中,这才能很好用。如果文件在Excel中再次打开,则前导零将丢失。
This works great until the user decides to save the CSV file within Excel. If the file is opened again in Excel then the leading zeros are lost.
生成CSV文件时可以做什么,以防止发生这种情况。 >
Is there anything I can do when generating the CSV file to prevent this from happening.
推荐答案
这不是CSV问题。
将扩展名更改为其他内容。
Change the extension to something else.
这篇关于CSV导出:保存前导零的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!