Need help copying Excel formatting from one workbook to another

[AJadhav45]

Hi everyone,

I’m facing a challenge and hope to get your guidance:

✅ Goal

• Copy one or more formatted worksheets (with styles, headers, conditional formatting) from a source workbook.

• Paste the data into a different workbook, where the data range varies between the source and destination files

What I've tried

1. Table + Render tools to build reporting tables — but they choke on large datasets and distort column widths. The Render tool does not auto-scale for Excel output, even with custom “paper size,” so it’s not practical when data is large

2. Blob Input + Blob Output pattern: I read a formatted template via Blob Input, then overwrite parts of it with data via Output tool. This preserves formatting, but struggles when the data range is significantly different between source and destination .

[Raj]

Can you exactly share the issue faced while using Blob approach?

[AJadhav45]

I’m struggling with the configuration — sometimes it seems that the data is replacing the entire range, or the output file’s range is different from the template or input file range. Please note this.