Pyspark Real-time interview questions - Read Multiple Excel sheets at once Using DataBricks Notebook

Pyspark Real-time interview questions - Read Multiple Excel sheets at once Using Data Bricks Notebook

[sravankumar]

We have excel file in that multiple sheets but while reading the excel sheet we have to skip rows and read the data how can we handle this scenario can you please explain

[alungilesukwana]

But you hardcoded the sheets, it doesn’t cater for a scenario where you don’t know the number of sheets