By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,918 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,918 IT Pros & Developers. It's quick & easy.

csv manipulation with vb.net

P: n/a
Hi All,

I have an issue with some Excel spreadsheets which i need to take the
data that is in them and re-arange it into a useful (to our management
system) format.

I would like to write an application whereby i can select a file
through a dialog box, manipulate the data, and output to csv in the
new format.

Can anyone point me to a good resource or tutorials on this subject?

MTIA

Keith
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Keith,

In my opinion it is in the net the most simple to read the excel data in a
dataset do some operations and than writing it using the streamwriter to
csv.

The only difficult thing for it is the connection string and that is here

www.connectionstrings.com
Use that to make a connection.

Create a new datast
Create a new dataadapter with the connection string and a select like this
"Select * from [sheet1$]"
fill the dataset using the adapter
And you are almost there.

For writing the CSV file you can just use the streamwritter while looping
through the dataset.

I hope this helps?
Cor
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.