Question4Replies6807Views sitharal Member since 2017 1 post Virtusa Polaris Posted: May 24, 2017Last activity: November 6, 2018 Closed How to read a text file with comma seperated values in Open Span?I'm trying to read comma seperated values from a text file and upload to a desktop application. How can I achieve this in Open Span? Appreciate your guidance.**Moderation Team has archived post**This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post. Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agosasnt PEGA replied to sitharalYou can use the Excel connector to open and read a CSV file. The GetCellValue method can be used to extract the value of a specific cell. You can iterate your rows and columns to acquire data row-by-row and pass it to your other application. Posted: 3 years agoJaimeE47 Escobar Rueda replied to sasntHi, how are you? How can I read an Excel file row by row without using a LookUpTable? Is it posible just using the Excel connector or must i use a c# script in order to achieve this? Thanks in advance. Posted: 3 years agosasnt PEGA replied to JaimeE47A lookup table is where you might store the results as you read them. If you want to just read a row and grab the values, you wouldn't need to store it in a LookupTable. Posted: 3 years agojeffbadger PEGA replied to sitharalHere is how to use a StreamReader and StringUtils to process a csv file. Add a constructor for a System.IO.StreamReader to your automation. Now build a simple automation to loop through each line, split on the comma and process the results (fill in what you need to do in the Process step).