Question
Axtel
Axtel
MX
Axtel
Posted: Mar 2, 2022
Last activity: Mar 2, 2022
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.
Accepted Solution
Posted: 2 years ago
Updated: 2 years ago
Updated: 2 Mar 2022 19:17 EST
MOD
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.