- 406 Views
- 2 replies
- 12 kudos
(Episode 2: Reading Excel Files) - Learning Databricks one brick at a time, using the Free Edition
Episode 2: Reading Excel FilesLearning Databricks one brick at a time, using the Free Edition.You can download the accompanying Notebook and Excel files used in the demonstration over on my GitHub:Excel Files & Notebook: https://github.com/BSanalyst...
- 406 Views
- 2 replies
- 12 kudos
- 12 kudos
@BS_THE_ANALYST that final snippet of code looks very clean! I saw that "sheet name = None" part and was a bit confused why you'd written that as I assumed that was just the default. Turns out the default is "sheet name = 0", which is simply the firs...
- 12 kudos
- 2264 Views
- 3 replies
- 0 kudos
Getting data from Databricks into Excel using Databricks Jobs API
If you have your data in Databricks, but like to analyse it in Excel, you can use Web API on Power Query. It allows you to not just query an existing table, but also trigger the execution of a PySpark notebook using Databricks Jobs API, and get the d...
- 2264 Views
- 3 replies
- 0 kudos
- 0 kudos
Got it, yes you have specified the same in your message. Thanks for sharing.
- 0 kudos