This video shows the way we can get the sheet names from an excel file using azure data bricks notebook. Using python we get the sheet names and send back the names in an array to the data factory pipeline. From pipeline we access the sheet names and loop thru one by one,