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 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103
| <!DOCTYPE html>
<html lang="fr" dir="ltr">
<head>
<meta http-equiv="cache-control" content="public, max-age=60">
<meta charset="utf-8">
<meta name="viewport" content="initial-scale=1.0">
<meta name="author" content="Daniel Hagnoul">
<title>Test</title>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.11.4/themes/sunny/jquery-ui.css">
<style>
</style>
<script src="http://code.jquery.com/jquery-2.1.4.min.js"></script>
<script src="http://code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<script>
"use strict";
function exportTableToCSV( $table, filename ) {
var
$rows = $table.find('tr'),
tmpColDelim = String.fromCharCode( 11 ), // vertical tab character
tmpRowDelim = String.fromCharCode( 0 ), // null character
colDelim = '";"',
rowDelim = '"\r\n"',
csv = '"' + $rows.map( function( i, row ){
var
$row = $(row),
$cols = $row.children();
return $cols.map( function( j, col ){
var
$col = $( col ),
text = $col.text();
return text.replace( /"/g, '""' ); // escape double quotes
})
.get()
.join( tmpColDelim );
})
.get()
.join( tmpRowDelim )
.split( tmpRowDelim )
.join( rowDelim )
.split( tmpColDelim )
.join( colDelim ) + '"',
csvData = 'data:application/csv;charset=utf-8,' + encodeURIComponent(csv);
$( this ).attr({
'download' : filename,
'href' : csvData
});
// debug
console.log( csv );
}
$( function(){ // forme abrégée de $(document).ready(function(){
});
$( window ).load( function(){
$( "#export" ).on( "click", function( event ){
var outputFile = window.prompt("Nom du fichier : ") || 'export';
outputFile = outputFile.replace('.csv','') + '.csv'
exportTableToCSV.apply( this, [ $( '#table_result' ), outputFile ] );
});
});
</script>
</head>
<body>
<div>
<a href="#" id="export" role='button'>Export The Table Data into a CSV File</a>
</div>
<table id="table_result" border="2">
<tbody>
<tr bgcolor="oldlace">
<th class=""></th>
<th colspan="2">Distribution for all categories entityX by sphereN / all sphere all entities</th>
<th colspan="2">distribution for all categories for each entity by sphereN</th>
</tr>
<tr bgcolor="oldlace">
<th class="">
<div class="">
<a href="">Entity</a>
</div>
</th>
<th class="">Inside</th>
<th class="">Outside</th>
<th class="">Inside</th>
<th class="">Outside</th>
</tr>
<tr>
<td> contruction dynamique</td>
</tr>
</tbody>
</table>
</body>
</html> |
Partager