export excel to pdf without save

[abraham]

Hi,

 

I need help to export the excel file into pdf wihout save.

 

I tried the sample code,

 

Dim converter As New ExcelToPdfConverter(strAppPathUpdate)
Dim pdfDoc As New PdfDocument
Dim settings As New ExcelToPdfConverterSettings()
settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage
settings.TemplateDocument = pdfDoc
            settings.DisplayGridLines = GridLinesDisplayStyle.Invisible
pdfDoc = converter.Convert(settings)
pdfDoc.Save(path)

instead of save, is any code to show the pdf in the viewer.

because, if the user clicks the generate button second time (wihout closing the first time generated pdf file),

system throws exception.

Thanks & Regards

Abraham. P

 

[Kanimozhi Bharathi]

Hi Abraham, 

We have prepared a sample based on your requirement of viewing the exported PDF files. Please find the sample link for your reference, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS1388326046 

Note: The exception occurs because the saved PDF file is still in open mode. 

Regards 

Kanimozhi B 

[abraham]

Hi,

 

Thanks for your reply,

 

I already tried with the same code, which you have given in the link below. same code I have used in my application.

my request is, if the user open the converted pdf file and not closed, agin if the user click the export button,

how to avoid this exception.

 

Is there any alternate method to export pdf wihout save??

 

In my previous query too, I have mentioned the same, that I have got this exception and is there any menthod.

 

Thanks & Regards,

Abraham. P

[Kanimozhi Bharathi]

Hi Abraham, 

 

We have checked with your issue and you can overcome this issue by generating the PDF through PdfViewer by saving the pdf as stream and viewing it. We have prepared the sample based on your requirement . Please find the link below 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS799551927 

 

Regards 

Kanimozhi B 

[abraham]

Hi,

 

Thank you for your response. I checked your sample application, but I was not able to run, because I'm using VS2010 and .net framework 3.5, and the Syncfusion version 11.104.0.21(Syncfusion.XlsIO.Wpf).

 

I tried with the syncfusion dashbord (essential studio 2013 volume1. )

WPF - Import and Export (Excel to PDF)

This sample illustrates Essential XlsIO's and Essential PDF's support for conversion from MS Excel document to PDF document.

I'm using the same code in my application, instead of saving the pdf file need to change the logic to generating the PDF through PdfViewer by saving the pdf as stream and viewing.

Is there any sample which supports VS2010 and 3.5 .net framework

Thanks,

Abraham. P

 

 

 

 

 

 

 

[Kanimozhi Bharathi]

  

Hi Abraham,  

  

We have prepared the sample based on your requirement in  VS2010 and 3.5 .net framework. Please find the link below  

  

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/2010-1293072377 

 

Also we request you to upgrade with our Essential Studio Volume 3 SP 1, 2016 (Version 14.3.0.52)  which has been rolled out and is available for download under the following link. 

 

https://www.syncfusion.com/forums/127126/essential-studio-2016-volume-3-service-pack-release-v14-3-0-52-available-for-download 

                                              

Regards  

Kanimozhi B  

[abraham]

Hi,

 

Thanks for your response, I tried with your sample code, but it throws an exception

 

Error 1 'Syncfusion.Windows.PdfViewer.PdfViewerControl' does not contain a definition for 'Print' and no extension method 'Print' accepting a first argument of type 'Syncfusion.Windows.PdfViewer.PdfViewerControl' could be found (are you missing a using directive or an assembly reference?)

I'm using VS2010 with .NETFramework v4.0

 

I have change the application to target framework v4.0, but the application is not build.

 

Thanks & Regards,

Abraham. P

 

[Kanimozhi Bharathi]

Hi Abraham, 

Can you please upgrade from your current version(11.1) to higher version(14.3) for using the “DirectPrint” feature in PdfViewerControl. 

 

Regards 

Kanimozhi B

[abraham]

Hi,

 

Thanks for the reply, please confirm whether pdfviewer control will work our installed version or not.

There is one sample in the Essential Studio 2013 Vol 1 WPF (Syncfusion Essential Pdf Viewer) application.

 

Thanks & Regards,

Abraham. P

[Thirumurugan Loganathan]

Hi Abraham, 

I have checked your query and found that PDFViewerControl does not have “DirectPrint” support in the your Syncfusion version (11.1). However the document can be printed using the PrintDocument API of the PdfViewerControl with DocumentPaginator. Please find the below given sample for more clarification. 

Sample link: http://www.syncfusion.com/downloads/support/forum/126996/ze/PdfViewerPrintSample1206538312  

 

Regards, 

Thirumurugan