Convert excel to Pdf

[Tom360]

Hi i am trying to create a PDFdocument from a memory stream, however when converting the fpd only contains half the data and is missing the graphs?

please see below the code being used

Thanks.

*****

var pdfConverter = new PdfConverter(excelStream);
var pdfDocument = new Spire.Pdf.PdfDocument();

pdfDocument = pdfConverter.Convert();
pdfDocument.SaveToFile(@"C:\Temp\EnergyAlarms\Converted.pdf");
pdfDocument.Close();

[amy.zhao]

Hi,

Thanks for your posting.
Please try this solution.
http://www.e-iceblue.com/Tutorials/Spir ... o-PDF.html

If the issue still exists, please share your excel fle for investigation. You can also send your excel file to support@e-iceblue.com if it is inconvenience to share here.

Best Regards,
Amy
E-iceblue support team

[Tom360]

Thank you very much this works! Is there any options to only include certain worksheets, and how to set the page margins. As seen by the attatched file when converted the data is only using half the document width,

[amy.zhao]

Hi,

Please attach your excel file.
Thank you.

Best Regards,
Amy
E-iceblue support team

[Tom360]

Hi,

Please find the attached file i am using.

[amy.zhao]

Hi,

The print area of your excel file itself is B5:M150 so it should be the result you converted, and it also has the same result using Excel to do the conversion. Please refer to the following tutorial to set pdf margins.
http://www.e-iceblue.com/Tutorials/Spir ... B.NET.html
You can use the below solution to convert certain sheet to PDF.

Code: Select all

 Workbook book = new Workbook();
            book.LoadFromFile(input);
         
            book.Worksheets[0].SaveToPdf("1.pdf");

Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hi,

Has your issue been resolved?
Thank you for your feedback in advance.

Best Regards,
Amy
E-iceblue support team

[Tom360]

Hi,

Thank you very much, yes this issue has been fixed.

Thank you.

[amy.zhao]

Hi,

Glad to hear that.
Welcome to write to us again if you need further assistance.

Best Regards,
Amy
E-iceblue support team