ByteScout PDF Extractor SDK – VB.NET – Convert PDF To CSV (Merge multiline text to table cell)

Home
/
Articles
/
ByteScout PDF Extractor SDK – VB.NET – Convert PDF To CSV (Merge multiline text to table cell)

printable version:
ByteScout-PDF-Extractor-SDK-VB-NET-Convert-PDF-To-CSV-(Merge-multiline-text-to-table-cell).pdf

How to convert PDF to CSV (merge multiline text to table cell) in VB.NET with ByteScout PDF Extractor SDK

This tutorial will show how to convert PDF to CSV (merge multiline text to table cell) in VB.NET

The sample shows steps and algorithm of how to convert PDF to CSV (merge multiline text to table cell) and how to make it work in your VB.NET application. ByteScout PDF Extractor SDK is the SDK that helps developers to extract data from unstructured documents, pdf, images, scanned and electronic forms. Includes AI functions like automatic table detection, automatic table extraction and restructuring, text recognition and text restoration from pdf and scanned documents. Includes PDF to CSV, PDF to XML, PDF to JSON, PDF to searchable PDF functions as well as methods for low level data extraction and you can use it to convert PDF to CSV (merge multiline text to table cell) with VB.NET.

The SDK samples like this one below explain how to quickly make your application do convert PDF to CSV (merge multiline text to table cell) in VB.NET with the help of ByteScout PDF Extractor SDK. In order to implement the functionality, you should copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. You can use these VB.NET sample examples in one or many applications.

Trial version of ByteScout PDF Extractor SDK is available for free. Source code samples are included to help you with your VB.NET app.

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

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

Module1.vb

      Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Bytescout.PDFExtractor
Imports System.Diagnostics

Namespace ConsoleApplication1

    Class Program

        Shared Sub Main(ByVal args As String())

            ' Create Bytescout.PDFExtractor.CSVExtractor instance
            Dim extractor As New CSVExtractor()
            extractor.RegistrationName = "demo"
            extractor.RegistrationKey = "demo"

            ' Load sample PDF document
            extractor.LoadDocumentFromFile("sample3_multiline.pdf")

            ' You can change CSV separator symbol (if needed) from "," symbol to another if needed for non-US locales
            'extractor.CSVSeparatorSymbol = "," 

            ' For multiline cell join extracted cell text into single line
            extractor.LineGroupingMode = LineGroupingMode.GroupByRows
            extractor.Unwrap = True

            ' Save extracted CSV data to file
            extractor.SaveCSVToFile("output.csv")

            ' Cleanup
		    extractor.Dispose()

            Console.WriteLine()
            Console.WriteLine("Data has been extracted to 'output.csv' file.")
            Console.WriteLine()
            Console.WriteLine("Press any key to continue and open CSV in default CSV viewer (or Excel)...")
            Console.ReadKey()

            ' Open result file in default associated application (for demo purposes)
            Process.Start("output.csv")

        End Sub
        
    End Class
End Namespace