Export To Jagged Array - C#
Spreadsheet SDK sample in C# demonstrating ‘Export To Jagged Array’
Program.cs
using System;
namespace Bytescout.Spreadsheet.Demo.Csharp.ExportToJaggedArray
{
class Program
{
static void Main(string[] args)
{
const string inputFile = @"StockPricesSpreadsheet.xls";
// Open and load spreadsheet
Spreadsheet spreadsheet = new Spreadsheet();
spreadsheet.LoadFromFile(inputFile);
// Get the data from the spreadsheet
string[][] stockPrices = spreadsheet.ExportToJaggedArray();
// Close spreadsheet
spreadsheet.Close();
// Display data in jagged array
for (int i = 0; i < stockPrices.GetLength(0); i++)
{
Console.Write(stockPrices[i][0] + " ");
Console.Write(stockPrices[i][1] + " ");
Console.WriteLine();
}
// Pause
Console.ReadLine();
}
}
}