- Home
- Testimonials
- Purchase
- Developer Tools
- Desktop Utilities
- Download
- Support
- Blog
- Company
How to export data from XLS spreadsheet to list with Spreadsheet SDK
These C# and Visual Basic .NET code samples show how to export data from Excel document to list and display the result array with Bytescout Spreadsheet SDK.
C#
using System; using System.Collections; namespace Bytescout.Spreadsheet.Demo.Csharp.ExportToList { class Program { static void Main(string[] args) { const string inputFile = @"ListOfPlanetsSpreadsheet.xls"; // Open and load spreadsheet Spreadsheet spreadsheet = new Spreadsheet(); spreadsheet.LoadFromFile(inputFile); // Get the data from the spreadsheet IList planets = new string[10, 10]; spreadsheet.ExportToList(planets); // Close spreadsheet spreadsheet.Close(); // Display array string[,] planetsArray = planets as string[,]; for (int i = 0; i < planetsArray.GetLength(0); i++) { for (int j = 0; j < planetsArray.GetLength(1); j++) { Console.Write(planetsArray[i, j] + " "); } Console.WriteLine(); } // Pause Console.ReadLine(); } } }
VB.NET
Module Module1
Sub Main()
Dim inputFile As String = "ListOfPlanetsSpreadsheet.xls"
'Open and load spreadsheet
Dim spreadsheet As Spreadsheet = New Spreadsheet()
spreadsheet.LoadFromFile(inputFile)
'Get the data from the spreadsheet
Dim planets(10, 2) As String
spreadsheet.ExportToList(planets)
'Close spreadsheet
spreadsheet.Close()
'Display array
Dim planetsArray(,) As String = planets
For i As Integer = 0 To planetsArray.GetLength(0) - 1
For j As Integer = 0 To planets.GetLength(1) - 1
Console.Write(planetsArray(i, j) + " ")
Next
Console.WriteLine()
Next
'Pause
Console.ReadLine()
End Sub
End Module
Filed in:
Spreadsheet SDK
Tutorials:









