Hi - I used this post to write multiple outputs from a single workflow to individual sheets in excel.
But I am wondering if the tool can be configured to overwrite only specific ranges within each tab (the same range for each tab).
I am able to do this when configurating the Output Data tool ("C:\\test.xlsx|||Sheet1$a10:b20" ) when I am not writing to multiple tabs.
But when doing using dynamic method provided in the post, it is not working as expected, and each sheet is overwritten entirely each time.
Any thoughts? Thanks!
Solved! Go to Solution.
see the bottom dropdown on your output data - "change entire path" has to be selected. you can then send in your full filepath with:
filename.xlsx|`sheetname`$range send into your output data.
@jkell You're almost there - It looks like you have Cust ID selected at the bottom. I'm assuming you want each sheet in the output to use the Cust ID as the sheet name. Since you're now changing the entire file path, the field selected here needs to contain a full path instead of just the sheet name.
You'll want to create a new field which contains the full file path where you want the data to be output:
Then select that new field in the Output Data tool and uncheck the box for "Keep Field in Output"
Hope that helps!
@kboeckholt Bingo! That did the trick, thank you!