Converting Pdf to Excel

Question

Is there any way to convert a PDF document to Excel with all the data in the same manner as that in PDF without using any API or 3rd Party software in Java. Would appreciate if I could get any alternate solution for this problem. Thanks in advance.

Maen Badwan · Answer

To my knowledge, the PDF and Excel formats are not natively supported by Java. You can try using open source SDKs under Java similar to iText, but I am not sure if they have the ability to save PDF to Excel. Alternatively, you could try using the document conversion features from LEADTOOLS under Java. They provide the ability to read/write different document formats including PDF and Excel. More details can be found here: https://www.leadtools.com/help/leadtools/v19/dh/doxc/documentconverter.html The following code shows how you can convert from multi-page PDF to Excel using the DocumentConverter class from LEADTOOLS: ////////////////////////////////////////// private void button1_Click( object sender, EventArgs e) { using (DocumentConverter documentConverter = new DocumentConverter()) { string OcrAdvantageRuntimeDir = @ "c:\LEADTOOLS 19\Bin\Common\OcrAdvantageRuntime" ; documentConverter.Options.EnableSvgConversion = true ; documentConverter.Options.JobErrorMode = DocumentConverterJobErrorMode.Abort; using (var ocrEngine = OcrEngineManager.CreateEngine(OcrEngineType.Advantage, false )) { var rasterCodecs = new RasterCodecs(); var documentWriter = new DocumentWriter(); ocrEngine.Startup(rasterCodecs, documentWriter, null , OcrAdvantageRuntimeDir); documentConverter.SetOcrEngineInstance(ocrEngine, true ); documentConverter.Diagnostics.EnableTrace = true ; var inFile = @ "C:\Files\Input.pdf" ; var outFile = @ " C:\Files\Output.xls" ; var format = DocumentFormat.Xls; 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); } } } } } //////////////////////////////////////////

Sujay Bhat · Answer

That you for sharing the links. But as I went through the links I found that most of them use 3rd party API's. But I have been asked in my company not use any 3rd party API's and need to extract data from PDF to Excel.

Rajkiran Swain · Answer

http://www.c-sharpcorner.com/forums/how-to-convert-pdf-to-excel-in-asp-net http://www.dotnetfunda.com/forums/show/16202/convert-pdf-to-excel-using-csharp-in-aspnet

Sujay Bhat · Answer

Thank you for your reply. But what I actually needed was the reverse of that. Need to convert PDF to Excel.

Rajkiran Swain · Answer

http://www.c-sharpcorner.com/uploadfile/d2dcfc/methods-for-converting-office-documents-to-pdf-or-xps-with-C-Sharp/

Converting Pdf to Excel

Answers (5)