topic RE: How to read 3rd row from excel and print message in Product Forum

How to read 3rd row from excel and print message

AnkitShukla11 — Tue, 28 Nov 2023 07:11:00 GMT

How to read 3rd row from excel and print message

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

RE: How to read 3rd row from excel and print message

Tejaskumar_Darji — Tue, 28 Nov 2023 10:53:00 GMT

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
------------------------------

RE: How to read 3rd row from excel and print message

abhis3kh — Tue, 28 Nov 2023 18:25:00 GMT

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
------------------------------

RE: How to read 3rd row from excel and print message

AnkitShukla11 — Wed, 29 Nov 2023 08:56:00 GMT

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
------------------------------

RE: How to read 3rd row from excel and print message

LeonardoSQueiroz — Sat, 02 Dec 2023 22:54:00 GMT

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
------------------------------

RE: How to read 3rd row from excel and print message

harish.mogulluri — Sun, 03 Dec 2023 04:13:00 GMT

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
------------------------------