My requirement:

I need to do reconciliation of two data, ie.., 2 separate Excel sheets(Excel A and Excel B), I need to compare and perform some calculations on multiple columns. Based on that I need to create an output excel (Excel C).

I have licensed VS Studio with me, please help me the best way to proceed with this requirement.I have the following doubts in my mind:

1. Should I use C# or Python (currently the existing is C# for generating Reports )
2. In order to compare is there a necessity to stage these tables in a DB ? If so which one to use ?
3. Can we go ahead with the reconciliations without using a DB Stage? If so please suggest the best easier way .

Please suggest.

I really am confident that I will get very apt solutions here.

Thanks again!

Best, Jay