Output to a merged excel cell

[Paulomi]

Hi all, I'm trying to update a merged cell in Excel through Alteryx. I do not want to include reporting or table tools in this process. Is there a way to do that with a normal output tool? The idea is to write to a merge and center cell.

[Jean-Balteryx · Accepted solution]

Hi @Paulomi ,

Using the output tool you can write to a specific cell range, have you tried specifying your merged cell ?

[atcodedog05 · Accepted solution]

Hi @Paulomi 

As @Jean-Balteryx suggested you can do like this.

Before:

Output tool:

1. Configure to write to range

2. Output option to overwrite sheet.

3. set Preserve Formatting on overwrite 

After:

Hope this helps : )

[Paulomi]

Hi, thank you both! I had done both of these steps, and still it wasn't working, which is why I came to this query. But as it turns out, there was a problem with the Excel itself. So, I changed the template and it worked! But, yes, what you highlighted above is the way to go with this. Thank you so much! 

[Jean-Balteryx]

You are welcome @Paulomi !