How to Export file as PDF, Excel formats usingmvc5

Question

if i select column names in listbox based on names get the data from db and this data will export as Pdf, Excel formats. please give me soultion regarding this

Satyaprakash Samantaray · Answer

https://www.codeproject.com/Articles/1078092/ASP-MVC-Export-download-Grid-contents-in-different

Seshu B · Answer

Hi Satyaprakash can u forward any links regarding this..

Satyaprakash Samantaray · Answer

follw my blogs www.c-sharpcorner.com/members/satyaprakash-samantaray

Uehara Ayaka · Answer

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 Abedallah · Answer

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); } } }

How to Export file as PDF, Excel formats usingmvc5

Answers (5)