Every ByteScout tool includes simple example VBScript source codes that you can get here or in the folder with installed ByteScout product. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can convert pdf to xls with pdf extractor sdk in VBScript.
Want to quickly learn? This fast application programming interfaces of ByteScout Data Extraction Suite for VBScript plus the guidelines and the code below will help you quickly learn how to convert pdf to xls with pdf extractor sdk. IF you want to implement the functionality, just copy and paste this code for VBScript below into your code editor with your app, compile and run your application. Applying VBScript application mostly includes various stages of the software development so even if the functionality works please test it with your data and the production environment.
If you want to try other source code samples then the free trial version of ByteScout Data Extraction Suite is available for download from our website. Just try other source code samples for VBScript.
if Wscript.Arguments.Length < 2 Then WScript.Echo "Usage: PdfToXls.vbs ""input.pdf"" ""output.xlsx""" WScript.Quit End If ' Create Bytescout.PDFExtractor.XLSExtractor object Set extractor = CreateObject("Bytescout.PDFExtractor.XLSExtractor") extractor.RegistrationName = "demo" extractor.RegistrationKey = "demo" ' Set Excel format extractor.OutputFormat = 1 ' 0 - XLS format; 1 - XLSX format. ' Uncomment this line if you need all pages converted into a single worksheet: 'extractor.PageToWorksheet = False ' Load sample PDF document extractor.LoadDocumentFromFile WScript.Arguments.Item(0) ' Extract data to Excel format extractor.SaveToXLSFile WScript.Arguments.Item(1) WScript.Echo "Extracted data saved to '" & WScript.Arguments.Item(1) & "' file."
REM Run the script from the command line cscript.exe PdfToXls-CommandLine.vbs "../../sample3.pdf" "output.xlsx" pause