Rookie here! I’m sorry if this might be something that came up before, but I searched a lot, and either didn’t understand the solution, or tried and it didn’t work.
I have an excel file with columns Sheets: “Data” and “x1”. The “Data” sheet contains multiple columns:
“ID”, “x1”, “x10”,“x100”,“Date”,“time”, while the Sheet “x1” only has 3 columns; “x1”, “x10”, and “x100”. I’m using Uipath to collect the price of items by lots of, 1, 10 and 100 in a game (used citrix OCR method)
The process starts by entering the names of the items I want in an excel file under the column “ID” of sheet “Data”. (I used append range) Whenever a a value is entered in column “ID”; “Date” and “Time” are updated by themselves using a VBA code. Therefore, after this process, only the columns “x1”, “x10” and “x100” are empty. This is the result:
The process then continues by extracting the remaining data with Google’s OCR. I used the generate datatable to automatically separate my data into 3 columns using a separator (the letter K) and outputing in an output data table. After each data is extracted, the data is appended in the second sheet (“x1”).
My issue is I want the OCR extracted data to be appended in the columns of the first Data Sheet. In columns x1, x10 and x100. I tried selecting a range, and then append data, I thought this would append the data to the columns, but it didn’t work.
Is there a way to achieve this? Or copying the data from my second sheet “x1” and append it to the proper data in sheet “Data” ?
EDIT: Forgot to mention that this process will be repeated a lot ! The data will be added in the same way everyday. So I do not want my current data to be overwritten.