Here i have 2 columns columnA and columnB having integer values and i wanted the addition result of columnA and columnB in 3rd column i.e. columnC. But i want this in 2 different way.
Q1. Keeps the excel open and writes the result in real time, row by row so you can see the changes.
Q2. Keeps the excel closed,set the column values in the memory DataTable and adds all the tables to the excel file at once in the end.
Experts pls help