I have a large excel file in which there are two columns A, B (with 10,000 rows).
I want to do Column A - Column B and store it in Column C. The answers I have seen in forum till now performs the operations on the excel cells one-by-one by changing the cell value and looping it.
Is there any solution if we can take the data into dt and add column C in dt and then perform the operation. and then write it into the excel?
Any other efficient solutions are also welcome.