The sample source codes on this page shows how to export to 2d array with spreadsheet sdk in VB.NET. 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 2d array with spreadsheet sdk with VB.NET.
Want to save time? You will save a lot of time on writing and testing code as you may just take the VB.NET code from ByteScout Barcode Suite for export to 2d array with spreadsheet sdk below and use it in your application. 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! Further improvement of the code will make it more robust.
You can download free trial version of ByteScout Barcode Suite from our website to see and try many others source code samples for VB.NET.
Module Module1 Sub Main() Dim inputFile As String = "StockPricesSpreadsheet.xls" 'Open and load spreadsheet Dim spreadsheet As Spreadsheet = New Spreadsheet spreadsheet.LoadFromFile(inputFile) 'Get the data from the spreadsheet Dim stockPrices(,) As String = spreadsheet.ExportTo2DArray() 'Close spreadsheet spreadsheet.Close() 'Display contents of the array For i As Integer = 0 To stockPrices.GetLength(0) - 1 Step 1 For j As Integer = 0 To stockPrices.GetLength(1) - 1 Step 1 Console.Write(stockPrices(i, j) + " ") Next Console.WriteLine() Next 'Pause Console.ReadLine() End Sub End Module