topic How to Insert from an excel row/cell level data into a databricks table in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-insert-from-an-excel-row-cell-level-data-into-a/m-p/101819#M40847 Wed, 11 Dec 2024 19:22:09 GMT SureshRajG 2024-12-11T19:22:09Z How to Insert from an excel row/cell level data into a databricks table https://community.databricks.com/t5/data-engineering/how-to-insert-from-an-excel-row-cell-level-data-into-a/m-p/101819#M40847 Wed, 11 Dec 2024 19:22:09 GMT https://community.databricks.com/t5/data-engineering/how-to-insert-from-an-excel-row-cell-level-data-into-a/m-p/101819#M40847 SureshRajG 2024-12-11T19:22:09Z Re: How to Insert from an excel row/cell level data into a databricks table https://community.databricks.com/t5/data-engineering/how-to-insert-from-an-excel-row-cell-level-data-into-a/m-p/101823#M40850 <P>Hi</P><P>You can achieve that with pandas. See the following example code:</P><LI-CODE lang="python">%pip install openpyxl</LI-CODE><LI-CODE lang="python">import pandas as pd file_location_xls = "path/to/excel/1.xlsx" # read the sheet with Name Financials1" into a pandas dataframe pdf = pd.read_excel(file_location_xls, sheet_name="Financials1") # Transform the Pandas Dataframe to a Pyspark Dataframe df = spark.createDataFrame(pdf) # Save Dataframe as Unity Catalog table df.write.saveAsTable("default.bronze.excel_data")</LI-CODE><P>&nbsp;</P> Wed, 11 Dec 2024 19:52:22 GMT https://community.databricks.com/t5/data-engineering/how-to-insert-from-an-excel-row-cell-level-data-into-a/m-p/101823#M40850 Stefan-Koch 2024-12-11T19:52:22Z