Dynamically parse the excel without having sheet index or sheet name

Looks like you are facing a transformation issue. Normal snaps can do the job.

Assume your input data is flat like what’s in following picture.

They would looks like this in a snap preview:

[
  {
    "S": "1",
    "STATUSDESCRIPTION": "Testing 1.",
    "P": "urgent"
  },
  {
    "S": "2",
    "STATUSDESCRIPTION": "Testing 2.",
    "P": "normal"
  }
]

A pipeline like this will produce the expected output:

The Group By N snap can group individual input records into an array.

The Mapper snap should looks like this: