ExcelMapper JSON Format

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

ExcelMapper allows you to easily serialize to and from JSON formatted cells. You only need to specify either the Json attribute or call the AsJson() method.

Let's consider the following excel which contains the data in JSON format.


The following example reads all the data in json format and loads it in the Author class objects.

public static void Example1()
    var excelMapper = new ExcelMapper(@"D:\authors1.xlsx");

    excelMapper.AddMapping<AuthorJson>("Authors", a => a.Author).AsJson();

    var authors = excelMapper.Fetch<AuthorJson>().ToList();

    foreach (var item in authors)
        Console.WriteLine("Id: {0}, Name: {1}, Country: {2}", item.Author.AuthorId, item.Author.Name, item.Author.Country);

class AuthorJson
    public Author Author { get; set; }

public class Author
    public int AuthorId { get; set; }
    public string Name { get; set; }
    public string Country { get; set; }

Let's execute the above code and you will see the following output.

Id: 1, Name: Carson Alexander, Country: US
Id: 2, Name: Meredith Alonso, Country: UK
Id: 3, Name: Arturo Anand, Country: Canada
Id: 4, Name: Gytis Barzdukas, Country: UK
Id: 5, Name: Yan Li, Country: Japan

Got any ExcelMapper Question?