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

I am Software Engineer, Technology Mentor & Entrepreneur. I am passionate about the technologies I use and always eager to share & learn more from that passion. I am an experienced Software Engineer with 8+ years of experience in coding high-traffic websites. Proficient in HTML, JavaScript, jQuery, CSS with LAMP / MAMP / WAMP Stack. Contributor for WordPress open source plugins and Translator (Marathi) for WordPress 4.5.x.

Leave a Reply

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

%d bloggers like this: