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: