ByteScout Data Extraction Suite – C# – Import from jagged array with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Import from jagged array with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Import-from-jagged-array-with-spreadsheet-sdk.pdf

How to import from jagged array with spreadsheet sdk in C# using ByteScout Data Extraction Suite

Step-by-step tutorial on how to import from jagged array with spreadsheet sdk in C#

The sample shows instructions and algorithm of how to import from jagged array with spreadsheet sdk and how to make it run in your C# application. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK. It can import from jagged array with spreadsheet sdk in C#.

This prolific sample source code in C# for ByteScout Data Extraction Suite contains various functions and other necessary options you should do calling the API to import from jagged array with spreadsheet sdk. Just copy and paste the code into your C# application’s code and follow the instructions. Applying C# application mostly includes various stages of the software development so even if the functionality works please test it with your data and the production environment.

ByteScout provides the free trial version of ByteScout Data Extraction Suite along with the documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Program.cs

      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
            spreadsheet.ImportFromJaggedArray(periodicTable);

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

            // Close spreadsheet
            spreadsheet.Close();
            
            // Open the spreadsheet
            Process.Start(fileName);
        }

        /// <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;
        }
    }
}