Every ByteScout tool contains example VB.NET source codes that you can find here or in the folder with installed ByteScout product. ByteScout Spreadsheet SDK is the SDK component for writing, reading, modifying and calculating Excel and CSV spreadsheets. Can calculate and reculculate formulas with Excel installed. You may import or export data to and from CSV, XML, JSON. Supports export to databases, arrays, streams. It can be used to export to JSON using VB.NET.
The SDK samples like this one below explain how to quickly make your application do export to JSON in VB.NET with the help of ByteScout Spreadsheet SDK. In your VB.NET project or application you may simply copy & paste the code and then run your app! Detailed tutorials and documentation are available along with installed ByteScout Spreadsheet SDK if you’d like to dive deeper into the topic and the details of the API.
Free trial version of ByteScout Spreadsheet SDK is available for download from our website. Get it to try other source code samples for VB.NET.
Imports Bytescout.Spreadsheet Imports System.IO Module Module1 Sub Main() Using spreadsheet As New Spreadsheet ' Load document spreadsheet.LoadFromFile("Table.xls") ' Export first worksheet to JSON format Dim jsonString As String = spreadsheet.ExportToJSON(0) ' Write JSON string to file File.WriteAllText("exported.json.txt", jsonString) ' Open the result file in default associated application Process.Start("exported.json.txt") End Using End Sub End Module