Cant convert data to use "type into" activity

Learning Hub Academy Feedback
, , ,
1

I am practicing about “robotic enterprise framework”.

The assignment: Build the workflow to search the Google Finance by an Excel Input (5 different companies like AAPL, GE, NOK, MSFT and WMT) and then write the stock prices to the same Excel file. The workflow is:

  1. Start IE and Google Finance
  2. Read stock names from Excel
  3. For each case found in Excel
    a. Search stock from Google Finance
    b. Read stock price from Google Finance
    c. Write price to Excel
  4. Close IE & Save Excel

I am having problems, I can’t get the data from excel to write in “type into” activity (it’s in process transaction)

This is my process

Assignment3_SearchingGoogleFinance.zip (529.0 KB)

Untitled
Untitled1366×768 94.6 KB

1 Like
2

@havi

Did you try to read first the excel to get the data on in like ?
Read Range Activities and pass the value to the data type datatable ?

cheers :smiley:

Happy learning :smiley:

3 Likes
3

@pattyricarte oh tks, but now, I have the other problem. when using template: Robotic Enterprise Framework, transaction 1 is finished and written into excel, transaction 2 is finished and inserted into transaction data box 1, how to write in a row?

1 Like
4

@havi
That’s great ! What do you mean how to write in a row ?

Do you wan’t to write the data in excel file is that what you mean ?

cheers :smiley:

Happy learning :smiley:

2 Likes
5

yes, but I done, tks so much

1 Like
6

@havi
No problem happy to help here!

Cheers

3 Likes