Spark with Databricks | Read and Write Excel in Spark | With Demo | LearntoSpark

[@DilliPH]

how did you tackle, date columns and float value columns

[@ITworld1987]

not able to find this package in maven central

[@venkateshgurram7707]

Nice Explanation Bro👍👍👍. Keep going

[@giancarlosql2005]

Hi Azarudeen! thanks for the video, Do you know a way to read XLSB files in Databricks pyspark? I tried Pandas, but as you mentioned in the beginning of the video, it requires a local path and it doesn't recognize my datalake path, Do you know if it is possible to achieve?

[@sravankumar1767]

How can we read multiple excel sheets using pyspark can you please explain

[@AzarudeenShahul]

😊 sure bro

[@nandhinimiryala5531]

Is there any way that we can convert csv file to excel by using spark Scala??

[@parthsunknown2102]

exactly what im looking for. Can you share how to install this maven library in a job cluster through yml file?

[@AmarMahadik-f5s]

How to read excel sheet if sheet name is space separated

[@pavanp7242]

Nice explanation

[@sampathch1117]

Hi..how read xlsb and xlsm files in azure data factory or databricks ,we upload xlsb file into adf but it cant read the file...please send solutions

[@jebarajantony6574]

Hello Bro,how to read multiple sheets ?

[@Jetcodelab]

did you find solution for this?

[@dhivakarsathya4779]

What happens when we have to read multiple Excel files inside a folder with a GLOB Pattern like /*.xlsx. actually it's not working like CSV. Any alternatives if u could find could you please let me know

[@deepikamasuti1653]

Yes, even after trying multiple ways unable to read multiple sheets through Eclipse using Scala, if you have any idea please help me out..

[@sangramrajpujari3829]

Same step we have to follow for pyspark?, thanks for the usefull video.

[@AzarudeenShahul]

Hope u tried this :) . The demo is already shown in PySpark and in databricks cluster. For On-prem cluster, its bit different, which i will cover in upcoming videos. Thanks for your support :)

[@sanjeev5149]

How to add this library in pycharm

[@AzarudeenShahul]

Hope u tried this :) . The demo is shown in PySpark and in databricks cluster. For On-prem cluster, its bit different, which i will cover in upcoming videos. Thanks for your support :)

[@sunilkushwaha4218]

How to add a sheet in existing excel file

[@hetadesai7938]

how to read excel file from sftp location ?

[@bhanubrahmadesam4508]

how this works in pyspark?

[@AzarudeenShahul]

Hope u tried this :) . The demo is already shown in PySpark along with databricks cluster. For On-prem cluster, its bit different, which i will cover in upcoming videos. Thanks for your support :)

[@bhanubrahmadesam4508]

@@AzarudeenShahul thanks for reply., it works with databricks. I also tried the same on Scala. Works too. But trying to understand if it’s doable on pyspark using intelliji or jupyter. I’m not sure how to install spark-excel package in python as we won’t have build.sbt

[@tanushreenagar3116]

Thank you

[@shivag1053]

can you give the excel link file to download?

[@AzarudeenShahul]

Feel free to use any excel-file to try this.

[@dataenthusiast6721]

This is pySpark not literally Spark (scala)