I am working on a process where we have an excel file with several worksheets, each of which is a variation on a template to use in a given circumstance. The process copies the appropriate worksheet into a new file, populates pertinent data into a datatable, then writes that datatable to the new template file once ready. After that, I am trying to export the Excel to PDF. I have tried both this and this package in order to accomplish this, and in both cases I encounter the same odd behavior - the contents of the file that were copied from the original template are present in the export, but the new data written by the bot is not.
In debug, I have confirmed that the data is written to the file and saved prior to the export. I have also confirmed that I am referring to the correct file in the export activity. Does anyone know what might be happening here?