Export page html vers Excel
/Html JavaSript/Export page html vers Excel.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
<head>
<meta http-equiv="Content-type" content="text/html; charset=iso-8859-1" />
<title>export Excel copy/paste</title>
<script type="text/javascript">
function exportExcel() {
// (!) IE only (because ActiveX and window.clipboardData)
if(!window.clipboardData){
alert("window.clipboardData non supporté, opération impossible.");
return;
}
// copie data dans clipboard :
var html = document.documentElement.innerHTML;
window.clipboardData.setData('Text', html);
//var word = new ActiveXObject("word.application");
//word.visible=true;
//var doc = word.documents.open("http://form10merge.doc");
var excel = new ActiveXObject("Excel.Application");
excel.visible=true;
var workbook = excel.Workbooks.Add();
workbook.Activate();
var worksheet = workbook.Worksheets(1); //("Sheet1");
worksheet.Activate();
worksheet.Paste();
}
</script>
</head>
<body>
<h1>Exporter une page html vers Excel via le clipboard :</h1>
<table border="1">
<caption>Associations</caption>
<tr>
<th>France</th>
<th>Belgique</th>
<th>Suisse</th>
</tr><tr>
<td>quatre-vingts</td>
<td>octante</td>
<td>huitante</td>
</tr><tr>
<td>serpillière</td>
<td>wassingue</td>
<td>panosse</td>
</tr>
</table>
<div>
<br />
<a href="javascript:exportExcel()">Exporter vers Excel</a> (IE only)
</div>
</body>
</html>