Create excel from PDF using .Net

K

kcwallace

Centurion
Joined
May 27, 2004
Messages
175
Location
Austin, TX
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?
 
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:
Visual Basic: 
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()
 
Back
Top