https://community.databricks.com/t5/data-engineering/how-to-import-excel-files-xls-xlsx-file-into-databricks-python/m-p/62226#M31926 <P>Method 1: Using <SPAN>"com.crealytics.spark.excel" package, how do I import the package?</SPAN><BR /><BR />Method 2: Using pandas I tried the possible paths, but file not found it shows, nor while uploading the xls/xlsx file it shows options for importing the dataframe.<BR /><BR />Help is appreciated<BR />Thanks</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 28 Feb 2024 13:03:35 GMT srjchoubey2 2024-02-28T13:03:35Z https://community.databricks.com/t5/data-engineering/how-to-import-excel-files-xls-xlsx-file-into-databricks-python/m-p/62226#M31926 <P>Method 1: Using <SPAN>"com.crealytics.spark.excel" package, how do I import the package?</SPAN><BR /><BR />Method 2: Using pandas I tried the possible paths, but file not found it shows, nor while uploading the xls/xlsx file it shows options for importing the dataframe.<BR /><BR />Help is appreciated<BR />Thanks</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 28 Feb 2024 13:03:35 GMT https://community.databricks.com/t5/data-engineering/how-to-import-excel-files-xls-xlsx-file-into-databricks-python/m-p/62226#M31926 srjchoubey2 2024-02-28T13:03:35Z https://community.databricks.com/t5/data-engineering/how-to-import-excel-files-xls-xlsx-file-into-databricks-python/m-p/62252#M31935 <DIV><DIV><SPAN>import</SPAN><SPAN> pandas </SPAN><SPAN>as</SPAN><SPAN> pd</SPAN></DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><SPAN>ExcelData </SPAN><SPAN>=</SPAN><SPAN> pd.</SPAN><SPAN>read_excel</SPAN><SPAN>(</SPAN><SPAN>"/dbfs"</SPAN><SPAN>+</SPAN><SPAN>FilePath, sheetName) #&nbsp; make sure you add /dbfs to FilePath</SPAN></DIV></DIV><DIV>&nbsp;</DIV> Wed, 28 Feb 2024 17:26:23 GMT https://community.databricks.com/t5/data-engineering/how-to-import-excel-files-xls-xlsx-file-into-databricks-python/m-p/62252#M31935 vishwanath_1 2024-02-28T17:26:23Z