title: how to import Excel file in Databricks pyspark
body: <p>I am trying to import my excel file to PySpark in Azure-DataBricks machine, which I have to move to PySpark Dataframe. I am not able to perform this action. Getting error </p>
  
  <pre><code>import pandas
  data = pandas.read_excel('/dbfs/FileStore/tables/Time_Payments.xlsx')
  df_data = sqlContext.createDataFrame(data)
  </code></pre>
  
  <p>While performing above action, getting below error.     </p>
  
  <pre><code>Error : field Additional Information: Can not merge type &lt;class 'pyspark.sql.types.DoubleType'&gt; and &lt;class 'pyspark.sql.types.StringType'&gt; 
  </code></pre>
  
  <p>Need your assistance here.</p>