ByteScout Data Extraction Suite – VB.NET – Export to jagged array with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Export to jagged array with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VB-NET-Export-to-jagged-array-with-spreadsheet-sdk.pdf

How to export to jagged array with spreadsheet sdk in VB.NET and ByteScout Data Extraction Suite

Continuous learning is a crucial part of computer science and this tutorial shows how to export to jagged array with spreadsheet sdk in VB.NET

Export to jagged array with spreadsheet sdk is simple to apply in VB.NET if you use these source codes below. ByteScout Data Extraction Suite: the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can export to jagged array with spreadsheet sdk in VB.NET.

Want to save time? You will save a lot of time on writing and testing code as you may just take the VB.NET code from ByteScout Data Extraction Suite for export to jagged array with spreadsheet sdk below and use it in your application. Simply copy and paste in your VB.NET project or application you and then run your app! Enjoy writing a code with ready-to-use sample VB.NET codes.

Trial version of ByteScout Data Extraction 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

      Module Module1

    Sub Main()
        Dim inputFile As String = "StockPricesSpreadsheet.xls"

        'Open and load spreadsheet
        Dim spreadsheet = New Spreadsheet()
        spreadsheet.LoadFromFile(inputFile)

        'Get the data from the spreadsheet
        Dim stockPrices()() As String = spreadsheet.ExportToJaggedArray()

        'Close spreadsheet
        spreadsheet.Close()

        'Display data in jagged array
        For i As Integer = 0 To stockPrices.GetLength(0) - 1
            Console.Write(stockPrices(i)(0) + " ")
            Console.Write(stockPrices(i)(1) + " ")
            Console.WriteLine()
        Next

        'Pause
        Console.ReadLine()
    End Sub

End Module