Output selected sheets to single pdf

[abc_123_abc]

HI,

Can I output selected sheets in workbook to pdf?
or Output each sheet to pdf and merge into one？

Thanks

[Nina.Tang]

Hi,

Thank you for contacting us.
Sorry there is no directly way to convert selected sheets to PDF, you could respectively convert some worksheets to PDFs, and then merge them into one. Please note that this method uses both the functions of Spire.XLS and Spire.PDF. You'd better download our Spire.Office Platinum (DLL Only) Version:4.3.1 and reference the corresponding dlls (Spire.XLS.dll, Spire.Pdf.dll, Spire.Common.dll, Spire.License.dll) into your project. If there is any question, please feel free to write back.
Sample code is given as below.

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile("Book.xlsx");

Stream stream1=new MemoryStream();
Stream stream2 = new MemoryStream();

//The worksheet named sheet1
workbook.Worksheets["sheet1"].SaveToPdfStream(stream1);
//The worksheet named sheet3
workbook.Worksheets["sheet3"].SaveToPdfStream(stream2);

//Merge the saved streams
Stream[] allStream = new Stream[] { stream1, stream2 };
PdfDocumentBase pdf = PdfDocument.MergeFiles(allStream);
pdf.Save("result.pdf");


Sincerely,
Nina
E-iceblue support team

[abc_123_abc]

Hi Nina,

Thanks for reply, it really helps.

[Nina.Tang]

Hi,

Thanks for your feedback.
If there is anything we can do for you in the future, please do not hesitate to contact us.
Wish you a wonderful day!

Sincerely,
Nina
E-iceblue support team