• Databricks Community
  • Data Engineering
  • Re: how to add the background color to excel sheet...

Hubert-Dudek
Hubert-Dudek
Databricks MVP
Options
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Report Inappropriate Content

‎01-17-2023 04:00 AM

  • Convert your dataframe to pandas on spark
  • color cells using style property https://spark.apache.org/docs/latest/api/python/reference/pyspark.pandas/api/pyspark.pandas.DataFram...
  • export to excel using pandas to_excel https://spark.apache.org/docs/latest/api/python/reference/pyspark.pandas/api/pyspark.pandas.DataFram...

My blog: https://databrickster.medium.com/

View solution in original post

0 Kudos
Reply
Powered by Khoros