Create excel from PDF using .Net

[kcwallace]

Can anyone point me to a solution, or tool for exracting data from a PDF file.

 

The file has not been flattened, meaning I can highlight all of the text and the copy and paste the text to another file. pull out the data and evaluate it.

 

Is this possible?

[OMID SOFT]

Of course it's possible!

I can show you a tool but it's not free, "Component One PDF" is a component for .NET applications so enable them to work with PDF files.

If you use it, the only thing left is creating Excel files.

So you can do something like:

Dim ExcelString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileTextBox.Text + ";Extended Properties=Excel 8.0;"
Dim ExcelConnection As New OleDbConnection(ExcelString)
ExcelConnection.Open()
Dim ExcelCommand As New OleDbCommand()
ExcelCommand.Connection = ExcelConnection
ExcelCommand.CommandText = "CREATE TABLE Sheet1 (TableName Char(255))"
ExcelCommand.ExecuteNonQuery()
...
ExcelConnection.Close()