ByteScout Data Extraction Suite – VB.NET – Import from json with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – VB.NET – Import from json with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-VB-NET-Import-from-json-with-spreadsheet-sdk.pdf

How to import from json with spreadsheet sdk in VB.NET and ByteScout Data Extraction Suite

Learn to import from json with spreadsheet sdk in VB.NET

The sample source code below will teach you how to import from json with spreadsheet sdk in VB.NET. ByteScout Data Extraction Suite can import from json with spreadsheet sdk. It can be applied from VB.NET. 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.

The SDK samples given below describe how to quickly make your application do import from json with spreadsheet sdk in VB.NET with the help of ByteScout Data Extraction Suite. This VB.NET sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Applying VB.NET application mostly includes various stages of the software development so even if the functionality works please test it with your data and the production environment.

The trial version of ByteScout Data Extraction Suite can be downloaded for free from our website. It also includes source code samples for VB.NET 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)

Module1.vb

      Imports Bytescout.Spreadsheet
Imports System.IO

Module Module1

    Sub Main()

        Using spreadsheet As New Spreadsheet

            ' Load JSON string from file
            Dim jsonString As String = File.ReadAllText("sample.json")

            ' Import JSON
            spreadsheet.ImportFromJSON(jsonString)

            ' Save spreadsheet
            spreadsheet.SaveAsXLS("result.xls")

            ' Open the result file in default associated application
            Process.Start("result.xls")

        End Using

    End Sub

End Module