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

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?


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

The only difficult thing for it is the connection string and that is here
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?
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.