1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
|
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title> exporter csv </title>
<script type="text/javascript">
function jsonTblCsv(tbl) {
tbl=tbl||[];
var ret = '';
for (var i = 0; i < tbl.length; i++) {
var ligne = '';
for (var index in tbl[i]) {
if (ligne != '') line += ','
ligne += "\""+tbl[i][index]+"\"";
}
ret += ligne + '\r\n';
}
return ret;
}
function exportCSV(csv,nomFichier)
{
var uri = 'data:text/csv;charset=utf-8,' + escape(csv);
var downloadLink = document.createElement("a");
if("download" in downloadLink){
downloadLink.href = uri;
downloadLink.download = nomFichier + ".csv";
document.body.appendChild(downloadLink);
downloadLink.click();
document.body.removeChild(downloadLink);
}else{
if (/MSIE/gi.test(navigator.userAgent)) {
var obj = window.open();
obj.document.write('sep=,\r\n' + csv);
obj.document.close();
obj.document.execCommand('SaveAs', true, nomFichier + ".csv");
obj.close();
}
}
}
function testExportCsv(){
var nomFicher=prompt("entrer nom de ficher","test");
var testJson=[
{nom:"le nom"},
{nom:"le prenom"},
{nom:"le nom1"},
{nom:"le prenom1"}
];
var testCsv=jsonTblCsv(testJson);
exportCSV(testCsv,nomFicher);
}
</script>
</head>
<body>
<button onclick="testExportCsv()" >tester export CSV</button>
</body>
</html> |
Partager