cancel
Showing results for 
Search instead for 
Did you mean: 

How to read 3rd row from excel and print message

AnkitShukla
Level 4

How to read 3rd row from excel and print message



------------------------------
Ankit Shukla
RPA Developer
Arvius Software Pvt Ltd.
Noida
------------------------------
5 REPLIES 5

You can use MS Excel VBO to read Excel file data in a collection and then use it further.

There is no such print method in BP, so you can store it in any data item to see the value.



------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------

abhis3kh
Level 4

Hi @Ankit Shukla

Could provide more details on your requirements? It would be helpful to answer your question. 

Answering as I understand from your question: 

As TeJas already mentioned you can read the excel data into a collection. Then you can create two variables called destinationRow & currentRow. Whatever row  you want to read, assign that row number value to destinationRow data variable. then Loop the collection and increase the currentRow Counter by 1 & put a decision stage destinationRow=currentRow, if yes, you will break through the loop and perform the next if not continue looping. 

Let me know if there anything else you are looking for. Happy to help. 



------------------------------
Abhisekh Mukherjee
------------------------------

I have 3 column 

Name

AgentNAme

And CallId 

I need access callID and also print in the log file 



------------------------------
Ankit Shukla
RPA Developer
Arvius Software Pvt Ltd.
Noida
------------------------------

Hello,
 
To do this, you can use the action of writing to a file, incrementally and include the additional information you want.
 
Regards,


------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
Leonardo Soares RPA Developer América/Brazil

Below are the highlevel steps I would follow to read the  column


1)  use Loop stage to loop the  desired collection

2) Inside the loop   either use  comma seperated  structure in the data item and update the data item> after the completion of loop write back to csv or text file  another approach is writing in to the file while looping.

 I would rather keep it in the data item if  the data is  not huge.



------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------
-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri