CLI Convert .xls and xlsx entire workbook

[psantiago]

Is there a way to convert the entire excel file to pdf via cli.

Currently I am using libreoffice --headless --export-to pdf . Is there a way to export the whole workbook? In excel you can do this with file save as pdf. Within the options section for pdf at the bottom there is a publish what section and you can select entire workbook. Does libreoffice have an equivalent cli version way to do this?

[psantiago]

To fix this all you need to do is to make sure your excel file is saved with print entire workbook setting from the file option. Once libreoffice is ran to convert-to pdf it will convert all the pages within the workbook.