90. Databricks | Pyspark | Interview Question: Read Excel File with Multiple Sheets

Azure Databricks Learning: Interview Question: Read Excel File with Multiple Sheets
================================================================================

How to create dataframe reading multiple excel sheets ?

Though creating dataframe by reading excel sheets is not very common, still there are certain scenarios where we need to read excel data. Reading data from all excel sheets is bit challenging as there is no direct solution. I have created an automated solution in this video for that requirement

To get through understanding of this concept, please watch this video

#DatabricksExcel, #SparkExcelReading, #PysparkReadingMultipleExcelSheets,#PysparkTips, #DatabricksRealtime, #SparkRealTime, #DatabricksInterviewQuestion, #DatabricksInterview, #SparkInterviewQuestion, #SparkInterview, #PysparkInterviewQuestion, #PysparkInterview, #BigdataInterviewQuestion, #BigdataInterviewQuestion, #BigDataInterview, #PysparkPerformanceTuning, #PysparkPerformanceOptimization, #PysparkPerformance, #PysparkOptimization, #PysparkTuning, #DatabricksTutorial, #AzureDatabricks, #Databricks, #Pyspark, #Spark, #AzureDatabricks, #AzureADF, #Databricks, #LearnPyspark, #LearnDataBRicks, #DataBricksTutorial, #azuredatabricks, #notebook, #Databricksforbeginners

[oiwelder]

I had a similar case, but it was several positional cells. With your function I managed to reduce 12 dataframes to just 1. Thank you for sharing this precious knowledge.

[KG-rwsr]

please post the code for UDF to create DF from Multiple sheets and Perform Union in the description like in other previous videos! thanks again for amazing tutorials. You are amazing!

[venkatasai]

Good scenario based question …please bring more like this Raja ...

[ashokkumar-wmyr]

This question was asked in Winwire azure dataengineer L1 discussion.

[stoyyeti]

Waiting for your videos on delta live tables, workflows, jobs, pipelines, spark structured streaming in databricks

[PradyutJoshi]

Great example but your microphone is having interference. Please resolve that.
Thanks!

[LearnShare]

How to install the excel Library at notebook level instead of cluster level. Could you pls share the steps?

[rushikeshsuryawanshi]

Please create a video for xml read and streaming also

[sravankumar]

Hi Raja I have one doubt in my current project. They have given complex logic mapping document. They given multiple joins in that document. Could you please help me . They said need to finish in Monday. Please help me. How shd I contact you

[AmarMahadik-fs]

How to do when sheets names are space separated.
I am getting error while reading Excel file having space separated sheet name

[suryateja]

How to do when Sheet names have spaces like Sheet Name, by giving dataAddress="Sheet Name!" Throwing an error

[abdat]

But how to list the Excel sheets using spark ...not using python

Because of u are reading from adls.. u will need spark only not python

[chakhil]

Sir, I am getting this error please help i installed library as you mentioned, after executing the code to read excel file, getting this error Could not initialize class