Extract confirmation id and save that value in the excel

Help
1

HI,

I am having some set of records in the excel which i need to post in the web page relevant fields.
Once i posted all the column value for the particular row, the webpage will generate the confirmation id which i need to capture in the same excel one by one.
I was able to post the records one by one but unable to get the confirmation id from webpage and paste it in the excel relevant row one by one. Please help me to fix this.

2

@KavithaManivel,

In order to get a text, use a get text activity please, it’s output will generic type.
then write it by taking a write cell activity.

Cheers,
Pankaj

3

Required some iteration also

4

@KavithaManivel,

At the time of reading data from excel row, read index of that row also like: DataTableName.rows.IndexOf(row)+2 and assign this value to integer variable.

  1. After posting all data into webpage, use GetText activity to read ID.
  2. Then use Write Cell activity to write into excel cell. If you want to write into ‘F’ Column then pass below values to write cell activity.

Range: “F”+index.Tostring

Value: GetText activity output.(ID)

1 Like
5

@KavithaManivel,

Please use a below attached file, I don’t have confirmation ID, so i am generating random number and writing it in cell as confirmation ID in my case.

Employee - Copy.xlsx (14.2 KB)
_Test.xaml (12.3 KB)

Cheers,
Pankaj

6

Perfect. Thankyou

1 Like
7

Thank for your support.

8

@KavithaManivel,

If the above solution is working for then mark it as solution and close this thread. It will help others too.

9

How to do that

10

@KavithaManivel,

Below reply to the every post, you can see tick mark symbol. Just click on that.

image

11

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