read data from one of excel sheets

yuanlu

I have a Excel file (attached) with 2 sheets (or more), I have 2 workflows need to read from  sheet 1-62 and sheet 63-74 respectively. Is there a way to have these 2 workflows connect to the same data input tool with this same Excel file, but each workflow reads its own data sheet?

Excel example.xlsx

apathetichell

Hi -  I think whatever you are trying to do can be accomplished with a batch macro which is called in two distinct workflows. In workflow one the control parameter tells it to find sheets 1-62 and in workflow two the control parameter tells it to use 63-74.