Output to multiple files

Hi All,

I am running into an error while trying to output to several files with the same structure to multiple excel templates.

I have about 150 manager reports that were all created from the same template. I then have a workflow designed to output the individual records to the corresponding file based on the file name and the appropriate range. FileName = <Directory>+[FileName]+".xlsx|||Sheet1$B10:P50" . My output tool is configured to "Change Entire File Path" and pointed at the FileName Field. I overwrite the sheet/range and preserve the formatting.

When I run the workflow, the first report gets populated, but it doesn't look like any others do, and I get an error "encountered existing data beyond the specified range." I don't know why I get this error, because all the files are created off the same template, and the workflow runs the same data for all the managers. And the first report appears to populate correctly.

Any thoughts why I might get that error? And how can I fix it?

Output

Accepted answers

MichalM

@RichD

Is it the exact same data for each of the managers? Could you check before the output whether there's same number of rows for each file?

All comments

MichalM

@RichD

Is it the exact same data for each of the managers? Could you check before the output whether there's same number of rows for each file?

RichD

Oh, i did think about the number of rows. I will check. I thought i made the range large enough, but that could be the case. Thank you for point that out. I will see what i find out and repy.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703