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 CC.
Please let me know if any other details are required.
Thanks in advance. .