Posted: 16 Aug 2017 0:41 EDT Last activity: 6 Nov 2018 20:02 EST
Read data from CSV file without locking file
Can you please advise, how to read data data from CSV file (using Excel Connector) in read mode. My requirement is to read data from CSV file whenever sheet changed by some other process (using SheetChange event in PEGA RPA)
**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.
The connector does not have an option to open in read-only mode. You might look into using a FileSystemWatcher component to detect changes to the file and process it that way. You could then make a copy of the file and open the copy using the connector to gather whatever changes have been made.