I have a configuration spreadsheet with multiple rows and columns. The cells in each row are filled with parameters that I would like to passed to a (sub) protocol. As the number of rows on the spreadsheet can vary, I want to call the subprotocol a variable number of times, each time with a row full of parameters. The desired output will be an Excel workbook where each sheet is created by one run of the (sub) protocol.
Can anyone suggest a general approach for achieving this?
Thanks in anticipation.
Can anyone suggest a general approach for achieving this?
Thanks in anticipation.