How to read certain records from excel/csv

Hi Experts,

I have developed a process where the robot,opens the application and downloads the CSV and then converts it to Excel and then sends the email, now I need to read certain records from that Excel file and copy it to the email being sent.

Please advise how can i achieve this.


Hi @Ashik_Khan
1.use start process
2.Download the csv file and use read csv files
3.use write range activity
4.use send mail activity
5. Read range of Excel and
Send mail activity pass dt


Thanks for your reply Ashwin, i have tried this step earlier for ReadCSV activity, it gives me error as the CSV file format is invalid…