Output Data to Excel using cell ranges

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?

Output

Help

Accepted answers

bradtukey

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.

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703