Create a script which parses through a directory of files, searching for the three files listed below. The script must then compile all the data from these files into one master file and highlight cells according to processor generation.
The script must utilize:
- strings
- variables
- loops
- conditional expressions
- functions
- file input/output
- openpyxl library
- WorkBook class
- load_workbook object
- openpyxl.styles library
- Font class
- Alignment class
- PatternFill class
Files:
Intel_Core_Processors1.xlsx
Intel_Core_Processors2.xlsx
Intel_Core_Processors3.xlsx
Final Output:
Master_Intel_Processors.xlsx
Create a script which parses through a directory of files, searching for the three files listed below. The script must then compile all the data from these files into one master file and highlight cells according to processor generation.
The script must utilize:
Files:
Intel_Core_Processors1.xlsx
Intel_Core_Processors2.xlsx
Intel_Core_Processors3.xlsx
Final Output:
Master_Intel_Processors.xlsx