cancel
Showing results for 
Search instead for 
Did you mean: 

Reading data from csv

Soumya21
Level 6

Hi,

I want to read data from CSV file and add it queue. But I have large number of data I need to split the data and add to queue (Without using excel actions)

How can this be done?

If anyone have idea, please help me on this



------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------
2 REPLIES 2

SalmanShaik1
Level 5

Hi Soumya,

You can use Get CSV Text as Collection action from File Management VBO which will load all the data into collection. From the collection you can split the data based on your requirement and add it to queue.



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

Thanks & Regards,
Salman Shaik
------------------------------
If I was of assistance, please vote for it to be the "Best Answer". Thanks & Regards, Salman Shaik

LeonardoSQueiroz
Level 10
Hello, there are a few ways to do this, including 2 that are usually most used:
 
1. Through the File Management VBO utility and action called Get CSV Text as Collection
2. Using OLEDB usage example: https://www.youtube.com/watch?v=rF2fw42LWl8
 
Regards


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