I am trying to include an excel to pdf conversion within a For Each Row loop. My bot is running with no errors, but instead of printing and saving all of the PDFs, it only prints the last one. The information is looping into the excel template correctly, but instead of saving each pdf, the excel file is overwritten each time the loop circles back. Can anyone help with this?
I think, for each excel to pdf file conversion, you need to change the pdf file name when you are saving it. You can include a count in the saving activity to save the pdf uniquely for each iteration.
I am using the excel to pdf activity. How would I add a count to this?
Are you using this activity?
If yes, please uncheck Replace existing check bix.