topic Re: Installing LibreOffice on Databricks in Data Engineering

Installing LibreOffice on Databricks

semsim — Wed, 05 Jun 2024 20:12:38 GMT

Hi,

I need to install libreoffice to do a document conversion from .docx to .pdf. The requirement is no use of containers. Any idea on how I should go about this?

Environment: Databricks 13.3 LTS

Thanks,

Sem

Re: Installing LibreOffice on Databricks

Yeshwanth — Thu, 06 Jun 2024 05:10:06 GMT

Hi @semsim Good day!

I just wanted to check if you have tried the following commands already.

%sh sudo apt-get install -y libreoffice sudo apt-get install -y unoconv

Re: Installing LibreOffice on Databricks

semsim — Thu, 06 Jun 2024 13:48:02 GMT

Hi Yeshwanth,

Where would I run these commands? I tried running it in a notebook but it didn't solve the problem.

Thanks,

Sem

Re: Installing LibreOffice on Databricks

semsim — Fri, 07 Jun 2024 16:36:13 GMT

Hi @Yeshwanth ,

I've ran these commands and others at the notebook level. I have also ran the commands as an init script. Neither has worked so far.

Here is what I am seeing when I run the commands:

and here is the error message I receive when I try to run the function that needs libreoffice:

Re: Installing LibreOffice on Databricks

semsim — Fri, 07 Jun 2024 20:47:34 GMT

Hey @Yeshwanth ,

Finally got it installed. Here is what worked for me:

%sh sudo apt update && sudo apt upgrade -y %sh sudo apt install libreoffice-common libreoffice-java-common libreoffice-writer openjdk-8-jre-headless -y

Thanks,

Sem

Re: Installing LibreOffice on Databricks

furkan — Thu, 22 Aug 2024 11:43:07 GMT

Hi @semsim

I'm attempting to install LibreOffice for converting DOCX files to PDF and tried running your shell commands from notebook. However, I encountered the 404 errors shown below. Do you have any suggestions on how to resolve this issue? I really appreciate any help.

Re: Installing LibreOffice on Databricks

alevilla — Thu, 02 Jan 2025 20:41:13 GMT

Hi @furkan ,

I had the same issue.

Fixed it running the following in the notebook:

%sh sudo add-apt-repository ppa:libreoffice/ppa %sh sudo apt update && sudo apt-get -y dist-upgrade %sh sudo apt install libreoffice-common libreoffice-java-common libreoffice-writer openjdk-8-jre-headless libreoffice-calc -y

Hope it helps!