blocks|key|5305625|text|您可以简单地将范围格式化为文本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5305626|此外，here是一篇关于数字格式以及如何对其进行编程的很好的文章。|offset|length|5305627|entityMap|0|LINK|mutability|MUTABLE|url|http://peltiertech.com/Excel/NumberFormats.html^0|0|3|4|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

You can simply format your range as Text.

Also <a href="http://peltiertech.com/Excel/NumberFormats.html" rel="nofollow noreferrer">here</a> is a nice article on the number formats and how you can program them.

blocks|key|3894912|text|我相信当您导入文件时，您可以选择列类型。将其设置为文本而不是数字。不过，目前我面前没有一份可以检查的副本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3894913|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I believe when you import the file you can select the Column Type. Make it Text instead of Number. I don't have a copy in front of me at the moment to check though.

blocks|key|3894935|text|打开CSV时，您会看到文本导入向导。在向导的最后一步，您应该能够将特定列作为文本导入，从而保留'00‘前缀。之后，您可以以任何您想要的方式设置单元格的格式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3894936|我尝试使用Excel2007，它似乎可以工作。|3894937|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

When opening a CSV, you get the text import wizard. At the last step of the wizard, you should be able to import the specific column as text, thereby retaining the '00' prefix. After that you can then format the cell any way that you want.

I tried with with Excel 2007 and it appeared to work.

blocks|key|3894965|text|不要使用CSV，使用SYLK。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3894966|http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)|offset|length|3894967|它为格式化提供了更多的控制，Excel不会试图通过检查内容来猜测字段的类型。它看起来有点复杂，但您可以使用一个非常小的子集。|3894968|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1D|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Don't use CSV, use SYLK. 
<a href="http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)" rel="noreferrer">http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)</a>

It gives much more control over formatting, and Excel won't try to guess the type of a field by examining the contents. It looks a bit complicated, but you can get away with using a very small subset.

blocks|key|780904|text|实际上，我发现，至少从Office2003开始，您可以将Excel电子表格另存为XML文件。因此，我可以生成一个XML文件，当我双击它时，它将在Excel中打开。它提供与SYLK相同级别的控制，但XML语法更直观。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|780905|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Actually I discovered that, at least starting with Office 2003, you can save an Excel spreadsheet as an XML file.
Thus, I can produce an XML file and when I double-click on it, it'll be opened in Excel.
It provides the same level of control as SYLK, but XML syntax is more intuitive.

blocks|key|780949|text|在打开.csv文件时，没有一种简单的方法来控制Excel应用的格式。然而，下面列出了三种可能有帮助的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|780950|我的偏好是第一个选项。|780951|选项1-更改文件中的数据|offset|length|style|BOLD|780952|您可以按如下方式更改.csv文件中的数据...，=“005”，...这将在Excel中显示为...、005、...|780953|Excel将数据保留为公式，但复制列并使用粘贴特殊值将删除公式，但保留格式|780954|选项2+-格式化数据|780955|如果这仅仅是一个格式问题，并且该列中的所有数据都有三位数长度。然后在Excel中打开数据，然后使用此自定义格式000设置包含数据的列的格式|780956|选项3+-将文件扩展名更改为.dif+(数据交换格式)|780957|更改文件扩展名并使用文件导入向导控制格式。当双击时，扩展名为.dif的文件会自动打开。|780958|一步一步：|780959|将文件扩展名从文件类型更改为.dif|780960|Double单击该文件以在中打开它。|unordered-list-item|780961|
|780962|‘文件导入向导’将‘文件类型’更改为‘.csv’，然后单击'Next‘button.|780963|780964|Under分隔符，勾选'Comma’，然后在显示的每列数据上单击'Next‘button.|780965|780966|Click并选择一个’|780967|780968|‘。值为“005”的列应在“完成”按钮上设置为'Text'.|780969|Click格式，该文件将以您指定的格式打开。|780970|780971|780972|entityMap^0|0|0|0|8|0|O|6|1E|3|0|0|0|3|0|1J|3|0|0|3|0|0|0|E|4|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1N|8|@$F|1O|G|1P|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1Q|8|@$F|1R|G|1S|H|I]|$F|1T|G|1U|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1V|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1W|8|@$F|1X|G|1Y|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Z|8|@$F|20|G|21|H|I]]|9|@]|A|$]]|$1|R|3|S|5|6|7|22|8|@$F|23|G|24|H|I]]|9|@]|A|$]]|$1|T|3|U|5|6|7|25|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|26|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|27|8|@$F|28|G|29|H|I]]|9|@]|A|$]]|$1|Z|3|10|5|11|7|2A|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|2B|8|@]|9|@]|A|$]]|$1|14|3|15|5|11|7|2C|8|@]|9|@]|A|$]]|$1|16|3|13|5|6|7|2D|8|@]|9|@]|A|$]]|$1|17|3|18|5|11|7|2E|8|@]|9|@]|A|$]]|$1|19|3|13|5|6|7|2F|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|11|7|2G|8|@]|9|@]|A|$]]|$1|1C|3|-4|5|11|7|2H|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|11|7|2I|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|11|7|2J|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]]|1K|$]]

There isn’t an easy way to control the formatting Excel applies when opening a .csv file. However listed below are three approaches that might help.

My preference is the first option.

Option 1 – Change the data in the file

You could change the data in the .csv file as follows ...,=”005”,...
This will be displayed in Excel as ...,005,...

Excel will have kept the data as a formula, but copying the column and using paste special values will get rid of the formula but retain the formatting

Option 2 – Format the data

If it is simply a format issue and all your data in that column has a three digits length. Then open the data in Excel and then format the column containing the data with this custom format 000

Option 3 – Change the file extension to .dif (Data interchange format)

Change the file extension and use the file import wizard to control the formats.
Files with a .dif extension are automatically opened by Excel when double clicked on.

Step by step:

<ul>
<li>Change the file extension from .csv to .dif</li>
<li>Double click on the file to open it in Excel.</li>
<li>The 'File Import Wizard' will be launched.</li>
<li>Set the 'File type' to 'Delimited' and click on the 'Next' button.</li>
<li>Under Delimiters, tick 'Comma' and click on the 'Next' button.</li>
<li>Click on each column of your data that is displayed and select a 'Column data format'. The column with the value '005' should be formatted as 'Text'.</li>
<li>Click on the finish button, the file will be opened by Excel with the formats that you have specified.</li>
</ul>

blocks|key|780978|text|嗯，excel从来没有弹出CSV文件的向导。如果将其重命名为.txt，则下次在Excel中执行File>Open时将看到该向导。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|780979|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Well, excel never pops up the wizard for CSV files. If you rename it to .txt, you'll see the wizard when you do a File>Open in Excel the next time.

blocks|key|781005|text|Load+csv+into+oleDB+and+force+all+inferred+datatypes+to+string|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|781006|我问了同样的问题，然后用代码回答了它。|781007|基本上，当csv文件加载时，oledb驱动程序进行假设，您可以告诉它要做什么假设。|781008|我的代码强制所有数据类型为字符串...更改模式非常容易。出于我的目的，我使用xslt以我想要的方式获取ti+-但是我正在解析各种各样的文件。|781009|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/1688497/load-csv-into-oledb-and-force-all-inferred-datatypes-to-string^0|0|1Q|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

<a href="https://stackoverflow.com/questions/1688497/load-csv-into-oledb-and-force-all-inferred-datatypes-to-string">Load csv into oleDB and force all inferred datatypes to string</a>

i asked the same question and then answerd it with code.

basically when the csv file is loaded the oledb driver makes assumptions, you can tell it what assumptions to make.

My code forces all datatypes to string though ... its very easy to change the schema.
for my purposes i used an xslt to get ti the way i wanted - but i am parsing a wide variety of files.

blocks|key|3050396|text|在字段前加一个单引号。Excel会将其视为文本，即使它看起来像一个数字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3050397|...,`005,...|code-block|syntax|javascript|3050398|编辑：这是错误的。撇号技巧仅在将数据直接输入Excel时有效。当您在CSV文件中使用它时，撇号会出现在字段中，这是您不想要的。|offset|length|style|BOLD|3050399|http://support.microsoft.com/kb/214233|3050400|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|3|0|0|12|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@$I|Y|J|Z|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|N]]]]

Put a single quote before the field. Excel will treat it as text, even if it looks like a number.

<pre><code>...,`005,...
</code></pre>

EDIT: This is wrong. The apostrophe trick only works when entering data directly into Excel. When you use it in a CSV file, the apostrophe appears in the field, which you don't want.

<a href="http://support.microsoft.com/kb/214233" rel="nofollow noreferrer">http://support.microsoft.com/kb/214233</a>

blocks|key|3050445|text|我知道这是一个老问题，但我有一个解决方案没有在这里列出。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3050446|生成csv时，在逗号之后、值之前添加一个空格，例如,+005,。|offset|length|style|CODE|3050447|这就阻止了在excel2007中自动设置日期格式。|3050448|entityMap^0|0|P|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I know this is an old question, but I have a solution that isn't listed here.

When you produce the csv add a space after the comma but before your value e.g. <code>, 005,</code>. 

This worked to prevent auto date formatting in excel 2007 anyway .

blocks|key|5306133|text|当要导入的CSV文件在单元格中有换行符时，文本导入向导方法不起作用。此方法处理此场景(至少使用制表符分隔的数据)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5306134|5306135|Create+new+Excel+file|ordered-list-item|5306136|Ctrl%2BA要以数字格式组合框选择所有单元格|5306137|，请选择text+|5306138|在文本编辑器中打开选项卡分隔文件|5306139|全选，复制并粘贴到Excel|5306140|5306141|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|V|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|W|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

The Text Import Wizard method does NOT work when the CSV file being imported has line breaks within a cell. This method handles this scenario(at least with tab delimited data):

<ol>
<li>Create new Excel file</li>
<li>Ctrl+A to select all cells</li>
<li>In Number Format combobox, select Text</li>
<li>Open tab delimited file in text editor</li>
<li>Select all, copy and paste into Excel</li>
</ol>

blocks|key|5306193|text|这适用于Microsoft+Office+2010+Excel版本14|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5306194|我错误地理解了OP的首选项“对文件本身做一些操作”。我仍然为那些想要直接格式化导入的解决方案的人保留这篇文章|5306195|5306196|打开空白(新建)文件(文件->从工作簿新建)|ordered-list-item|5306197|5306198|5306199|打开导入向导(文本中的数据->+)|5306200|5306201|5306202|选择您的.csv文件并导入|5306203|5306204|5306205|在对话框中，选择'Delimited'，然后单击Next。|5306206|5306207|5306208|选择您的分隔符(取消选中除‘逗号’之外的所有分隔符)，选择您的文本限定符(可能为{None})，然后单击Next|5306209|5306210|5306211|在数据预览字段中，选择要作为文本的列。它应该突出显示。|offset|length|style|BOLD|5306212|5306213|5306214|在Column+data+format字段中，选择‘Text’。|5306215|5306216|5306217|单击完成。|5306218|5306219|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|4|0|0|0|1|I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1J|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|1M|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|N|3|O|5|G|7|1P|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|R|3|S|5|G|7|1S|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|V|3|W|5|G|7|1V|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|Z|3|10|5|G|7|1Y|8|@$11|1Z|12|20|13|14]]|9|@]|A|$]]|$1|15|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|17|3|18|5|G|7|23|8|@$11|24|12|25|13|14]]|9|@]|A|$]]|$1|19|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|G|7|28|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]]|1F|$]]

This works for Microsoft Office 2010, Excel Version 14 

I misread the OP's preference "to do something to the file itself." I'm still keeping this for those who want a solution to format the import directly

<ol>
<li>Open a blank (new) file (File -> New from workbook) </li>
<li>Open the Import Wizard (Data -> From Text) </li>
<li>Select your .csv file and Import </li>
<li>In the dialogue box, choose 'Delimited', and click Next. </li>
<li>Choose your delimiters (uncheck everything but 'comma'), choose your Text qualifiers (likely {None}), click Next </li>
<li>In the Data preview field select the column you want to be text. It should highlight. </li>
<li>In the Column data format field, select 'Text'. </li>
<li>Click finished. </li>
</ol>

blocks|key|3895414|text|在单元格中添加不间断的空格可能会有所帮助。例如："firstvalue";"secondvalue";"005 ";"othervalue"|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3895415|它强制Excel将其视为文本，并且空格不可见。在Windows上，你可以通过tiping+alt%2B0160来添加一个不间断的空格。有关更多信息，请查看此处：http://en.wikipedia.org/wiki/Non-breaking_space|3895416|已在Excel+2010上试用。希望这能帮助那些仍然在寻找这个问题的合适解决方案的人。|3895417|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Non-breaking_space^0|O|1A|0|26|1B|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|I|5|6|7|Y|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

Adding a non-breaking space in the cell could help.
For instance: 
<code>"firstvalue";"secondvalue";"005 ";"othervalue"</code>

It forces Excel to treat it as a text and the space is not visible.
On Windows you can add a non-breaking space by tiping alt+0160.
See here for more info: <a href="http://en.wikipedia.org/wiki/Non-breaking_space" rel="nofollow">http://en.wikipedia.org/wiki/Non-breaking_space</a>

Tried on Excel 2010.
Hope this can help people who still search a quite proper solution for this problem.

blocks|key|5306278|text|只需在CSV文档中的数字前添加‘。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5306279|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Just add ' before the number in the CSV doc.

blocks|key|3050697|text|我在从C#代码导出CSV数据时遇到了这个问题，并通过在前导零数据前加上制表符\t来解决这个问题，这样数据在Excel中就会被解释为文本而不是数字(但与前缀其他字符不同的是，它不会被看到)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3050698|我确实喜欢="001“方法，但这不允许将导出的CSV数据重新导入到我的C#应用程序中，而不是删除导入CSV文件中的所有格式(相反，我将只修剪导入数据)。|3050699|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had this issue when exporting CSV data from C# code, and resolved this by prepending the leading zero data with the tab character \t, so the data was interpreted as text rather than numeric in Excel (yet unlike prepending other characters, it wouldn't be seen). 

I did like the ="001" approach, but this wouldn't allow exported CSV data to be re-imported again to my C# application without removing all this formatting from the import CSV file (instead I'll just trim the import data).

blocks|key|781198|text|这一整天都让我抓狂(因为在打开CSV文件之前，你确实不能控制Excel的列类型)，这对我很有效，使用VB.NET和Excel+Interop：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|781199|++++++++'Convert+.csv+file+to+.txt+file.
++++++++FileName+=+ConvertToText(FileName)

++++++++Dim+ColumnTypes(,)+As+Integer+=+New+Integer(,)+{{1,+xlTextFormat},+_
++++++++++++++++++++++++++++++++++++++++++++++++++++++++{2,+xlTextFormat},+_
++++++++++++++++++++++++++++++++++++++++++++++++++++++++{3,+xlGeneralFormat},+_
++++++++++++++++++++++++++++++++++++++++++++++++++++++++{4,+xlGeneralFormat},+_
++++++++++++++++++++++++++++++++++++++++++++++++++++++++{5,+xlGeneralFormat},+_
++++++++++++++++++++++++++++++++++++++++++++++++++++++++{6,+xlGeneralFormat}}

++++++++'We+are+using+OpenText()+in+order+to+specify+the+column+types.
++++++++mxlApp.Workbooks.OpenText(FileName,+,+,+Excel.XlTextParsingType.xlDelimited,+,+,+True,+,+True,+,+,+,+ColumnTypes)
++++++++mxlWorkBook+=+mxlApp.ActiveWorkbook
++++++++mxlWorkSheet+=+CType(mxlApp.ActiveSheet,+Excel.Worksheet)


Private+Function+ConvertToText(ByVal+FileName+As+String)+As+String
++++'Convert+the+.csv+file+to+a+.txt+file.
++++'If+the+file+is+a+text+file,+we+can+specify+the+column+types.
++++'Otherwise,+the+Codes+are+first+converted+to+numbers,+which+loses+trailing+zeros.

++++Try
++++++++Dim+MyReader+As+New+StreamReader(FileName)
++++++++Dim+NewFileName+As+String+=+FileName.Replace(".CSV",+".TXT")
++++++++Dim+MyWriter+As+New+StreamWriter(NewFileName,+False)
++++++++Dim+strLine+As+String

++++++++Do+While+Not+MyReader.EndOfStream
++++++++++++strLine+=+MyReader.ReadLine
++++++++++++MyWriter.WriteLine(strLine)
++++++++Loop

++++++++MyReader.Close()
++++++++MyReader.Dispose()
++++++++MyWriter.Close()
++++++++MyWriter.Dispose()

++++++++Return+NewFileName
++++Catch+ex+As+Exception
++++++++MsgBox(ex.Message)
++++++++Return+""
++++End+Try

End+Function|code-block|syntax|javascript|781200|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This has been driving me crazy all day (since indeed you can't control the Excel column types before opening the CSV file), and this worked for me, using VB.NET and Excel Interop:

<pre class="lang-vb prettyprint-override"><code> 'Convert .csv file to .txt file.
 FileName = ConvertToText(FileName)

 Dim ColumnTypes(,) As Integer = New Integer(,) {{1, xlTextFormat}, _
 {2, xlTextFormat}, _
 {3, xlGeneralFormat}, _
 {4, xlGeneralFormat}, _
 {5, xlGeneralFormat}, _
 {6, xlGeneralFormat}}

 'We are using OpenText() in order to specify the column types.
 mxlApp.Workbooks.OpenText(FileName, , , Excel.XlTextParsingType.xlDelimited, , , True, , True, , , , ColumnTypes)
 mxlWorkBook = mxlApp.ActiveWorkbook
 mxlWorkSheet = CType(mxlApp.ActiveSheet, Excel.Worksheet)


Private Function ConvertToText(ByVal FileName As String) As String
 'Convert the .csv file to a .txt file.
 'If the file is a text file, we can specify the column types.
 'Otherwise, the Codes are first converted to numbers, which loses trailing zeros.

 Try
 Dim MyReader As New StreamReader(FileName)
 Dim NewFileName As String = FileName.Replace(".CSV", ".TXT")
 Dim MyWriter As New StreamWriter(NewFileName, False)
 Dim strLine As String

 Do While Not MyReader.EndOfStream
 strLine = MyReader.ReadLine
 MyWriter.WriteLine(strLine)
 Loop

 MyReader.Close()
 MyReader.Dispose()
 MyWriter.Close()
 MyWriter.Dispose()

 Return NewFileName
 Catch ex As Exception
 MsgBox(ex.Message)
 Return ""
 End Try

End Function
</code></pre>

I produce a report as an CSV file.
When I try to open the file in Excel, it makes an assumption about the data type based on the contents of the cell, and reformats it accordingly.

For example, if the CSV file contains

<pre><code>...,005,...
</code></pre>

Then Excel shows it as 5.
Is there a way to override this and display 005?

I would prefer to do something to the file itself, so that the user could just double-click on the CSV file to open it.

I use Excel 2003.

Excel CSV - Number cell format

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我以CSV文件的形式生成报告。当我尝试在Excel中打开文件时，它会根据单元格的内容对数据类型进行假设，并相应地重新格式化。例如，如果CSV文件包含...,005,...那么Excel会将其显示为5。有没有办法覆盖它并显示005？我更喜欢对文件本身做一些操作，这样用户只需双击CSV文件就可以打开它。我使用Excel20...

问Excel CSV -数字单元格格式
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel CSV -数字单元格格式EN