ByteScout Invoice Parser SDK – VB.NET – Parse Folder With Invoices To CSV

Home
/
Articles
/
ByteScout Invoice Parser SDK – VB.NET – Parse Folder With Invoices To CSV

printable version:
ByteScout-Invoice-Parser-SDK-VB-NET-Parse-Folder-With-Invoices-To-CSV.pdf

How to parse folder with invoices to CSV in VB.NET using ByteScout Invoice Parser SDK

How to parse folder with invoices to CSV in VB.NET

The sample shows steps and algorithm of how to parse folder with invoices to CSV and how to make it work in your VB.NET application. ByteScout Invoice Parser SDK: the invoices processor engine that comes with built-in support for invoices from thousands of companies. Automatically detects company that issued invoice, extracts invoice number, date, total amount to be paid. Constantly updated to support invoices from new companies. Supports batch processing of invoices with JSON, CSV, XML output. It can parse folder with invoices to CSV in VB.NET.

This code snippet below for ByteScout Invoice Parser SDK works best when you need to quickly parse folder with invoices to CSV in your VB.NET application. Just copy and paste the code into your VB.NET application’s code and follow the instruction. Detailed tutorials and documentation are available along with installed ByteScout Invoice Parser SDK if you’d like to dive deeper into the topic and the details of the API.

Download free trial version of ByteScout Invoice Parser SDK from our website with this and other source code samples for VB.NET.

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.Text
Imports ByteScout.InvoiceParser

Module Module1

    Sub Main()

        Dim inputFolder As String = ".\invoices"
        Dim outputFile As String = ".\result.csv"

        ' Create InvoiceParser instance
        Using parser As InvoiceParser = New InvoiceParser("demo", "demo")

            ' Setup CSV output
            Dim csvOptions As CSVOptions = New CSVOptions()
            csvOptions.Encoding = Encoding.UTF8
            csvOptions.SeparatorCharacter = ","
            csvOptions.QuotationCharacter = """"
            csvOptions.UnwrapMultilineValues = True

            ' Parse all document in input folder and save results to CSV file
            BatchProcessing.ParseFolderToCSV(parser, inputFolder, outputFile, csvOptions, AddressOf ProcessingCallback)

        End Using

        ' Open generated CSV file in default associated application (for demo purpose)
        Process.Start(outputFile)

    End Sub

    Sub ProcessingCallback(fileName As String, parsingResult As Boolean, progress As Double, innerException As Exception, ByRef cancel As Boolean)

        Console.WriteLine({code}quot;{progress}% Processed file ""{fileName}""")
        Console.WriteLine({code}quot;  Result: {parsingResult}")

        If Not parsingResult 

            If innerException IsNot Nothing
                Console.WriteLine(innerException.ToString())
            End If

            Console.Write("Continue processing? (y/n): ")
            Dim key As Integer = Console.Read()
            If key = 110 ' n
                Console.WriteLine("Interrupted.")
                cancel = True
            End If

        End If

    End Sub

End Module