How to Export file as PDF, Excel formats usingmvc5

When you use MVC, you have the full power of .NET framework on the server side. You should be able to get your data and save it into a stream or temp file in any format you want, then use a good library to do the conversion to other formats.
One option is to use LEADTOOLS, since the .NET classes include a powerful document conversion module that can produce Excel, PDF and many other file types. You can find more details here:

https://www.leadtools.com/sdk/document/document-converter

The following code shows how the document converter works:

using (DocumentConverter documentConverter = new DocumentConverter())
{
var inFile = "YourInputFile";
var outFile = "output.pdf";
var format = DocumentFormat.Pdf;
var jobData = DocumentConverterJobs.CreateJobData(inFile, outFile, format);
jobData.JobName = "conversion job";
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);
}
}
}

5 Replies

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

Satyaprakash Samantaray9y ago
https://www.codeproject.com/Articles/1078092/ASP-MVC-Export-download-Grid-contents-in-different
Seshu B9y ago
Hi Satyaprakash
can u forward any links regarding this..
Satyaprakash Samantaray9y ago
follw my blogs

www.c-sharpcorner.com/members/satyaprakash-samantaray
Uehara Ayaka9y ago
Hi try spire.dataExport, it supports to export data from database to popular file format like Pdf, Excel, Word, etc

https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-DataTable-to-PDF.html
Mohamed Abedallah9y ago
When you use MVC, you have the full power of .NET framework on the server side. You should be able to get your data and save it into a stream or temp file in any format you want, then use a good library to do the conversion to other formats.
One option is to use LEADTOOLS, since the .NET classes include a powerful document conversion module that can produce Excel, PDF and many other file types. You can find more details here:
https://www.leadtools.com/sdk/document/document-converter

The following code shows how the document converter works:
using (DocumentConverter documentConverter = new DocumentConverter())
{
   var inFile = "YourInputFile";
   var outFile = "output.pdf";
   var format = DocumentFormat.Pdf;
   var jobData = DocumentConverterJobs.CreateJobData(inFile, outFile, format);
   jobData.JobName = "conversion job";
   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);
      }
   }
}