Jexcel Spreadsheet - Export to XLSX

Downl

by Spreadsheet Online

HTML

<script src="https://jexcel.net/v7/jexcel.js"></script>
<script src="https://jexcel.net/v7/jsuites.js"></script>
<link rel="stylesheet" href="https://jexcel.net/v7/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jexcel.net/v7/jexcel.css" type="text/css" />


<div id="spreadsheet"></div>

<form action='https://jexcel.net/api/download' method='post'>
<input type='hidden' id='data' name='data' value=''>
</form>

<script>
var data1 = [
    ['Cheese', 10, 6.00, "=B1*C1"],
    ['Apples', 5, 4.00, "=B2*C2"],
    ['Carrots', 5, 1.00, "=B3*C3"],
    ['Oranges', 6, 2.00, "=B4*C4"],
];
 
var data2 = [
    ['20%', "test1"],
    ['30%', "test2"],
];
 
var spreadsheet = jexcel(document.getElementById('spreadsheet'), [
    {
        data: data1,
        minDimensions: [10,10]
    },
    {
        data: data2,
        minDimensions: [10,10]
    }
]);


function download() {
    var data = [];
    for (var i = 0; i < spreadsheet.length; i++) {
        data.push(spreadsheet[i].getConfig());
    }

    document.getElementById('data').value = JSON.stringify(data);
    document.forms[0].submit();
}
</script>

<input type='button' value='download' onclick='download()'>