opying content of one excel to another excel

Posted by Archies.Gall under C# on 7/26/2012 | Points: 10 | Views : 1535 | Status : [Member] | Replies : 1
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.

I have developed a code that will read the data from excel and dispaly it in the html table format in the email body.
But now i want to create a copy of a main excel and edit the copied excel.
In copied excel i want to delete one column and add one column.

After that i want the content of excel to be displayed in the email body.



Posted by: Megan00 on: 7/26/2012 [Member] Starter | Points: 25

I think you can use the merge excel function to merge the two excel files directly and then, add column and delete column.

merge Excel:
and then, use the below code to delete and add columns in the merged excel:


Never give up! Smile to the world!

Archies.Gall, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response