How to convert excel file to OCR formatted pdf file in c#?

Question

Hello Everyone, Can anyone help me to convert the excel file to OCR formatted pdf file? Please help me with this issue, with any code or free library I can use in my project. Thank You.

Amit Mohanty · Answer

Use below command to install free Spire.XLS version through Package Manager Console. Install-Package FreeSpire.XLS -Version 12.7.0 Now use belod code to convert excel to pdf. Workbook workbook = new Workbook(); workbook.LoadFromFile( "Sample.xlsx" , ExcelVersion.Version2010); //Save the document in PDF format workbook.SaveToFile( "result.pdf" , Spire.Xls.FileFormat.PDF);

Marvin Reid · Answer

As Vishal suggested the DocumentConverter will provide the PDF output you are looking for. This approach supports other file formats, and is also thread-safe. It is also not limited to only 1 type of PDF file output which is a limitation seen in many other avenues. Here is a tutorial link: https://www.leadtools.com/help/sdk/v22/tutorials/dotnet-console-convert-files-with-the-document-converter.html

Sam Hobbs · Answer

OCR is Optical Character Recognition, it is not a format.

Vishal Yelve · Answer

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 = "XLSX conversion to PDF" ; var documentWriter = new DocumentWriter(); documentConverter.SetDocumentWriterInstance(documentWriter); // Handles any annotations or comments in the input spreadsheet 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); } }

Deepak M · Answer

@Leon D, @Amit Mohanty free Spire.XLS has some limitations, like it converted only 5 pages or 200 rows only and also the converted pdf file is not an OCR compatible file.

Leon D · Answer

You can install Free Spire.Office library via NuGet (https://www.nuget.org/packages/FreeSpire.Office/), then use it to convert Excel to PDF. https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Conversion/NET-Excel-New-method-of-Convert-Excel-to-PDF.html If you want to convert Excel to scanned PDF, you can first use it to convert excel to images, and next convert the result images to PDF. https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Convert-Excel-to-Image-Worksheet-to-Image-in-C-VB.NET.html https://www.e-iceblue.com/Tutorials/Spire.PDF/Spire.PDF-Program-Guide/C-/VB.NET-Convert-Image-to-PDF.html

Naresh Beniwal · Answer

https://stackoverflow.com/questions/30477556/how-to-convert-pdf-file-to-excel-in-c-sharp