How do I configure Excel Writer to use an Excel template when I want to write out to a table in the middle of the sheet but I don't know how many rows of data I will be writing out each time?

Here is my solution using openpyxl:

• ExcelReader brings in the data that I want to write out to the template table.
• StatisticsCalculator counts the total number of rows of data that I want to put into the template table.
• PythonCaller runs the code to insert the necessary number of rows and then copy the formatting to those newly inserted rows.
• FeatureHolder makes sure that PythonCaller completes before moving on.
• TestFilter removes the extra blank row added in by FeatureHolder.
• ExcelWriter writes the data out to the newly saved Excel sheet (that has the correct number of rows and correct formatting) and starts writing out to the correct column & row.

This is the PythonCaller (code pasted without comments because I kept getting an error with the comments in):

import fme
import fmeobjects
from openpyxl import load_workbook
from copy import copy
 
def InsertRows(feature):
    wb = load_workbook('Sample_Template.xlsx')
    ws = wb.active
    default_num_rows = 7
    table_first_row = 17
    if feature.getAttribute('_count') > default_num_rows:
        rows_to_add = feature.getAttribute('_count') - default_num_rows
    else:
        rows_to_add = 0
    insert_above_row = table_first_row + 1   
    if rows_to_add != 0:
        ws.insert_rows(insert_above_row, amount = rows_to_add)
        end_unformat_range = insert_above_row + rows_to_add
        unformat_range = range(insert_above_row, end_unformat_range, 1)
        for current_row in unformat_range: 
            col_list = ['A', 'B', 'C', 'D', 'E', 'F']
            for current_col in col_list:
                current_cell = current_col + str(current_row)
                format_cell = current_col + str(table_first_row)
                ws[current_cell]._style = copy(ws[format_cell]._style)
    wb.save('Sample_Template_Correct_Rows.xlsx')
    pass

 And this is what the output looks like: