JsonExport Samples - EPPlus.WebSampleMvc.NetCore

JSON export - Chart.js line chart

In this sample we use JSON data, containing over 2000 currency rates, from EPPlus to populate a Charts.js line chart. The rates are imported to EPPlus from a .csv file using the LoadFromText function and exported to JSON via the ToJson() method. The JSON data is fetched via an ajax call to a separate MVC controller action (JsonExportController.Sample1GetJsonData())

This is just a small subset of the actual json in the sample to show the format.

            
{
    "range": {
        "columns": [
            {
                "name": "Date",
                "dt": "datetime"
            },
            {
                "name": "GBP",
                "dt": "number"
            },
            {
                "name": "EUR",
                "dt": "number"
            },
            {
                "name": "AUD",
                "dt": "number"
            },
            {
                "name": "CAD",
                "dt": "number"
            }
        ],
        "rows": [
            {
                "cells": [
                    {
                        "v": "1636588800000",
                        "t": "2021-11-11"
                    },
                    {
                        "v": "0.7464",
                        "t": "0,7464"
                    },
                    {
                        "v": "0.8726",
                        "t": "0,8726"
                    },
                    {
                        "v": "1.3699",
                        "t": "1,3699"
                    },
                    {
                        "v": "1.2582",
                        "t": "1,2582"
                    }
                ]
            },
            {
                "cells": [
                    {
                        "v": "1635984000000",
                        "t": "2021-11-04"
                    },
                    {
                        "v": "0.7377",
                        "t": "0,7377"
                    },
                    {
                        "v": "0.8644",
                        "t": "0,8644"
                    },
                    {
                        "v": "1.3486",
                        "t": "1,3486"
                    },
                    {
                        "v": "1.2417",
                        "t": "1,2417"
                    }
                ]
            }
        ]
    }
}