How to get value using read cell

Help
1

Hello guys, I want to get value using read cell.
For example

nanyaforum%201
nanyaforum%201410Ă—589 9.64 KB

I want to get the text A - P one by one and then type it into somewhere.
This is my workflow.
nanyaforum

What should I do? Thank you very much.

1 Like
2

try using a Read Column activity, or a Read Range activity to get the whole table.

1 Like
3

Read cell returns a generic value, while output data table is receiving a DataTable object. What error are you getting at Output Data Table activity?

1 Like
4

this is the error

nanyaforum%202
nanyaforum%202448Ă—520 14.9 KB

5

Of what type is NamaFinal?

1 Like
6

GenericValue

7

Try changing it’s variable type to String.

1 Like
8

Buddy @claudiojody

  1. Use excel application scope to open the Excel
  2. Use read range activity to get the output from the Excel and get the output variable as out_dt
  3. Use a for each row loop with input out_dt
  4. Inside for each row loop use a read cell activity like this
    With input of sheetname and range like
    “A”+out_dt.Rows.Indexof(row).ToString
    And get the output as out_value
    This would give you the first column cell value from each row one by one
  5. Then use type into activity with input out_value that would type into notepad as you expect
  6. Thats all buddy you are done…

Kindly let know whether that works or not
Cheers @claudiojody

3 Likes
9

It works, thank you so much buddy!!

1 Like
10

Cheers buddy keep going… @claudiojody

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.