This is pandas API on spark from pyspark import pandas as ps df = ps.read_excel("testexcel.xlsx") [image: image.png] this will convert it to pyspark [image: image.png]
tir. 20. juni 2023 kl. 13:42 skrev John Paul Jayme <john.ja...@tdcx.com.invalid>: > Good day, > > > > I have a task to read excel files in databricks but I cannot seem to > proceed. I am referencing the API documents - read_excel > <https://spark.apache.org/docs/latest/api/python/reference/pyspark.pandas/api/pyspark.pandas.read_excel.html> > , but there is an error sparksession object has no attribute > 'read_excel'. Can you advise? > > > > *JOHN PAUL JAYME* > Data Engineer > > m. +639055716384 w. www.tdcx.com > > > > *Winner of over 350 Industry Awards* > > [image: Linkedin] <https://www.linkedin.com/company/tdcxgroup/> [image: > Facebook] <https://www.facebook.com/tdcxgroup/> [image: Twitter] > <https://twitter.com/tdcxgroup/> [image: Youtube] > <https://www.youtube.com/c/TDCXgroup> [image: Instagram] > <https://www.instagram.com/tdcxgroup/> > > > > This is a confidential email that may be privileged or legally protected. > You are not authorized to copy or disclose the contents of this email. If > you are not the intended addressee, please inform the sender and delete > this email. > > > > > -- Bjørn Jørgensen Vestre Aspehaug 4, 6010 Ålesund Norge +47 480 94 297