var datasource = new System.Data.DataTable();
 datasource.Columns.Add(new DataColumn("ID", typeof(Int32)));
 datasource.Columns.Add(new DataColumn("Name", typeof(string)));
 datasource.Columns.Add(new DataColumn("Score", typeof(Int32)));
 datasource.Columns.Add(new DataColumn("Team", typeof(string)));
 
 
 ...//Init data
 
 
 //Add data source
 workbook.AddDataSource("ds", datasource);

var dTable1 = new System.Data.DataTable();
var dTable2 = new System.Data.DataTable();
 
 
 ...//Init data
 
 
 var datasource = new System.Data.DataSet();
 datasource.Tables.Add(team1);
 datasource.Tables.Add(team2);
 
 
 //Add data source
 workbook.AddDataSource("ds", datasource);

var datasource = new SalesData
             {
                 Records = new List<SalesRecord>()
             };
 
             var record1 = new SalesRecord
             {
                 Area = "NorthChina",
                 Salesman = "Hellen",
                 Product = "Apple",
                 ProductType = "Fruit",
                 Sales = 120
             };
             datasource.Records.Add(record1);
 
             var record2 = new SalesRecord
             {
                 Area = "NorthChina",
                 Salesman = "Hellen",
                 Product = "Banana",
                 ProductType = "Fruit",
                 Sales = 143
             };
             datasource.Records.Add(record2);
 
 
 ...//Init data
 
 
 //Add data source
 workbook.AddDataSource("ds", datasource);

class Program
{
    static void Main(string[] args)
    {
        // Initialize Workbook.
        var workbook = new Workbook();

        // Open template file.
        workbook.Open("ComplexMultiDataSource.xlsx");

        // Create table data sources from JSON.
        Stream order_json = new FileStream("order.json", FileMode.Open);
        Stream customer_json = new FileStream("customer.json", FileMode.Open);
        Stream product_json = new FileStream("product.json", FileMode.Open);
        JsonTable order = new JsonTable(order_json);
        JsonTable customer = new JsonTable(customer_json);
        JsonTable product = new JsonTable(product_json);

        // Add data sources for template.
        workbook.AddDataSource("order", order);
        workbook.AddDataSource("customer", customer);
        workbook.AddDataSource("product", product);

        // Process the template.
        workbook.ProcessTemplate();

        // Set column width.
        workbook.Worksheets[0].Range["A:F"].ColumnWidth = 16;

        // Save to an Excel file.
        workbook.Save("CustomDataTable.xlsx");

    }
}

/*
The class is only part of the sample, not part of the product.
So it is not recommended to use this class in a production environment.
Please implement your own class that meets the requirements of the product.
*/
// Create a class to transform a JSON stream into a table and inherit ITableDataSource.
internal class JsonTable : ITableDataSource
{
    private readonly List<JsonElement> _jsonArray;
    private readonly Dictionary<int, string> _columnsMap;
    private readonly Dictionary<string, int> _reversedColumnsMap;

    public JsonTable(Stream inputStream)
    {
        string jsonContent;
        try
        {
            jsonContent = ConvertToString(inputStream);
        }
        catch (IOException e)
        {
            throw new Exception(e.Message, e);
        }

        _jsonArray = ToJsonArray(JsonDocument.Parse(jsonContent).RootElement.EnumerateArray());

        JsonElement jsonObject = _jsonArray[0];

        _columnsMap = new Dictionary<int, string>();
        _reversedColumnsMap = new Dictionary<string, int>();
        foreach (var property in jsonObject.EnumerateObject())
        {
            _columnsMap.Add(_columnsMap.Count, property.Name);
            _reversedColumnsMap.Add(property.Name, _reversedColumnsMap.Count);
        }
    }

    private List<JsonElement> ToJsonArray(ArrayEnumerator enumerator)
    {
        var jsonArray = new List<JsonElement>();
        while (enumerator.MoveNext())
        {
            jsonArray.Add(enumerator.Current);
        }
        return jsonArray;
    }

    private string ConvertToString(Stream inputStream)
    {
        using (StreamReader reader = new StreamReader(inputStream, Encoding.UTF8))
        {
            return reader.ReadToEnd();
        }
    }

    // Get column count from data source.
    public int GetColumnCount()
    {
        return _columnsMap.Count;
    }

    // Get column index from data source.
    public int GetColumnIndex(string columnName)
    {
        if (_reversedColumnsMap.TryGetValue(columnName, out int res))
        {
            return res;
        }

        return -1;
    }

    // Get column name from data source.
    public string GetColumnName(int column)
    {
        if (_columnsMap.TryGetValue(column, out string res))
        {
            return res;
        }

        return null;
    }

    // Get row count from data source.
    public int GetRowCount()
    {
        return _jsonArray.Count;
    }

    // Get value from data source.
    public object GetValue(int row, int column)
    {
        JsonElement jsonElement = _jsonArray[row].GetProperty(this.GetColumnName(column));

        switch (jsonElement.ValueKind)
        {
            case JsonValueKind.String:
                return jsonElement.GetString();
            case JsonValueKind.Number:
                return jsonElement.GetDouble();
            case JsonValueKind.True:
                return true;
            case JsonValueKind.False:
                return false;
            case JsonValueKind.Null:
            case JsonValueKind.Undefined:
            case JsonValueKind.Object:
            case JsonValueKind.Array:
            default:
                return null;
        }
    }
}

  // Load json text
  var jsonText = File.OpenText("Template_FamilyInfo.json").ReadToEnd();

  // Create a JsonDataSource
  var datasource = new JsonDataSource(jsonText);

  // Add data source
  workbook.AddDataSource("ds", datasource);

var className = "Class 3";
 var count = 500;
 
 //Add data source
 workbook.AddDataSource("cName", datasource);
 workbook.AddDataSource("count", count);
 workbook.AddDataSource("owner", "Hunter Liu");

int[] numbers = new int[] { 10, 12, 8, 15};
 List<string> countries = new List<string>() { "USA", "Japan", "UK", "China" };
 
 List<Person> peoples = new List<Person>();
 
 Person p1 = new Person();
 p1.Name = "Helen";
 p1.Age = 12;
 peoples.Add(p1);
 
 Person p2 = new Person();
 p2.Name = "Jack";
 p2.Age = 23;
 peoples.Add(p2);
 
 Person p3 = new Person();
 p3.Name = "Fancy";
 p3.Age = 25;
 peoples.Add(p3);
 
 workbook.AddDataSource("p", peoples);
 workbook.AddDataSource("countries", countries);
 workbook.AddDataSource("numbers", numbers);

// Create a new workbook.
var workbook = new GrapeCity.Documents.Excel.Workbook();

// Load template file from resource.
workbook.Open("Template_SalesDataGroup_DataTable.xlsx");

Console.WriteLine("Creating test data.");

// Add data to DataTable.
var datasource = new System.Data.DataTable();
datasource.Columns.Add(new DataColumn("Area", typeof(string)));
datasource.Columns.Add(new DataColumn("City", typeof(string)));
datasource.Columns.Add(new DataColumn("Category", typeof(string)));
datasource.Columns.Add(new DataColumn("Name", typeof(string)));
datasource.Columns.Add(new DataColumn("Revenue", typeof(double)));

var areas = new[] { "North America", "South America" };
var cities = new[] { "Chicago", "New York", "Santiago", "Quito", "Fremont", "Buenos Aires", "Medillin", "Minnesota" };
var categories = new[] { "Consumer Electronics", "Mobile" };
var category1NamePrefixes = new[] { "Bose ", "Canon ", "Haier ", "IFB ", "Mi ", "Sennheiser " };
var category2NamePrefixes = new[] { "iPhone ", "OnePlus ", "Redmi ", "Samsung " };

Random rand = new Random();
var rows = datasource.Rows;

// You can increase the loop count if the demo is too fast on your computer.
for (var i = 0; i < 50000; i++)
{
    var area = areas[rand.Next(0, areas.Length)];
    var city = cities[rand.Next(0, cities.Length)];
    var categoryId = rand.Next(0, categories.Length);
    var category = categories[categoryId];
    var names = (categoryId == 0) ? category1NamePrefixes : category2NamePrefixes;
    var name = names[rand.Next(0, names.Length)] + rand.Next(10, 10000).ToString();
    var revenue = rand.Next(10000, 100000);
    rows.Add(area, city, category, name, revenue);
}

// Add template global settings.
workbook.Names.Add("TemplateOptions.KeepLineSize", "true");

// Add data source.
workbook.AddDataSource("ds", datasource);

// Cancel data source binding when cancel key is pressed or timeout is reached.
using (CancellationTokenSource cancellation = new CancellationTokenSource())
{
    void cancelHandler(object sender, ConsoleCancelEventArgs e)
    {
        // Exit the process.
        e.Cancel = true;

        // Prevent entering cancelHandler when ProcessTemplate is completed or canceled.
#if NETCOREAPP3_0_OR_GREATER
        Console.CancelKeyPress -= cancelHandler;
#endif
        // Cancel when cancel key is pressed.
        cancellation.Cancel();
    };
    Console.CancelKeyPress += cancelHandler;

    // Cancel when timeout is reached.
    cancellation.CancelAfter(TimeSpan.FromSeconds(10));
    Console.WriteLine("Start ProcessTemplate.");
    try
    {
        workbook.ProcessTemplate(cancellation.Token);
        Console.WriteLine("ProcessTemplate finished.");
    }
    catch (OperationCanceledException ex) when (ex.CancellationToken == cancellation.Token)
    {
        Console.WriteLine("ProcessTemplate was canceled.");
    }

    // Prevent entering cancelHandler when ProcessTemplate is completed or canceled.
#if NETCOREAPP3_0_OR_GREATER
    Console.CancelKeyPress -= cancelHandler;
#endif
}

// Save the workbook.
workbook.Save("CancelTemplateProcessing.xlsx");