I have a workflow grabbing 3 numbers from 3 different PDFs and inserting into an excel workbook using the write cell activity (see attached workflow).
My issue is that the excel workbook is now reading 2 of the 3 values as an excel “text” value, so the sum function within the worksheet is not working. For some reason, the 3rd value being passed to excel is being interpreted as an excel ‘number’ value.
I’ve tried removing all formatting in the workbook and re-adding the formatting before running the UiPath workflow, but that didn’t help. I’ve also tried converting to decimal, but the write cell activity requires a string input. Manually typing the numbers in the workbook works properly, even after the workflow has ran.
If I just type in a string variable that isn’t pulled from a PDF, it seems to work perfectly. For some reason, the fact that it pulls the string variable from a PDF seems to be the part that is screwing things up. Anyone have an idea?PDF to excel as values.zip (302.0 KB)