excel-merge

Combine data of multiple sheets in a workbook into a single sheet

Aim: This program merges multiple sheets in an excel file into a single sheet in a new excel file.

Execution:

1. Select the .xlsx file whose sheets need to be merged
2. Input the row number of the column headers
3. Input start and end column letters
4. The new merged file will be created at the same location as the file selected

Constraints:

1. All sheets must be in a single excel file and in the same format
2. Same headers at the same row in all sheets

Installation:
pip install openpyxl

Note:
This is a starter project with a potential for improvement and growth.