Hello, I have a problem. I try to automate a process which copys the ID out of an Excel file and then looks for information in an internal system. When the bot finds the information, he has to extract the data and insert it into another excel file. Everything works except the filling of the second Excel file.
This is how the second Excel file looks like - it should contain all the information the bot copied. The problem is I don’t know how to jump to the next column after for example column “B” was filled. He should automatically jump to the next column for as long as needed. The perfect solution would be an activity which directly works with the Excel file .
I hope that someone knows how to solve this. Thank you !
Person 1 is filled up with data from a different database and from Person 2 on it’s the same one.
I use “Screen Scraping” to extract the infromation and use “Write Cell” at B2 and then I continue with the other data. I thought about using a counter variable which increases after every iteration but it only jumps to the next row instead the column.
I guess it would be possible because afterwards I still can save it as an Excel file. But the problem is that I would net to rebuild the whole process I guess. So the perfect solution would be with Excel. Do you have any idea?
@Emma_Micheilis Considering with your current approach that you would need to move on to the next Column, you need something to Increment from “B” to “C”.
Though you cannot do it directly, But using it’s ASCII values you can get the next Character.
So, If 65 is the “A” Character. The below Expression will get you it’s Character value:
Char.ConvertFromUtf32(65)
You will get the Output as “A”, you can then use this expression instead of the hardcoded “B”.
@Emma_Micheilis Yes, Can you just give it a Try and check. But also I guess you would need to know the number of columns that you would need to enter the data.