Extraction of data

Help
#1

Can anyone help me? I would like to extract this 4 columns of data from excel file in uipath and paste it in clipboard. After that i will paste it in a software. But idk how. If possible, mind typing out the codes in uipath and screenshot to me? Thank you in advance

#2

Hi @W_QW

First of all, pleas follow our training on the Academy to learn more about basics of UiPath :slight_smile:

This should be quite straight forward:

  1. Read Range activity to load your Excel file into a DataTable variable.
  2. Output Data Table activity to convert your DataTable variable into a String variable
    And then either
  3. Type Into activity to type the string into the field
    OR
  4. Set Clipboard activity combined with Send Hotkey activity to send CTRL+V to the field

Some screenshots for context:
image
image image

#3

Ohh ok. Do you mind doing it on uipath and send me? sorry because I am new to UIPath.

#4

Sure, check this sample:
OutputData.zip (9.6 KB)

#5

Thank you for your help anyways!!

#6

You can use Set Clipboard activity combined with Send Hotkey activity (CTRL+V) to achieve that :slight_smile: