A simple question here: I have the following subset of my data in Javascript. My application works, but I need a simple way to bring in an expanded version of that same data, but taken from an Excel file rather than manually entered into this script. What is the simplest and easiest solution to do so with few steps in between?
const countryData={
australia: {
countryName: "France",
fsnNarrative: "aus fsn lorem ipsum dolor sit amet",
otherNarrative: "lorem ipsum dolor",
marketLink: "http://www.google.com",
center: [65, 34],
zoom:4
},
france: {
countryName: "France",
fsnNarrative: "bgd fsn lorem ipsum dolor sit amet",
otherNarrative: "lorem ipsum dolor",
marketLink: "http://www.youtube.com",
center: [90, 24],
zoom: 5
}
}
I tried to convert it in from a JSON, but had trouble also a) converting excel to JSON and b) assigning external local JSON to a constant (trying to follow this guidance but am not clear. I also use R, in case anyone has a solution with that.
Optimally, I'd be able to just link from the Javascript to an external JSON or some other file type, like this. const data = (path to some URL)
Working with just Javascript, HTML and CSS for now.
I use the SheetJS library to process and export XLS data. Please check snippet below
var json_data;
(async() => {
// fetch xls file
const url = "https://www.lucasroquilly.com/stack_overflow_samples/workbook.xls";
// store data
const data = await (await fetch(url)).arrayBuffer();
// convert to workbook
const workbook = XLSX.read(data);
//get first sheet
const worksheet = workbook.Sheets[workbook.SheetNames[0]]
//convert sheet to json
json_data = XLSX.utils.sheet_to_json(worksheet);
})();<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.5/xlsx.min.js"></script>
<button onclick="console.log(json_data)">Log json</button>