ByteScout Data Extraction Suite – VBScript – Find pdf table and extract as xml with pdf extractor sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VBScript – Find pdf table and extract as xml with pdf extractor sdk

printable version:
ByteScout-Data-Extraction-Suite-VBScript-Find-pdf-table-and-extract-as-xml-with-pdf-extractor-sdk.pdf

How to find pdf table and extract as xml with pdf extractor sdk in VBScript and ByteScout Data Extraction Suite

How to write a robust code in VBScript to find pdf table and extract as xml with pdf extractor sdk with this step-by-step tutorial

These sample source codes on this page below are displaying how to find pdf table and extract as xml with pdf extractor sdk in VBScript. 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 be applied to find pdf table and extract as xml with pdf extractor sdk using VBScript.

The SDK samples given below describe how to quickly make your application do find pdf table and extract as xml with pdf extractor sdk in VBScript with the help of ByteScout Data Extraction Suite. Simply copy and paste in your VBScript project or application you and then run your app! This basic programming language sample code for VBScript will do the whole work for you to find pdf table and extract as xml with pdf extractor sdk.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for VBScript and other programming languages.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

FindTableAndExtractAsXML.vbs

      ' Create Bytescout.PDFExtractor.TextExtractor object
Set tableDetector= CreateObject("Bytescout.PDFExtractor.TableDetector")
tableDetector.RegistrationName = "demo"
tableDetector.RegistrationKey = "demo"

' Create Bytescout.PDFExtractor.xmlExtractor object
Set xmlExtractor = CreateObject("Bytescout.PDFExtractor.XMLExtractor")
xmlExtractor.RegistrationName = "demo"
xmlExtractor.RegistrationKey = "demo"

' We should define what kind of tables we should detect.
' So we set min required number of columns to 3 ...
tableDetector.DetectionMinNumberOfColumns = 3
' ... and we set min required number of rows to 3
tableDetector.DetectionMinNumberOfRows = 3

' Load sample PDF document
tableDetector.LoadDocumentFromFile("..\..\sample3.pdf")
xmlExtractor.LoadDocumentFromFile "..\..\sample3.pdf"

' Get page count
pageCount = tableDetector.GetPageCount()

' Iterate through pages
For i = 0 to pageCount - 1 
 
	t = 0
	' Find first table and continue if found
	If (tableDetector.FindTable(i)) Then

		Do
			' Set extraction area for CSV extractor to rectangle received from the table detector
			xmlExtractor.SetExtractionArea _
				tableDetector.GetFoundTableRectangle_Left(), _
				tableDetector.GetFoundTableRectangle_Top(), _
				tableDetector.GetFoundTableRectangle_Width(), _
				tableDetector.GetFoundTableRectangle_Height()
			' Export the table to CSV file
			xmlExtractor.SavePageXMLToFile i, "page-" & CStr(i) & "-table-" & CStr(t) & ".xml"
			t = t + 1
		Loop While tableDetector.FindNextTable()
		
	End If

Next

Set xmlExtractor = Nothing
Set tableDetector = Nothing