I just started using the Continental nodes.I want to append a worksheet and then apply formatting to that specific worksheet in the workbook. From what I can tell the XLS Formatter (apply) node does not let me target formatting to a specific worksheet which I find surprising.
I think that I might need to just configure something to get it to overwrite the formatting on my desired worksheet.
Does anyone have experience with this? I really appreciate the assistance!
In the example below, the Excel Sheet Appender works. But the XLS Formatter (apply) node applies the formatting to the default (1st) sheet of the workbook. Is this impacted by variables somehow?