using System;

using System.Collections.Generic;

using System.Data;

using System.IO;

using Newtonsoft.Json;

using NPOI.XSSF.UserModel;

using System.Linq;

​

var persons = new List<UserAccount>()

{

    new UserAccount {ID=1, Name="ABCD"},

    new UserAccount {ID=2, Name="PQRS"},

    new UserAccount {ID=3, Name="XYZZ"},

    new UserAccount {ID=4, Name="LMNO"}

};

​

var table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(persons), (typeof(DataTable)));

var memoryStream = new MemoryStream();

​

​

using (var fs = new FileStream("C:\\Users\\cbrandao\\Desktop\\Result.xlsx", FileMode.Create, FileAccess.Write))

{

    var workbook = new XSSFWorkbook();

    var excelSheet = workbook.CreateSheet("Sheet1");

​

    var columns = new List<string>();

    var row = excelSheet.CreateRow(0);

    var columnIndex = 0;

​

    foreach (DataColumn column in table.Columns)

    {

        columns.Add(column.ColumnName);

        row.CreateCell(columnIndex).SetCellValue(column.ColumnName);

        columnIndex++;

    }

    Console.WriteLine(string.Join(" - ", table.Columns.Cast<DataColumn>().Select(x => x.ColumnName)));

​

    int rowIndex = 1;

    foreach (DataRow dsrow in table.Rows)

    {

        row = excelSheet.CreateRow(rowIndex);

        int cellIndex = 0;

        foreach (String col in columns)

        {

            row.CreateCell(cellIndex).SetCellValue(dsrow[col].ToString());

            cellIndex++;

        }

        Console.WriteLine(string.Join(" - ", dsrow.ItemArray));

​

        rowIndex++;

    }

    workbook.Write(fs);

}

​

public class UserAccount

{

    public int ID { get; set; }

    public string Name { get; set; }

}

​