Converting Pdf to Excel

Sign in to answer this question.

• MB

  Maen Badwan8y agoPosted Nov 29, 2017, 1:19 PM

  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:
  

  1. //////////////////////////////////////////   
  2. private void button1_Click(object sender, EventArgs e)  
  3. {  
  4. using (DocumentConverter documentConverter = new DocumentConverter())  
  5. {  
  6. string OcrAdvantageRuntimeDir = @"c:\LEADTOOLS 19\Bin\Common\OcrAdvantageRuntime";  
  7. documentConverter.Options.EnableSvgConversion = true;  
  8. documentConverter.Options.JobErrorMode = DocumentConverterJobErrorMode.Abort;  
  9.    
  10. using (var ocrEngine = OcrEngineManager.CreateEngine(OcrEngineType.Advantage, false))  
  11. {  
  12.    var rasterCodecs = new RasterCodecs();  
  13.    var documentWriter = new DocumentWriter();  
  14.    
  15.    ocrEngine.Startup(rasterCodecs, documentWriter, null, OcrAdvantageRuntimeDir);  
  16.    documentConverter.SetOcrEngineInstance(ocrEngine, true);  
  17.    documentConverter.Diagnostics.EnableTrace = true;  
  18.    
  19.    var inFile = @"C:\Files\Input.pdf";  
  20.    var outFile = @" C:\Files\Output.xls";  
  21.    
  22.    var format = DocumentFormat.Xls;  
  23.    var jobData = DocumentConverterJobs.CreateJobData(inFile, outFile, format);  
  24.    jobData.JobName = "conversion job";  
  25.    
  26.    var job = documentConverter.Jobs.CreateJob(jobData);  
  27.    documentConverter.Jobs.RunJob(job);  
  28.    
  29.    if (job.Status == DocumentConverterJobStatus.Success)  
  30.    {  
  31.       Console.WriteLine("Success");  
  32.    }  
  33.    else  
  34.    {  
  35.       Console.WriteLine("{0} Errors", job.Status);  
  36.    
  37.       foreach (var error in job.Errors)  
  38.       {  
  39.          Console.WriteLine("  {0} at {1}: {2}", error.Operation, error.InputDocumentPageNumber, error.Error.Message);  
  40.       }  
  41.    }  
  42. }  
  43. }  
  44. }  
  45. ////////////////////////////////////////// 
      
• SB

  Sujay Bhat8y agoPosted Nov 28, 2017, 3:53 AM

  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 Swain8y agoPosted Nov 28, 2017, 2:35 AM

  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 
• SB

  Sujay Bhat8y agoPosted Nov 28, 2017, 2:27 AM

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

  Rajkiran Swain8y agoPosted Nov 28, 2017, 2:15 AM

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