I have a number of problems that I would be happy if someone could help me with.
I am trying to read a cell in an Excel file (this is the requirement) using the Click activity and keyboard shortcut.
I need to do this dynamically without being able to know how many rows there are. So I used a flowchart and used Click and Clickboard, and then clickboard, but I notice that every time the values that are saved to me instead of being the cell value are actually the last value that I performed Control C on on the computer and I can’t overcome the issue.
There are times when the cell is empty in Excel and the type is not a string. So as soon as I save it in a variable, say a Double type, I try to understand whether it is empty or not, and it doesn’t allow it.
Even when I saved the value as a string first, checked it, and only then tried to cast it, it doesn’t work.
When using the UIApplicationBrowser for Outlook, when I try to add values to my contacts for several iterations of people that I capture from Excel, a situation occurs where the moment I perform a second iteration, the actions are no longer captured in the automation, meaning that in the places where I used them by clicking and marking the area, it supposedly no longer captures the screen, and then it doesn’t do what is needed.
For reading from excel, I would suggest to use excel application scope and read range so you are able to read all cells and save it in a data table. Then you can use the for loop to traverse through its elements.
Please refer below documentation for more details:
Also for outlook, you can directly use Send mail activity to compose an email and provide the list of recipients.
Hi, first of all, thank you very much for the answer.
I realized that I managed to search that there are other ways to solve the problem, but I have to use the actions I mentioned. I guess with their help also the work can be done, I’m just probably doing something wrong. And I can’t solve it using alternatives i need to solve them with this activity that i write.
Yes i need to read all the row in the excel cell peer cell and i need to use the activity click keybord sortcat and get from keybord. When i use it its preform the problem that i wrote in the question.
