Excel Compiler

A lightweight excel compiler written in Python using openpyxl

FEATURES:

• Column merge based on column names
• Index match
• Batch compilation of excel files (just drop them into 'To Be Compiled' folder)
• Define your template format/arrangement for the compiled tables
• 3 modes of compilation: standard - 1 sheet per excel file master - all sheets in 1 excel file polymerise - all sheets in 1 sheet in 1 excel file

How to start:

1. Open excelCompiler.py in editor
2. Place target excel files into 'To Be Compiled' folder
3. Define required attributes/col names/file location (line 136 - 144)
4. Run excelCompiler.py

FUTURE IMPROVEMENTS:

• Create a user interface for ease of use

Created by: bryanlzl