Source code documentation samples give simple and easy method to install a needed feature into your application. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK) and you can use it to export to list with spreadsheet sdk with VB.NET.
Want to quickly learn? This fast application programming interfaces of ByteScout Barcode Suite for VB.NET plus the guidelines and the code below will help you quickly learn how to export to list with spreadsheet sdk. Just copy and paste the code into your VB.NET application’s code and follow the instructions. Want to see how it works with your data then code testing will allow the function to be tested and work properly.
All these programming tutorials along with source code samples and ByteScout free trial version are available for download from our website.
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