1
I’m creating a Dashboard based on an excel spreadsheet, I was able to create the charts using Chart.js but I don’t know a way to get the data to be taken from the spreadsheet, anyone know a way to do that? (the graphs I created, I typed the value of the data in the code, to see if it was working, but the spreadsheet has more than 500 lines and is updated daily, so I need something to connect to this spreadsheet)
Why not export these data in CSV?
– Márcio Eric
I thought about it already, but as I said the spreadsheet is updated every day, so the user would have to manually export to csv and depending on the user is something kind... so I need to either take the data directly from excel or a way to upload the file daily and get the data in it, if you know any way to do this, even export to csv can also speak that I search here and see if I can do too, any help is welcome :)
– Emmanuel S.
I understand, but Excel has the functionality to connect to the database, ever thought about it? Whenever the user saves it updates a comic and then you do your graphics, I never did it to tell the truth, but I imagine a little more study you can. Still in excel functions it has macros.
– Márcio Eric
I had forgotten this Excel function, grateful to speak of it, I will test here and see if it fits in the project
– Emmanuel S.