Question 2 Replies 900 Views × Close popover Shilpa Shrivastava (ShilpaS0540) Princeton Blue BPM Solutions Princeton Blue BPM Solutions IN View Profile Send Message ShilpaS0540 Member since 2017 7 posts Princeton Blue BPM Solutions Posted: June 29, 2017 Last activity: July 28, 2017 Posted: 29 Jun 2017 5:56 EDT Last activity: 28 Jul 2017 2:33 EDT Closed Solved How to insert record into Excel (next empty row) Hi All, I implemented an automation where that automation reads data from the PDF and write those date into Excel Sheet. When again I read the data and trying to write into same Excel file, All data are replacing with the previous one(records insert in same row) because cell value is hard code. "I want to insert the record in the next empty row" so the previous record will not change. I have also attached Automation. Please find the attachment and suggest where I need to change the flow and which method requires. ***Moderator Edit: Vidyaranjan | Updated Categories*** Robotic Process Automation × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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. Accepted Solution Posted: 3 years ago Posted: 29 Jun 2017 6:58 EDT × Close popover Jeff Badger (jeffbadger) PEGA Product Manager, Robotics Pegasystems Inc. US View Profile Send Message jeffbadger PEGA replied to ShilpaS0540 In your automation you are always setting the same cells. Use a counter variable to increase your row each time you write it. Here is an example: Posted: 3 years ago Posted: 10 Jul 2017 15:02 EDT × Close popover Sivaraj Muthusamy (SivarajMuthusamy) Accenture Accenture IN View Profile Send Message SivarajMuthusamy Accenture replied to ShilpaS0540 Hi, If you try to use oledbquery component this can be achieved by writing insert into sql query.