<div>
&gt;&gt;in notepad it is there<br />
Then it is there...<br />
<br />
How are you reading it with C#? When I read files using VB it reads them with the leading 0. Or are you using an Excel object to open the file?<br />
<br />
Look at the solution in the following link. It used the FSO to read thru a file a line at a time.<br />
<br />
&nbsp; <a href="https://www.experts-exchange.com/questions/22455373/VB6-Remove-lines-with-comma-Text-manipulation.html" rel="ugc">https://www.experts-exchange.com/questions/22455373/VB6-Remove-lines-with-comma-Text-manipulation.html</a><br />
<br />

</div>


>>in notepad it is there
Then it is there...

How are you reading it with C#? When I read files using VB it reads them with the leading 0. Or are you using an Excel object to open the file?

Look at the solution in the following link. It used the FSO to read thru a file a line at a time.

  https://www.experts-exchange.com/questions/22455373/VB6-Remove-lines-with-comma-Text-manipulation.html [https://www.experts-exchange.com/questions/22455373/VB6-Remove-lines-with-comma-Text-manipulation.html]



<div>
I am using Excel to read the file.
</div>


<div>
&gt;&gt;I am using Excel to read the file.<br />
Is the data generate4d in Excel? You can change the data to be '0001 in Excel to retain leading 0's.<br />

</div>


>>I am using Excel to read the file.
Is the data generate4d in Excel? You can change the data to be '0001 in Excel to retain leading 0's.


<div>
<div class="content wysiwyg-content">
I have an Excel spreadsheet that I save as a CSV file. &nbsp;There is one value that I save with a zero padding in the beginning of the field. &nbsp;When I load up the CSV file in Excel it strips off the leading 0. &nbsp;But if I look at it in notepad it is there. &nbsp;The problem I have is that when I try to read it in Excel Automation (using c#) it very much acts as it does when opening the file in Excel, i.e., stripping off the leading 0. &nbsp;The field is a key to a database table and will not work without the leading 0. &nbsp;Is there a way in Excel or preferrably C# to read the true value?<br />
<br />
Thanks
</div>
</div>


I have an Excel spreadsheet that I save as a CSV file.  There is one value that I save with a zero padding in the beginning of the field.  When I load up the CSV file in Excel it strips off the leading 0.  But if I look at it in notepad it is there.  The problem I have is that when I try to read it in Excel Automation (using c#) it very much acts as it does when opening the file in Excel, i.e., stripping off the leading 0.  The field is a key to a database table and will not work without the leading 0.  Is there a way in Excel or preferrably C# to read the true value?

Thanks

CSV file strips off leading 0 when reading in Excel.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.