- Home
- Purchase
- Developer Tools
- BarCode Generator SDK
- BarCode Generator SDK for Javascript for Code 128
- BarCode Reader SDK
- PDF Generator SDK for Javascript
- PDF Extractor SDK
- PDF Renderer SDK
- PDF To HTML SDK
- PDF Viewer SDK
- Spreadsheet SDK
- Image To Video SDK
- Screen Video Capturing SDK
- SWF To Video and Images SDK
- Images Watermarking SDK
- Document SDK beta
- Misc Tools
- Desktop Utilities
- Download
- Support
- Company
How to export data from XLS spreadsheet to Data Table with Spreadsheet SDK
This example demonstrates how to get data from XLS spreadsheet and export them to data table in C# and Visual Basic .NET using Bytescout Spreadsheet SDK.
C#
using System; using System.Data; namespace Bytescout.Spreadsheet.Demo.Csharp.ExportToDataTable { class Program { static void Main(string[] args) { const string inputFile = @"PeriodicTableOfElementsSpreadsheet.xls"; // Open and load spreadsheet Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.LoadFromFile(inputFile); // Get the data from the spreadsheet DataTable dt = spreadsheet.ExportToDataTable(); // Close spreadsheet spreadsheet.Close(); // Display array for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { Console.Write(dt.Rows[i][j] + " "); } Console.WriteLine(); } // Pause Console.ReadLine(); } } }
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
Filed in:
Spreadsheet SDK
Tutorials:









