https://portal.blueprism.com/products/developer-jumpstartOn that page, there are some templates you can download, but I don't know if there is one specifically for what you need. Might as well check though.
For excel, the common pattern is to do these order of actions (I may have the spelling wrong on the action names because I'm typing this from memory because I'm lazy):
- Create Instance
- Show (optional)
- Open Workbook
- Get Worksheet as Collection (there are a couple of these actions to choose from)
- Close Instance (or Close All Instances)
------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company