Export calcul dynamique sous excel
Bonsoir a toutes et tous,
le code javascript fonctionne nickel, merci a tous ceux qui sont intervenus !!!
Le soucis du jour, c'est de pouvoir exporter les données saisis par les intenautes sous Excel.
le code ci-dessous est la page principale
Code:
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
|
<html>
<head>
<title>Plan de Formation</title>
<script type="text/javascript" src="table.js"></script>
<link rel="stylesheet" type="text/css" href="tablesynthese.css" media="all">
<script language="JavaScript">
<!--
function delta(IdFormation)
{
var sum = ''; num1 = 0; num2 = 0; num3 = 0; num4 = 0; num5 = 0;
if (document.forms[IdFormation].elements[0].value != '')
{
num1 = parseInt(document.forms[IdFormation].elements[0].value,10);
}
if (document.forms[IdFormation].elements[1].value != '')
{
num2 = parseInt(document.forms[IdFormation].elements[1].value,10);
}
if (document.forms[IdFormation].elements[2].value != '')
{
num3 = parseInt(document.forms[IdFormation].elements[2].value,10);
}
if (document.forms[IdFormation].elements[3].value != '')
{
num4 = parseInt(document.forms[IdFormation].elements[3].value,10);
}
if (document.forms[IdFormation].elements[4].value != '')
{
num5 = parseInt(document.forms[IdFormation].elements[4].value,10);
}
sum = num1 - num2 - num3 - num4 - num5;
document.forms[IdFormation].elements[5].value = parseInt(sum);
document.forms[IdFormation].elements[5].style.backgroundColor=(parseInt(sum)!=0)?'red':'green';
}
//-->
</script>
</head>
<?php
include 'xxxxxxx/xxxxxxx/formations.php';
include 'xxxxxxx/xxxxxxx/config.php';
?>
<?php
// On commence par récupérer les champs
$form001=$_POST['form001'];
etc..
$form200=$_POST['form200'];
?>
<body>
<table width="98%" align="center" class="example table-autosort:0 table-stripeclass:alternate">
<thead>
<tr>
<th class="table-sortable:default"> </th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Nombre de personnes</font></div></th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">AS / AQS</font></div></th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Employé</font></div></th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Maîtrise et Technicien</font></div></th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Ingénieur et Cadre</font></div></th>
<th width="12%" class="table-sortable:default"><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Effectif OK si égale à 0</font></div></th>
</tr>
</thead>
<tbody class="table-nosort">
</tbody>
<tbody>
<?php if ($form001=="oui") { include 'formation001.php';} ?>
<?php if ($form002=="oui") { include 'formation002.php';} ?>
<?php if ($form003=="oui") { include 'formation003.php';} ?>
<?php if ($form004=="oui") { include 'formation004.php';} ?>
etc..
<?php if ($form200=="oui") { include 'formation200.php';} ?>
</tbody>
</table>
<div align="center"><br>
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Imprimer</font></div>
</body>
</html> |
code d'un include
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
<tr>
<td> <font color="#990033" size="2" face="Arial, Helvetica, sans-serif"><strong><em><?php echo $formation001 ; ?></em></strong></font></td>
<form name="formation001" method="post" action="">
<td><div align="center">
<input name="num1" type="text" id="num1" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
<td><div align="center">
<input name="num2" type="text" id="num2" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
<td><div align="center">
<input name="num3" type="text" id="num3" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
<td><div align="center">
<input name="num4" type="text" id="num4" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
<td><div align="center">
<input name="num5" type="text" id="num5" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
<td><div align="center">
<input name="somme" type="text" id="somme" onBlur="delta('formation001');" size="8" STYLE="text-align:center">
</div></td>
</form>
</tr> |
Comment mettre un bouton "telecharger le tableau pour Excel"
Merci
