Every ByteScout tool contains example VB.NET source codes that you can find here or in the folder with installed ByteScout product. Want to convert protected PDF document to XLS in your VB.NET app? ByteScout PDF Extractor SDK is designed for it. ByteScout PDF Extractor SDK is the Software Development Kit (SDK) that is designed to help developers with data extraction from unstructured documents like pdf, tiff, scans, images, scanned and electronic forms. The library is powered by OCR, computer vision and AI to provide unique functionality like table detection, automatic table structure extraction, data restoration, data restructuring and reconstruction. Supports PDF, TIFF, PNG, JPG images as input and can output CSV, XML, JSON formatted data. Includes full set of utilities like pdf splitter, pdf merger, searchable pdf maker.
This code snippet below for ByteScout PDF Extractor SDK works best when you need to quickly convert protected PDF document to XLS in your VB.NET application. Follow the instructions from the scratch to work and copy the VB.NET code. Detailed tutorials and documentation are available along with installed ByteScout PDF Extractor SDK if you’d like to dive deeper into the topic and the details of the API.
Trial version of ByteScout PDF Extractor SDK is available for free. Source code samples are included to help you with your VB.NET app.
Imports System.IO Imports Bytescout.PDFExtractor Imports System.Diagnostics Class Program Friend Shared Sub Main(args As String()) ' Create Bytescout.PDFExtractor.XLSExtractor instance Dim extractor As New XLSExtractor() extractor.RegistrationName = "demo" extractor.RegistrationKey = "demo" File.Delete("output.xls") ''' Document Password Can be set in two ways ''' 1. Using Property ''' 2. Using Events ' 1. Handle document password using Property ' extractor.Password = "password" ' 2. Handle document password using Event AddHandler extractor.PasswordRequired, New System.EventHandler(AddressOf extractor_PasswordRequired) ' Load sample PDF document extractor.LoadDocumentFromFile("encrypted (password is 'password').pdf") ' Uncomment this line if you need all pages converted into a single worksheet: 'extractor.PageToWorksheet = False ' Set the output format to XLS extractor.OutputFormat = SpreadseetOutputFormat.XLS ' Save the spreadsheet to file extractor.SaveToXLSFile("output.xls") ' Cleanup extractor.Dispose() ' Open result file in default associated application (for demo purposes) Process.Start("output.xls") End Sub Private Shared Sub extractor_PasswordRequired(sender As Object, e As EventArgs) ' Ask user for password and put it to `Password` property. CType(sender, XLSExtractor).Password = "password" End Sub End Class