topic RE: Reading data from csv in Product Forum

Reading data from csv

Soumya21 — Thu, 12 Oct 2023 10:00:00 GMT

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

RE: Reading data from csv

salman_shaik — Thu, 12 Oct 2023 10:34:00 GMT

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

RE: Reading data from csv

LeonardoSQueiroz — Thu, 12 Oct 2023 17:12:00 GMT

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