Output Data to Excel using cell ranges

[bradtukey]

Hi. I have 2 Output Data operators and I'm trying to write both outputs to the same Excel worksheet. I'm using the same Output Option on both "Overwrite Sheet or Range", and "Preserve Formatting on Overwrite" and I'm inputting different, non-overlapping cell ranges in both Operators. When I run the workflow, only the 2nd of the two outputs is written into the worksheet. I'm also using separate Control Containers for each ouput. How can I get this to work?

[nagakavyasri]

@bradtukey Check if the sheet name mentioned in Output is different for both the Outputs.

[caltang]

Can you screenshot your configurations? Also note that if you are copying both outputs or even using replace full path, it could cause this. Without screenshots or even the workflow, it is hard to ascertain.

[bradtukey · Accepted solution]

Thank you for all the replies. I have resolved this (I was writing to full path from a filepath field), but still have an issue where the formatting isn't preserved. On first export, I open the excel and make each range into a Table. But, if I export new data into the same ranges, the Table formatting is gone. I do have Preserve Formatting on Overwrite enabled.