I am working on a bot that will take data from an excel spreadsheet and update SAP. The spreadsheet will be reviewed by humans and they will mark the rows that the bot can update. I am thinking I will just lock down the spreadsheet and add a column to it for them to indicate the ones for the bot to update. The values in that column could be ‘x’ or ’ ‘. Then I need the bot to only update SAP for the ones with the ‘x’. Two questions: is the ‘x’/’ ’ column the best way to indicate the rows to update for the bot? Also how to I get the bot to only use the rows with the x?
So far I have an excel application scope, read range with that sheet and then a for each row.
Thanks for your help!