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
unoconvUniversal Office Converter (unoconv)
- Run
sudo apt-get install -y unoconv
- Run
unoconv --version
Download source code at https://github.com/enishant/excel-to-pdf/