Hold left click down for a certain period of time

[Thiago_Ayusso]

Hello, I need to hold the left click down to scroll right instead of hitting the left button 100 times until I achieve the column that I want to modify. Since I am using the “Text to Columns” activity inside Excel and the file is all in column A before I input the element that separates the columns I need to achieve the column by clicking the right arrow so I can modify it to “Text”.

How can I set the period of time that I want the left button clicking the right arrow?

[jack.chan]

@Thiago_Ayusso
you can try using vba instead

1. copy below code to text file e.g. vba.txt
2. in excel application scope, call invoke vba activity

• codeFIlePath = “vba.txt”
• “EntryMethodName” = “ColumnToText”
• EntryMethodParameters = {ColumnLetter, SheetName} e.g. {"Z", "Sheet1"} to turn column Z in sheet1 to text format
  
  

Function ColumnToText(columnLetter As String, sheetName As String)

ActiveWorkbook.Sheets(sheetName).Activate
Range(columnLetter & ":" & columnLetter).Select
Selection.TextToColumns Destination:=Range(columnLetter & "1"), DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
    :=Array(1, 2), TrailingMinusNumbers:=True
Selection.NumberFormat = "@"
ActiveWorkbook.Save
End Function

alternative
you can also use custom activity

Excel Activities for Processing and Filtering - RPA Component | UiPath...

[Nithinkrishna]

Hey @Thiago_Ayusso

What I understood now, is you have a CSV or Excel with some data having headers.

You want to only pick one column from it ?

Is that correct ?

If the above is clarified, I believe there is a better way to do with UiPath activities instead of UI automation.

Kindly confirm.

Thanks
#nK