Can you show the data of an excel-fle (or csv) in a webpage

Question

I have some data in a csv-file. I need to represent this data in a nice way to non technical people.

I can do this in excel and use macro's and VBA

But this thought came in to my mind.
Can I read the data from these files and show it in a webpage.
It does not need to be on the internet, all files are local.

What would I need if I wanted to do this

Answer 1

You could use d3 to get content of a csv file to an object. Use cors helper url to get rid of cors if the location of csv file is not the same domain as html file. You don't need corsUrl for local file access.

var corsUrl = 'https://cors-anywhere.herokuapp.com/';
d3.csv(corsUrl + csvFile, function(data){
console.log(data);
});

Note that it requires that the first line of the CSV file contains a comma-separated list of column names; these column names become the attributes on the returned objects. For example, consider the following CSV file:

Year,Make,Model,Length
1997,Ford,E350,2.34
2000,Mercury,Cougar,2.38

Reference: https://d3-wiki.readthedocs.io/zh_CN/master/CSV/

https://code.sololearn.com/Wwb3QtwCmvdX/?ref=app

Answer 2

Thank you. I will try.