Automated conversion of Excel to PDF using LibreOffice

While converting an excel to pdf following operations are done

  • Read existing excel file.
  • Modify cell values of existing excel file.
  • Convert output of worksheet to PDF

Here Node.js, LibreOffice, unoconv are used for automated conversion with Ubuntu operating system.

Following are instructions to install Node.js

  • Run curl -sL https://deb.nodesource.com/setup_10.x | sudo bash -
  • Run sudo apt-get install gcc g++ make
  • Run sudo apt-get install -y nodejs
  • Run node --version
  • Run npm --version

Following are instructions to install LibreOffice

LibreOffice Installation Reference

Run command to add the PPA

  • Run sudo add-apt-repository ppa:libreoffice/ppa
  • Run sudo apt-get update
  • Run sudo apt-get install libreoffice

Following are instructions to install unoconv

Universal Office Converter (unoconv)

  • Run sudo apt-get install -y unoconv
  • Run unoconv --version

Download source code at https://github.com/enishant/excel-to-pdf/

Nishant Vaity

Knowledgeable and skilled Technology Lead with an ability of software development and supervision. Possess a Bachelor of Science (BS) in Information Technology along with 10+ years of experience with hands-on coding and team management. By profession, I am a Software Engineer, Technology Mentor & Entrepreneur. Passionate about the technologies I use and always eager to share & learn more from that passion.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: