The documentation is designed to help you to implement the features on your side. ByteScout Spreadsheet SDK can export to list. It can be used from VB.NET. ByteScout Spreadsheet SDK is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays.
This code snippet below for ByteScout Spreadsheet SDK works best when you need to quickly export to list in your VB.NET application. In your VB.NET project or application you may simply copy & paste the code and then run your app! Enjoy writing a code with ready-to-use sample codes in VB.NET.
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.
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