Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Antonio Alvarado (AntonioA8937)
Axtel

Axtel
MX
AntonioA8937 Member since 2019 2 posts
Axtel
Posted: Mar 2, 2022
Last activity: Mar 2, 2022
Posted: 2 Mar 2022 14:18 EST
Last activity: 2 Mar 2022 19:17 EST
Closed
Solved

Save data from csv file via Pega RPA - OpenSpan

Pega has to open file  it as csv (semi column separated) and get row values from input file. after  via Pega RPA, save the values in  variables, after find a cliente in App Pega web put data from variables and repet it for each row.

is there any method of this?

Many thanks in advance

***Edited by Moderator Marissa to change type from Pega Academy to Product; update capability tags***
To see attachments, please log in.
Pega Robotic Automation 8.0
User Experience
Robotic Process Automation
Communications and Media
Account Executive

Accepted Solution

Posted: 3 years ago
Updated: 3 years ago
Posted: 2 Mar 2022 16:27 EST
Updated: 2 Mar 2022 19:17 EST
Thomas Sasnett (ThomasSasnett)
MOD
Contractor
Pegasystems Inc.
US

@AntonioA8937 The ExcelConnector can handle CSV files. This is what you should look at to read the file. Look at the GetCellValue method and the GetLastRow method. The GetLastRow method would be the limit for your ForLoop iterating over the rows.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice