DataTabale To Excel

Question

Dear All,

 

I prepaid below Excel sheel through c# converted from DataTable to Excel thorugh Loop but the Last row I did manually in Excel.

 

What i need when my loop will finish then in Last row should be the Total in Excel and the row is not fixed my sometime row will be 5 may 50 whenever finish my loop then  last should be Total like below.