I've been searching for a way to do the following:
from openpyxl.worksheet.copier import WorksheetCopy
workbook = openpyxl.load_workbook('input.xlsx')
template_worksheet = workbook.get_sheet_by_name(sheet_name)
new_worksheet = workbook.create_sheet('New_Sheet_Name')
instance = WorksheetCopy(template_worksheet, new_worksheet)
You will have to use python package for this task, I recommend you use
openpyxl package. Basic usage of the package can be found here.
You will basically read the excel and at the same time write a new excel, copying data row by row.