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 [https://app.tdcx.com/email-signature/assets/img/tdcx-logo.png] m. +639055716384 w. www.tdcx.com<http://www.tdcx.com/> Winner of over 350 Industry Awards [Linkedin]<https://www.linkedin.com/company/tdcxgroup/> [Facebook] <https://www.facebook.com/tdcxgroup/> [Twitter] <https://twitter.com/tdcxgroup/> [Youtube] <https://www.youtube.com/c/TDCXgroup> [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.
