<div>
in my view you have at least 2 options:<br />
<br />
- read the file line by line and then use String.Split(delim) to get all fields in an array<br />
<br />
- add a reference to Excel, create the app object etc and try to read the csv into the worksheet:<br />
<a href="http://www.vbdotnetheaven.com/UploadFile/ggaganesh/ExcelSpreadsheet04182005093012AM/ExcelSpreadsheet.aspx" rel="ugc">http://www.vbdotnetheaven.com/UploadFile/ggaganesh/ExcelSpreadsheet04182005093012AM/ExcelSpreadsheet.aspx</a><br />
<a href="http://www.thescarms.com/dotnet/ExcelObject.aspx" rel="ugc">http://www.thescarms.com/dotnet/ExcelObject.aspx</a><br />
<a href="http://www.gemboxsoftware.com/GBSpreadsheet.htm" rel="ugc">http://www.gemboxsoftware.com/GBSpreadsheet.htm</a>&nbsp;(commercial component)<br />
<br />

</div>


in my view you have at least 2 options:

- read the file line by line and then use String.Split(delim) to get all fields in an array

- add a reference to Excel, create the app object etc and try to read the csv into the worksheet:
http://www.vbdotnetheaven.com/UploadFile/ggaganesh/ExcelSpreadsheet04182005093012AM/ExcelSpreadsheet.aspx [http://www.vbdotnetheaven.com/UploadFile/ggaganesh/ExcelSpreadsheet04182005093012AM/ExcelSpreadsheet.aspx]
http://www.thescarms.com/dotnet/ExcelObject.aspx [http://www.thescarms.com/dotnet/ExcelObject.aspx]
http://www.gemboxsoftware.com/GBSpreadsheet.htm [http://www.gemboxsoftware.com/GBSpreadsheet.htm] (commercial component)



<div>
this should help <a href="http://www.fryan0911.com/2009/05/vbnet-how-to-read-csv-file-into-array.html" rel="ugc">http://www.fryan0911.com/2009/05/vbnet-how-to-read-csv-file-into-array.html</a>
</div>


this should help http://www.fryan0911.com/2009/05/vbnet-how-to-read-csv-file-into-array.html [http://www.fryan0911.com/2009/05/vbnet-how-to-read-csv-file-into-array.html]

<div>
<div class="content wysiwyg-content">
Hi<br />
I need to manipulate a CSV file using visual basic .net, what options do I have and could you provide a sample of the code for connecting to the file or reading into an array? 
</div>
</div>


Hi
I need to manipulate a CSV file using visual basic .net, what options do I have and could you provide a sample of the code for connecting to the file or reading into an array? 

Visual Basic .net manipluating a csv file

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

Development in most programming languages is frequently done with an editor or integrated development environment (IDE). An IDE is a software application that provide comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, build automation tools and a debugger. XCode, Visual Studio, Adobe Dreamweaver and Eclipse are some of the more popular development tools, but an editor or IDE can be anything from simple text editors to sophisticated programs. Related topics: All programming and development language, database and web based content management systems topics