Convert excel to PDF interop in angular

Question

Hi all, Anyone pls tell me how to convert excel file to PDF using microsoft interop

Piyush Pansuriya · Answer

Hello, Please go through the below link: https://www.c-sharpcorner.com/article/export-to-excel-and-pdf-in-kendo-grid-for-angular-2/ https://sites.google.com/site/dineshkumarwin/convert-ms-office-to-pdf/how-to-convert-excel-to-pdf http://csharphelper.com/blog/2017/12/save-excel-data-in-a-pdf-file-in-c/ https://medium.com/better-programming/convert-excel-files-into-pdf-in-c-net-5566f170a70e https://www.print-driver.it/sdk/examples/csharp/ExcelToPDF.html https://www.dotnetperls.com/excel

Marvin Reid · Answer

If you do not want to deal with having to use the interop, you can take care of this through the use of the DocumentConverter class provided in the LEADTOOLS SDK. You could handle the conversion of this through the use of a service in .NET which will improve on speed. You can try building on the following code: using (DocumentConverter documentConverter = new DocumentConverter()) { var inFile = Path.Combine(ImagesPath.Path, @ "input.xlsx" ); var outFile = Path.Combine(ImagesPath.Path, @ "output.pdf" ); var format = DocumentFormat.Pdf; var jobData = DocumentConverterJobs.CreateJobData(inFile, outFile, format); jobData.JobName = "conversion job" ; var documentWriter = new DocumentWriter(); documentConverter.SetDocumentWriterInstance(documentWriter); var renderingEngine = new AnnWinFormsRenderingEngine(); documentConverter.SetAnnRenderingEngineInstance(renderingEngine); var job = documentConverter.Jobs.CreateJob(jobData); documentConverter.Jobs.RunJob(job); if (job.Status == DocumentConverterJobStatus.Success) { Console.WriteLine( "Success" ); } else { Console.WriteLine( "{0} Errors" , job.Status); foreach (var error in job.Errors) { Console.WriteLine( " {0} at {1}: {2}" , error.Operation, error.InputDocumentPageNumber, error.Error.Message); } } } https://www.leadtools.com/help/sdk/v21/dh/doxc/documentconverter.html https://www.leadtools.com/help/sdk/v21/tutorials/documents/cross-platform/dotnet-core/configure-and-run-the-document-service.html