topic Re: Powerpoint file operations in Databricks in Data Engineering

Powerpoint file operations in Databricks

AJ270990 — Mon, 28 Mar 2022 12:12:45 GMT

Hi Team, I am writing a python code in Azure Databricks where I have mounted a Azure storage and accessing the input dataset from Azure storage resource. I am accessing the input data from Azure storage and generating charts from that data in databricks workbook. All the input files are on AZ storage. I have placed the generated charts into powerpoint but unable to save that updated powerpoint file back to Azure storage. I have tried using the object of Presentation() and tried saving the file using .sav(), but it saves in local workspace of databricks and not on mounted storage. Please help

Re: Powerpoint file operations in Databricks

-werners- — Mon, 28 Mar 2022 12:26:56 GMT

can you share the code where you do the actual write?

The fact that you save a powerpoint makes me think you do not use the Spark environment, but plain python.

Re: Powerpoint file operations in Databricks

AJ270990 — Mon, 28 Mar 2022 12:31:40 GMT

******************************************************
 
from pptx import Presentation
 
from pptx.util import Inches, Pt 
 
 
 
prs = Presentation('/dbfs/mnt/powerpoint-templates/MAPresentation.pptx')
 
#First slide - Index 0
 
slide = prs.slides.add_slide(prs.slide_layouts[0])
 
 
 
# Add a picture to the given dimensions
 
slide.placeholders[14].insert_picture('/dbfs/mnt/powerpoint-templates/page_type_transaction_barplot.png')
 
 
 
prs.save("/dbfs/mnt/powerpoint-templates/MA_presentation_New.pptx")

Re: Powerpoint file operations in Databricks

AJ270990 — Mon, 28 Mar 2022 12:33:06 GMT

Yes I am using python environment and not spark.

These operations are of python.

The last line.. prs.save() is giving an error.

When I do normal prs.save(file name) without the path it works and save the file in current workspace. But that is of no use. I want the file to be saved on Blob storage

Re: Powerpoint file operations in Databricks

-werners- — Mon, 28 Mar 2022 12:42:30 GMT

can you check this?

https://stackoverflow.com/questions/62953148/saving-file-into-azure-blob

Re: Powerpoint file operations in Databricks

AJ270990 — Mon, 28 Mar 2022 12:53:22 GMT

Ok I am checking. Quick check, what should be in place of str ?

connect_str = os.getenv('str')

Re: Powerpoint file operations in Databricks

-werners- — Mon, 28 Mar 2022 12:56:53 GMT

os.getenv()

method in Python returns the value of the environment variable key if it exists otherwise returns the default value

Re: Powerpoint file operations in Databricks

AJ270990 — Mon, 28 Mar 2022 13:23:23 GMT

Wow it works.. Thank you so so much!! Really appreciate your quick help!

Re: Powerpoint file operations in Databricks

Anonymous — Thu, 14 Apr 2022 13:26:51 GMT

Hi @Abhishek Jain

Thanks for sending in your query. We are glad that you found a solution. Would you like to mark the answer as best so the other members can benefit from it too?

Cheers!