Uipath robot with ocr to excel

Help Robot
,
1

Good day everyone, I have a problem, I have a robot that brings information in pdfs in OCR and the variable is of type system.collections.generic.dictionary<system.string, system.string> what I want is for that information to come in that variable such as name, account, client, dpi, date, etc. is stored in an existing excel which already has a header, could someone help me

2

@Daniel_Hernandez1 ,

Please follow the steps below:

  1. Use Assign activity. Create a DataTable type variable and assign this as value Newtonsoft.Json.Linq.JArray.FromObject({yourDictionaryVariable}).ToObject(Of DataTable)

image
image823×301 14.8 KB

  1. Use Append Range activity to append the data of varDT to your excel file.

image

Thanks,
Ashok :slight_smile:

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.