ByteScout simple and easy to understand tutorials are planned to describe the code for both VB.NET beginners and advanced programmers. Want to export to datatable with spreadsheet sdk in your VB.NET app? ByteScout Barcode Suite is designed for it. 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).
These VB.NET code samples for VB.NET guide developers to speed up coding of the application when using ByteScout Barcode Suite. Just copy and paste the code into your VB.NET application’s code and follow the instructions. Complete and detailed tutorials and documentation are available along with installed ByteScout Barcode Suite if you’d like to learn more about the topic and the details of the API.
You can download free trial version of ByteScout Barcode Suite from our website with this and other source code samples for VB.NET.
Module Module1 Sub Main() Dim inputFile As String = "PeriodicTableOfElementsSpreadsheet.xls" 'Open and load spreadsheet Dim spreadsheet = New Spreadsheet() spreadsheet.LoadFromFile(inputFile) 'Get the data from the spreadsheet Dim dt As DataTable = spreadsheet.ExportToDataTable() 'Close spreadsheet spreadsheet.Close() 'Display data in datatable For i As Integer = 0 To dt.Rows.Count - 1 For j As Integer = 0 To dt.Columns.Count - 1 Console.Write(dt.Rows(i)(j) + " ") Next Console.WriteLine() Next 'Pause Console.ReadLine() End Sub End Module