AlaSql export data as csv
HTML
<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.4.11/alasql.min.js"></script>
<button onclick="window.exportData()">Export array data to CSV file</button>
<button onclick="window.exporJsontData()">Export json data to CSV file</button>
JavaScript
var data = [
["FirstName", "LastName"],
["Alan", "Tsai"],
["John", "Doe"]
];
var jsonData = [{
"FirstName": "Alan",
"LastName": "Tsai"
}, {
"FirstName": "John",
"LastName": "Doe"
}]
window.exportData = function exportData() {
alasql("SELECT * INTO CSV('names.csv') FROM ?", [data]);
}
window.exporJsontData = function exporJsontData() {
alasql("SELECT * INTO CSV('names.csv',{headers:true}) FROM ?", [jsonData]);
}