How can I automate this process in excel?

Help Studio
, ,
1

hi all,

how can i automate this process such that for inputs (memo line set, name, description, etc) will read from the excel starting at row 8 using different excel cells (A - memo line set, B - name, C - description, etc)?

ss
ss1659×296 29.4 KB

ss1
ss11879×75 30.1 KB

2

Hey @attkren1 ,

  1. Within the “Excel Application Scope” activity, use the “Read Range” activity to read the data from the Excel file.
  2. Configure the “Read Range” activity to specify the sheet name and the range from which to read the data. For example, if your data starts from row 8 and the columns are A, B, C, etc., you can use the range “A8:Z” to capture all columns starting from A and row 8 until the last column in row 8.
  3. Use a “For Each Row” activity to loop through each row of data read from the Excel file.
  4. Inside the “For Each Row” activity, you can use the “Assign” activity to assign the values from each cell to the corresponding variables representing your inputs like
    Then use browser activity and inside it use a type into activity and indicate the input field
    Then in type into activity write it has
    row(“A”).ToString()
3

Hi @attkren1

  1. Use “Red range WorkBook” activity to read the data and store it in an data table.
  2. Use “Use Application/Browser” activity to open the website by indicating the screen.
  3. Under Use Application/Browser add “For Each Row in Data Table” to iterate through each row in excel.
  4. Give “Type Into” activity and pass the currentRow value in that activity like below:

CurrentRow(“Column Name in excel”).toString

Make sure you give the same column name as you have in excel.
5. If you have further process you can continue with that.

image
image662×1030 35.8 KB

You have to use type into for every input you enter into the website.
Hope it helps!!
Regards,

4

Hi @attkren1

→ Use the read range workbook activity to read the excel and store it into a datatable in this activity there is a option called Range in that give the range of you required you want it from 8th row right then give “A8:last cell value”.
→ Use application\browser activity to indicate the webpage that you want to enter the details.
→ Use for each row in datatable activity to iterate the datatable
→ Use type into activity to write the data in the datatable to webpage. (Currentrow(“Column name”).toString)
→ Use select item activity for dropdowns and give the same column value you want to select (Currentrow(“Column name”).toString)
→ If you want to click on okay or submit button use click activity.

image
image880×1270 69.1 KB

You have to give the range here
image

Hope it helps!!

5

The column name should be “CurrentRow(“A”).ToString” for instance right?
Because i get “column ‘A’ does not belong to table DataTable?” error when trying out this method

6

The column name should be “CurrentRow(“A”).ToString” for instance right?
Because i get “column ‘A’ does not belong to table DataTable?” error when trying out this method.

7

ss3
this is my workflow

8

@attkren1

Do you have headers in your excel. If yes give the header name in place of A
Eg: CurrentRow(“memo line slot”).toString

Regards

9

if this is the case, do my highlight starts from A7 or A8?

ss1
ss11879×75 30.1 KB

10

@attkren1

In Read range give the range from where you want to read the excel.
Regards

11

yes i understand. i only need the string input on the excel but u indicated that if there is header, i should include the header as name. Does this means i have to include A7 (header name row) into the read range?
I am currently using A8:whatever i need.

12

@Parvathy
also, does jumping row by 2 (from 8 to 10 to 12 etc) affects the workflow?

ss4
ss41833×145 65.8 KB