Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Apr 01, 2015 4:16 pm

If I have a workbook with 4 worksheet and 3 of the 4 sheets are used to calculate the values in worksheet1, how can I export to PDF only worksheet1 and have all of the values calculated correctly when exported. It appears that by default the SaveToFile(path, FileFormat.PDF) exports all sheets in the workbook and some of that information we want to hide from the end users and only show the worksheet1

almarciulionis
 
Posts: 5
Joined: Wed Mar 25, 2015 2:34 pm

Thu Apr 02, 2015 2:44 am

Hello,

Thanks for your inquiry.
Please refer to the code below:
Code: Select all
workbook.CalculateAllValue();
sheet1.SaveToPdf("result1.pdf", FileFormat.PDF);


Best Regards,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Fri Apr 03, 2015 6:45 am

Hello,

Has your question been resolved?
Thanks for your feedback.

Sincerely,
Sweety
E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS