Export JSON array to MS Excel

index.html

<script type='text/javascript' src='script.js'></script>

<a id="test" href="">Test.xls</a>

script.js

// Test script to generate a file from JavaScript such
// that MS Excel will honor non-ASCII characters.

testJson = [
    {
        "name": "Tony Peña",
        "city": "New York",
        "country": "United States",
        "birthdate": "1978-03-15",
        "amount": 42

    },
    {
        "name": "Ζαλώνης Thessaloniki",
        "city": "Athens",
        "country": "Greece",
        "birthdate": "1987-11-23",
        "amount": 42
    }
];

// Simple type mapping; dates can be hard
// and I would prefer to simply use `datevalue`
// ... you could even add the formula in here.
testTypes = {
    "name": "String",
    "city": "String",
    "country": "String",
    "birthdate": "String",
    "amount": "Number"
};

emitXmlHeader = function () {
	return '<?xml version="1.0"?>\n' +
		   '<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">\n' +
		   '<ss:Worksheet ss:Name="Sheet1">\n' +
		   '<ss:Table>\n\n';
};

emitXmlFooter = function() {
	return '\n</ss:Table>\n' +
		   '</ss:Worksheet>\n' +
		   '</ss:Workbook>\n';
};

jsonToSsXml = function (jsonObject, testTypes) {
	var row;
	var col;
	var xml;
	var data = typeof jsonObject != "object"
			 ? JSON.parse(jsonObject)
			 : jsonObject;

	var data_header = typeof testTypes != "object"
			 ? JSON.parse(testTypes)
			 : testTypes;

	xml = emitXmlHeader();

	xml += '<ss:Row>\n';
	$.each(data_header, function(index, value) {

		xml += '  <ss:Cell>\n';
		xml += '    <ss:Data ss:Type="String">';
		xml += index + '</ss:Data>\n';
		xml += '  </ss:Cell>\n';

	});
	xml += '</ss:Row>\n';

	for (row = 0; row < data.length; row++) {
		xml += '<ss:Row>\n';

		for (col in data[row]) {
			xml += '  <ss:Cell>\n';
			xml += '    <ss:Data ss:Type="' + testTypes[col]  + '">';
			xml += data[row][col] + '</ss:Data>\n';
			xml += '  </ss:Cell>\n';
		}

		xml += '</ss:Row>\n';
	}

	xml += emitXmlFooter();
	return xml;
};

download = function (content, filename, contentType) {
	if (!contentType) contentType = 'application/octet-stream';
	var a = document.getElementById('export');
	var blob = new Blob([content], {
		'type': contentType
	});
	a.href = window.URL.createObjectURL(blob);
	a.download = filename;
};

Hey am trying to work with this script and I am having a challenge triggering the script to work for or where could I be going wrong.

Hey am trying to work with this script and I am having a challenge triggering the script to work for or where could I be going wrong.

Hi, I haven't used this script for a while, could you show me what error it generates?

Hey sorry for the late reply, well the thing is not even the error but rather getting it to work or rather it does not get triggered yet I place the codes in the files as you had separated them. Thanks , Antony

…

On Fri, Sep 3, 2021 at 4:57 PM Faber Andrés Vergara Holguín < ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Hey am trying to work with this script and I am having a challenge triggering the script to work for or where could I be going wrong. Hi, I haven't used this script for a while, could you show me what error it generates? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://gist.github.com/11182654#gistcomment-3881515>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALY3WYHGKCNKDR4ZHEFF53DUADH5NANCNFSM5DLT3HXQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.