Output to Excel Help

lac

Hello, I have a large data set that I need to output to five separate tabs. I know how to do this part but what I'm struggling with is how to output to the five tabs while maintaining the existing excel formatting in each tab. The formatting in each tab is the same just the data is different. Any thoughts how to accomplish this?

output tabs are

Region - NA

Region - EU

Region - IMG

Region - CN

Region - SA

This is what I've done but it's not working, I keep getting an error.

OllieClarke

Hi @lac 

The way to do this is to create the full path of the file/sheet/range in a formula tool before.

Then use this fullpath to replace the entire filepath.

The format for the filepath is

[directory]\[filename].xlsx|||[sheetname]$[RangeStart]:[RangeEnd]

So here I've got a formatted excel:

I then write to that file, preserving formatting, but changing the entire filepath

which then gives me this:

Hope that helps,

Ollie

ExcelFormat.yxmd