ByteScout Spreadsheet SDK – C# – Export To Dataset

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – C# – Export To Dataset

ByteScout Spreadsheet SDK – C# – Export To Dataset

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(); } } } [/csharp]


  Click here to get your Free Trial version of the SDK

prev
next