Export to jagged array with spreadsheet sdk is simple to apply in VB.NET if you use these source codes below. ByteScout Data Extraction Suite: the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can export to jagged array with spreadsheet sdk in 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 Data Extraction Suite for export to jagged array with spreadsheet sdk below and use it in your application. Simply copy and paste in your VB.NET project or application you and then run your app! Enjoy writing a code with ready-to-use sample VB.NET codes.
Trial version of ByteScout Data Extraction Suite is available for free. Source code samples are included to help you with your VB.NET app.
Module Module1 Sub Main() Dim inputFile As String = "StockPricesSpreadsheet.xls" 'Open and load spreadsheet Dim spreadsheet = New Spreadsheet() spreadsheet.LoadFromFile(inputFile) 'Get the data from the spreadsheet Dim stockPrices()() As String = spreadsheet.ExportToJaggedArray() 'Close spreadsheet spreadsheet.Close() 'Display data in jagged array For i As Integer = 0 To stockPrices.GetLength(0) - 1 Console.Write(stockPrices(i)(0) + " ") Console.Write(stockPrices(i)(1) + " ") Console.WriteLine() Next 'Pause Console.ReadLine() End Sub End Module