I am batch converting lot of xlsx files to pdf from command line.
How to export xlsx file with multiple sheets with some sheets hidden to pdf from command line?
What should be the parameters that needs to be set.
Please help.
Welcome!
Should this be exported too or should it be skipped?
How many sheets per PDF document to get? Is it some kind of letter on one sheet or a multi-page report?
Why XLSX?
Which of these have you already tried?
Hidden sheets should not be exported.
all the sheets in the files except the hidden one.
Have gone through libreoffice help doc, but no suggestion about how to skip hidden sheets when exporting to pdf.
have to use XLSX due to to compulsion.
Using arch linux os
Please someone reply.
I tried the following and was able to generate pdf with hidden sheet excluded
- clear the print area of the sheet that is to be hidden, i.e. make it none
- hide the sheet
- save the file
then convert it through command line to pdf , the hidden sheet is skipped. Both step 1 & step 2 are needed.
Is there any other way?