ByteScout Spreadsheet SDK – C# – Import From Data Table

Home
/
Articles
/
ByteScout Spreadsheet SDK – C# – Import From Data Table

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Import-From-Data-Table.pdf

How to import from data table in C# with ByteScout Spreadsheet SDK

The tutorial below will demonstrate how to import from data table in C#

The coding tutorials are designed to help you test the features without need to write your own code. ByteScout Spreadsheet SDK can import from data table. It can be used from C#. ByteScout Spreadsheet SDK is the SDK component for writing, reading, modifying and calculating Excel and CSV spreadsheets. Can calculate and reculculate formulas with Excel installed. You may import or export data to and from CSV, XML, JSON. Supports export to databases, arrays, streams.

Fast application programming interfaces of ByteScout Spreadsheet SDK for C# plus the instruction and the code below will help you quickly learn how to import from data table. Just copy and paste the code into your C# application’s code and follow the instruction. Test C# sample code examples whether they respond your needs and requirements for the project.

ByteScout Spreadsheet SDK free trial version is available on our website. C# and other programming languages are supported.

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

namespace Bytescout.Spreadsheet.Demo.Csharp.ImportFromDataTable
{
    class Program
    {
        static void Main(string[] args)
        {
        	const string fileName = "CSharpImportFromDataTable.xls";

        	// Create a new spreadsheet
        	Spreadsheet spreadsheet = new Spreadsheet();

        	// Get the data from the datatable that we want to import
        	DataTable periodicTable = GetDataTable();

        	// Import data into spreadheet
        	spreadsheet.ImportFromDataTable(periodicTable);

        	// Insert row with column captions
        	Worksheet worksheet = spreadsheet.Worksheets[0];
        	worksheet.Rows.Insert(0);
			for (int colIndex = 0; colIndex < periodicTable.Columns.Count; colIndex++)
        	{
				worksheet.Cell(0, colIndex).Value = periodicTable.Columns[colIndex].Caption;
        	}

        	// 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 data table of the periodic table of elements
        /// </summary>
        /// <returns>A data table of the periodic table of elements</returns>
        private static DataTable GetDataTable()
        {
            DataTable periodicTable = new DataTable("PeriodicTable");

            periodicTable.Columns.Add("Name", typeof(string));
            periodicTable.Columns.Add("Symbol", typeof(string));
            periodicTable.Columns.Add("AtomicNumber", typeof(int));

            DataRow dr = periodicTable.Rows.Add();
            dr[0] = "Hydrogen";
            dr[1] = "H";
            dr[2] = "1";

            dr = periodicTable.Rows.Add();
            dr[0] = "Helium";
            dr[1] = "He";
            dr[2] = "2";

            dr = periodicTable.Rows.Add();
            dr[0] = "Lithium";
            dr[1] = "Li";
            dr[2] = "3";

            dr = periodicTable.Rows.Add();
            dr[0] = "Beryllium";
            dr[1] = "Be";
            dr[2] = "4";

            dr = periodicTable.Rows.Add();
            dr[0] = "Boron";
            dr[1] = "B";
            dr[2] = "5";

            dr = periodicTable.Rows.Add();
            dr[0] = "Carbon";
            dr[1] = "C";
            dr[2] = "6";

            return periodicTable;
        }
    }
}