It's simple to do using Open Office software – it have this operation in the main menu File.
And how about to use it on the webserver? – Very simple.
Requirements:
ToDo:
Install XWindows – 'yum groupinstall “X Window System”'
Install VNC-Server
Run VNC-Server (geometry 800×600)
Connect to it from your home computer using VNC-client
Install Firefox – 'yum install firefox'
Using Firefox – take & install latest OpenOffice
Open Calc – and change its settings into 'Print all sheets'
Install ghostscript – 'yum install gs'
Make the new virtual printer using VNC – 'PDFconverter'
Take & install 'pdftk' – probably it'll help you to modify PDFs
Well. Now you can upload & create a XLS file, then convert it into PDF using command:
soffice -norestore -nofirststartwizard -nologo -headless -pt \”PDFconverter\” $fname &
What's it mean?
'soffice' – is the OpenOffice software
'norestore' – it'll not ask user about to restore any documents before open the editor
'nofirststartwizard' – no 'Master' window on starting
'nologo' – no logotype
'headless' – not show any window for user (our user is robot)
'pt' – print the file $fname onto the printer 'PDFconverter'
'&' – run the program in the background mode
That's all for now.
