Converting Pdf to Excel

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

5 Replies

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

Maen Badwan8y ago
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);
      }
   }
}
}
}
//////////////////////////////////////////
0
Sujay Bhat8y ago
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.
0
Rajkiran Swain8y ago
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
0
Sujay Bhat8y ago
Thank you for your reply. But what I actually needed was the reverse of that. Need to convert PDF to Excel.
0
Rajkiran Swain8y ago
http://www.c-sharpcorner.com/uploadfile/d2dcfc/methods-for-converting-office-documents-to-pdf-or-xps-with-C-Sharp/
0