Aspose.Cell convert to PDF - Selected Sheets only


#1

Hi Team,

I am using latest v17.10 version of aspose.cells & converting XLSB files to PDF. We have a business requirement to convert only selected Sheet Names from the workbook.

Is there a way that I can use PDFSaveOptions to specify only selected sheets to convert? I know there is a similar option on Page Index & PageCount but this does not solve the business requirement of converting specific sheets.

Any help is much appreciated.

Thanks,


#2

@jammylegg

Thanks for your posting and using Aspose APIs.

This is possible. First you will hide all the worksheets except your selected sheets and then convert your Xlsb to Pdf.

You can hide the worksheet with the following code.

C#

//Hide this worksheet
Worksheet ws = ..;
ws.IsVisible = false;

We have also added a New Feature request to fulfill your needs directly without any workarounds. We will implement it if it is feasible for us. Once, we will have some news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45761 - Save Selected Worksheets to Pdf

#3

@jammylegg

We are afraid, you will have to use the workaround as we have told in the previous post. i.e.