ByteScout PDF Suite – VB.NET – Convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk

Home
/
Articles
/
ByteScout PDF Suite – VB.NET – Convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk

printable version:
ByteScout-PDF-Suite-VB-NET-Convert-pdf-to-csv-(merge-multiline-text-to-table-cell)-with-pdf-extractor-sdk.pdf

How to convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk in VB.NET using ByteScout PDF Suite

This code in VB.NET shows how to convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk with this how to tutorial

The sample source code below will teach you how to convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk in VB.NET. ByteScout PDF Suite is the bundle that provides six different SDK libraries to work with PDF from generating rich PDF reports to extracting data from PDF documents and converting them to HTML. This bundle includes PDF (Generator) SDK, PDF Renderer SDK, PDF Extractor SDK, PDF to HTML SDK, PDF Viewer SDK and PDF Generator SDK for Javascript and you can use it to convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk with VB.NET.

The following code snippet for ByteScout PDF Suite works best when you need to quickly convert pdf to csv (merge multiline text to table cell) with pdf extractor sdk in your VB.NET application. IF you want to implement the functionality, just copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

Trial version of ByteScout PDF Suite 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