Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Export To Jagged Array | VB.NET
Module1.vb:
VB
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