ByteScout Barcode Suite – C# – Export to dataset with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Export to dataset with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Export-to-dataset-with-spreadsheet-sdk.pdf

How to export to dataset with spreadsheet sdk in C# and ByteScout Barcode Suite

If you want to learn more then this tutorial will show how to export to dataset with spreadsheet sdk in C#

Sample source code below will display you how to manage a complex task like export to dataset with spreadsheet sdk in C#. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK). It can export to dataset with spreadsheet sdk in C#.

Want to save time? You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Barcode Suite for export to dataset with spreadsheet sdk below and use it in your application. IF you want to implement the functionality, just copy and paste this code for C# below into your code editor with your app, compile and run your application. Want to see how it works with your data then code testing will allow the function to be tested and work properly.

Trial version of ByteScout Barcode Suite is available for free. Source code samples are included to help you with your C# app.

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;
using System.Data;

namespace Bytescout.Spreadsheet.Demo.Csharp.ExportToDataSet
{
    class Program
    {
        static void Main(string[] args)
        {
            const string inputFile = @"PeriodicTableOfElementsSpreadsheet.xls";

            // Open and load spreadsheet
            Spreadsheet spreadsheet = new Spreadsheet();
            spreadsheet.LoadFromFile(inputFile);

            // Get the data from the spreadsheet
            DataSet dataSet = spreadsheet.ExportToDataSet();

            // Close spreadsheet
            spreadsheet.Close();

            // Display data in the first data table in the dataset
            DataTable dt = dataSet.Tables[0];
            Console.WriteLine("Displaying contents of first datatable");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    Console.Write(dt.Rows[i][j] + " ");
                }
                Console.WriteLine();
            }

            // Pause
            Console.ReadLine();
        }
    }
}