Convert excel to PDF interop in angular

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marvin Reid5y ago
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
0
Piyush Pansuriya6y ago
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
0