How to import data to Json from a table in Excel

Asked

Viewed 1,147 times

2

I want to generate charts with Chart.js and need to import data from an excel spreadsheet to json in order to elaborate the chart.

var data = {
labels: ["January", "February", "March", "April", "May", "June", "July"],
datasets: [
    {
        label: "My First dataset",
        fillColor: "rgba(220,220,220,0.2)",
        strokeColor: "rgba(220,220,220,1)",
        pointColor: "rgba(220,220,220,1)",
        pointStrokeColor: "#fff",
        pointHighlightFill: "#fff",
        pointHighlightStroke: "rgba(220,220,220,1)",
        **data: [65, 59, 80, 81, 56, 55, 40]**
    },
    {
        label: "My Second dataset",
        fillColor: "rgba(151,187,205,0.2)",
        strokeColor: "rgba(151,187,205,1)",
        pointColor: "rgba(151,187,205,1)",
        pointStrokeColor: "#fff",
        pointHighlightFill: "#fff",
        pointHighlightStroke: "rgba(151,187,205,1)",
        **data: [28, 48, 40, 19, 86, 27, 90]**
    }
]

};

javascript html json excel

  • Solved your doubt?

  • No. to this day this pedente

  • Take a look at this link, was it?... was it even a question of yours. http://answall.com/questions/122082/tool_para-converter-excel-para-json

  • Alex, you solved your problem?

  • No... until today this pedente!!!

1 answer

1

You can do this using some ferarmenta online like this one, or automate using this library for Node.js. You can convert the table to json in a very simple way:

var parser = new (require('simple-excel-to-json').XlsParser)();
var doc = parser.parseXls2Json('exemplo.xlsx'); // Nome do arquivo

console.log(doc[0]); // Planinlha já convertida para JSON

Browser other questions tagged javascript html json excel

You are not signed in. Login or sign up in order to post.