Jan-20-2020, 08:00 AM
Hey all,
A python beginner here. I need to create an app that will analyze excel sheets. The idea is:
1. A user inputs 2 excel sheets, one will work as a template and the other one needs to be filled in
2. the app needs to analyze the content of the cells and find cells that match the titles between the template sheet and the draft sheet and fill out the numeric value from the template sheet accordingly.
In other words I just need to automatize a specific process, where right now whenever we need to fill out new excel sheets we need to work on two windows and just copy paste numeric values from the template sheet to our works sheets.
Could someone give me some tips on how to start?
A python beginner here. I need to create an app that will analyze excel sheets. The idea is:
1. A user inputs 2 excel sheets, one will work as a template and the other one needs to be filled in
2. the app needs to analyze the content of the cells and find cells that match the titles between the template sheet and the draft sheet and fill out the numeric value from the template sheet accordingly.
In other words I just need to automatize a specific process, where right now whenever we need to fill out new excel sheets we need to work on two windows and just copy paste numeric values from the template sheet to our works sheets.
Could someone give me some tips on how to start?