citationSheetParse.js

//
// begining of xlsx to json coversion
//

var jsonContent = [];
var bibAuthors = "";
var bit1stAuthorLN ="";



/* set up XMLHttpRequest */
var url = "./content/citation_FGDI.xlsx";
var xmlHttpRequest = new XMLHttpRequest();
xmlHttpRequest.open("GET", url, true);
xmlHttpRequest.responseType = "arraybuffer";
xmlHttpRequest.onload = function (e) {
    var arraybuffer = xmlHttpRequest.response;

    // convert data to binary string //
    var data = new Uint8Array(arraybuffer);
    var arr = new Array();
    for (var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
    var bstr = arr.join("");

    // Call XLSX //
    var workbook = XLSX.read(bstr, {
        type: "binary"
    });

    // DO SOMETHING WITH workbook HERE //
    var first_sheet_name = workbook.SheetNames[0];
    // Get worksheet //
    var worksheet = workbook.Sheets[first_sheet_name];

    var jsonOutput = XLSX.utils.sheet_to_json(worksheet);
    // console.log(jsonOutput);

    for (i = 0; i < jsonOutput.length; i++) {
        var authors;
        if (jsonOutput[i].Authors != undefined){
            authors = jsonOutput[i].Authors.replace("and ", "").trim().split(",");
        }
        var bibAuthors;
        var item = {
            "item": {
                "title": "",
                "project": "",
                "authors": [],
                "imageLink": "",
                "keywords": "",
                "journal": {
                    "name": "journal",
                    "volume": "",
                    "year": "",
                    "pages": ""
                },
                "conference":{
                    "name":"",
                    "place":"",
                    "date":""
                },
                "DOI": "",
                "publisher":"",
                "type":"",
                "project":"",
                "reviewed":"",
                "open":""

            },
            "links": {