search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.91k stars 1.1k forks source link

How to Export a Specific Worksheet to PDF in OnlyOffice DocSpace? #2943

Open baissm opened 1 month ago

baissm commented 1 month ago

I am currently using OnlyOffice DocSpace for converting Excel files (xlsx) to PDF.

I understand that hiding unnecessary worksheets could help in removing them from the final PDF. However, in some cases, I need to generate separate PDFs from different worksheets within the same Excel file.

Is there a way to export only a specific worksheet during the conversion process? If not, could you recommend any possible workarounds for achieving this, either within OnlyOffice or using external tools?

LuckySpecialist commented 4 weeks ago

Hi @baissm! You can do this using menu File > Print, and in the settings of which specify Print range > Active sheet and then specify the Destination > Save to PDF.

baissm commented 4 weeks ago

Hi @baissm! You can do this using menu File > Print, and in the settings of which specify Print range > Active sheet and then specify the Destination > Save to PDF.

Thanks for your response @LuckySpecialist Uh... I want to call API in Java program to convert Excel to PDF I saw this function in the interface, I don’t know if there is an API that provides this function. The API currently used are https://api.onlyoffice.com/editors/conversionapi