The documentation is designed for a specific purpose to help you to apply the features on your side. Want to export to list with spreadsheet sdk in your VB.NET app? ByteScout Data Extraction Suite is designed for it. 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.
Want to quickly learn? This fast application programming interfaces of ByteScout Data Extraction Suite for VB.NET plus the guidelines and the code below will help you quickly learn how to export to list with spreadsheet sdk. 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. Use of ByteScout Data Extraction Suite in VB.NET is also described in the documentation included along with the product.
Our website gives trial version of ByteScout Data Extraction Suite for free. It also includes documentation and source code samples.
Module Module1 Sub Main() Dim inputFile As String = "ListOfPlanetsSpreadsheet.xls" 'Open and load spreadsheet Dim spreadsheet As Spreadsheet = New Spreadsheet() spreadsheet.LoadFromFile(inputFile) 'Get the data from the spreadsheet Dim planets(10, 2) As String spreadsheet.ExportToList(planets) 'Close spreadsheet spreadsheet.Close() 'Display array Dim planetsArray(,) As String = planets For i As Integer = 0 To planetsArray.GetLength(0) - 1 For j As Integer = 0 To planets.GetLength(1) - 1 Console.Write(planetsArray(i, j) + " ") Next Console.WriteLine() Next 'Pause Console.ReadLine() End Sub End Module