I’m developing a process which I need to extract data from a PDF and paste it to Excel.
Currently I’m facing a problem where my Excel looks like this:
The method I’m using is extracting all the values using the “Get Text” activity and then using the “Add data row” in order to populate the Data Table. After that I just try and use “Write Range Workbook” to write in Excel.
Hope you guys can help! 
Cheers!
It looks like you’re using add data row multiple times, once for each extracted value. You need to use it just once for each row you want to add, with the values given as an array.
Can you share the screenshot of the flow. May be like you have used multiple Add Data Row activity to write it back to excel. Please share the screenshot of the flow.
Regards
But how would you do it?
Do you use Multiple Add Data Row. Use single Add Data Row and give the variables within curly braces like {var1, var2, var3}.
After loop use Write Range Workbook to write it to excel.
Regards
Can you show an example?
He did show an example. You just use ONE Add Data Row after you’ve collected the values, then put those values as an array into the ArrayRow property.
{"Value 1","Value 2","Value 3"}
Those values can, of course, be variables, expressions, etc.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
