Link Search Menu Expand Document

Import From Jagged Array - C#

Spreadsheet SDK sample in C# demonstrating ‘Import From Jagged Array’

using System.Diagnostics;
using System.IO;

namespace Bytescout.Spreadsheet.Demo.Csharp.ImportFromJaggedArray
    class Program
        static void Main(string[] args)
            const string fileName = "CSharpImportFromJaggedArray.xls";
            // Create a new spreadsheet
            Spreadsheet spreadsheet = new Spreadsheet();

            // Get the data from the jagged array that we want to import
            string[][] periodicTable = GetJaggedArray();

            // Import data into spreadheet

            // Save the spreadsheet
            if (File.Exists(fileName)) File.Delete(fileName);

            // Close spreadsheet
            // Open the spreadsheet

        /// <summary>
        /// Creates a jagged array of the period table of elements
        /// </summary>
        /// <returns>Jagged array of the periodic table of elements</returns>
        private static string[][] GetJaggedArray()
              string[][] periodicTable = {
                           new string[] {"H","He"},
                           new string[] {"Li","Be","B","C", "N", "O", "F", "Ne"},
                           new string[] {"Na","Mg","Al","Si", "P", "S", "Cl", "Ar"},
                           new string[] {"K", "Ca", "Sc", "Ti", "V", "Cr", "Mn", "Fe", "Co", "Ni", "Cu", "Zn", "Ga", "Ge", "As", "Se", "Br", "Kr"}
            return periodicTable;

Download Source Code (.zip)

Return to the previous page Explore Spreadsheet SDK