To copy data of one excel to another and add one column in the copied excel and send

[archies.gall]

Hi,

I want to develop a C# console application that will read one excel file and make copy of that file first.
Then in the copied file i need to add one column at 2nd last position in excel and remove the 2nd column from the copied excel.
The added column will have count of some applications.

Then the whole excel content should be placed in the email body. (Note: I dont want to send attachment).
and it should trigger email to the specified person in To.

[Bill Crawley]

If you have SQL Server, then SSIS would be the tool for this. It is built to perform a copy, you can add a derived column before output and you can perform a Send E-mail task after.

[archies.gall]

Hi Bill,

Thanks for the reply.
I am not using SQL.

Regards,
Archie

[Bill Crawley]

In that case, I'm not going to re-invent the wheel. There are lots of examples out there. To get you started google using ado.net with excel This will gove you lots of start points. http://support.microsoft.com/kb/316934 is a good start point