On a normal day at work, I had to merge a large number of Excel files, each of which was related to the information of trucks in an operational area for a period of one year, about 26 files (each file contained one year of information). I very quickly decided to write this code and solved the challenge in very less time without wasting much energy and time, Then I realized that my colleagues (especially the non-technical ones) are heavily involved in this issue and waste a lot of time on a daily basis! So I decided to share the code here.
1- Just put the desired Excel files next to the main file of the program.
2- Run the ConcatenatedTables.py file.
3- After execution, a new file called 'Final.xlsx' will appear immediately, which contains all the information.
- Practice and improve how to write neat and clean code, write descriptions, use classes, manage errors, work with files, learn to connect VS Code to GitHub and use different commands and...
Learning continues ♥
www.linkedin.com/in/farid-moghadam