Free Support Forum - aspose.com

Printing all worksheets with Aspose.PDF? Is this possible?

Hi,

I have bought a license of Aspose.Cells and now need to export all worksheets created with Aspose.Cells to a SINGLE .pdf-file ...

I am using the following code, which only exports the last activated sheet within the Excel-workbook:

wb.Save(targetPathPDF, Aspose.Cells.FileFormatType.AsposePdf);

Aspose.Pdf.Pdf pdfCreator = new Aspose.Pdf.Pdf();

pdfCreator.BindXML(targetPathPDF, null);

pdfCreator.Save(targetPathPDF);

When working with native-Excel I always hat to select all worksheets before printing, but I cannot find any options (neither in Aspose.Cells nor in Aspose.PDF) for doing so ...

Thanks in advance for your answer!

Greetings

Stefan

Dear Stefan,

I have moved this post to the Aspose.Cells forum. They will reply to you soon.

Aspose.Cells exports all worksheets into Aspose.Pdf xml. Could you please create a simple console application project to show your problem? I guess that some settings prevent you from converting all worksheets. For example, hidden worksheets won't be converted.

And which version of Aspose.Cells and Aspose.Pdf are you using?

I am using the latest versions of Aspose.Cells and Aspose.PDF ...

Both downloaded last week ...

I have already bought Aspose.Cells but would really like to ensure that this works before buying Apose.PDF too ...

So, I'll create the sample-application!