Robot does not click on Finish Text for Excel columns

Help Studio
, ,
1

I have a problem, the robot needs to read a date column and I need to count the lines per month, but I had a problem with the activity of counting the lines, because the filter was not recognizing the value, so I thought it best to use in Excel Text for columns and delimit the value by month, the robot runs perfectly even before completing, when you click on complete the table does not divide, the click and send hotkey does not seem to work in this Excel activity. What can I do for the robot to click on this to complete?

image

Because if it clicks, it will work perfectly, because it will read a column of the month and enter the loop.

2

There are activities that do Excel Text to column

1 Like
3

thanks for your reply, but you can help me? because i didn’t find this package

4

I couldn’t find the activity unfortunately. I’m sure i’ve seen it. Might have been internal or StudioX.

Anyways, I wrote some code for that assuming your delimiter is a space. It should help.
Main.xaml (6.4 KB)

You’ll need to install this dependency:
image

Here’s more documentation if you want to mess around with it:

5

Okay yes, it was the Studio X activity. Here’s how to use it:

image
image535×716 16.7 KB

You’ll probably need to enable the filter in the activities pane.
image

I would personally use the invoke code method because you don’t have to flip flop excel scopes (haven’t figured out how to use studio x activity in the normal Excel scope)

Hope this helps :slight_smile:

1 Like