Bonjour à tous!

Voilà mon petit problème:

J'exporte un fichier excel (xls) vers ma base de données (Mysql) via PHP. Jusque là tout va bien.
mais seul les données rentrés 'à la main' sont insérées, les données résultant d'une formule elles ne le sont pas!!!!! o_O
D'où cela peut il venir?

Merci d'avance!

Extrait du code:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
 
$data2G = new Spreadsheet_Excel_Reader("/exec/users/dao_urso/www/php/fichierexcel/".$_SESSION['monfichier'].""); /* Analyse du fichier XLS  */
 
echo "ouverture des fichiers réussie<br>";
 
$requete = array(array());
$j=0;
$tache = array();
$id_prev = false;
$num = -1;
 
for ( $i=1; $i<=$data2G->sheets[1]['numRows']; $i++)
{
			$requete[$j][0] = utf8_decode($data2G->sheets[1]['cells'][$i][1]);			
			$requete[$j][1] = utf8_decode($data2G->sheets[1]['cells'][$i][2]);
			$requete[$j][2] = utf8_decode($data2G->sheets[1]['cells'][$i][3]);
			$requete[$j][3] = utf8_decode($data2G->sheets[1]['cells'][$i][4]);
			$requete[$j][4] = utf8_decode($data2G->sheets[1]['cells'][$i][5]);
			$requete[$j][5] = utf8_decode($data2G->sheets[1]['cells'][$i][6]);
			$requete[$j][6] = cvtDate2SQL(utf8_decode($data2G->sheets[1]['cells'][$i][7]));
			$requete[$j][7] = utf8_decode($data2G->sheets[1]['cells'][$i][8]);
			$requete[$j][8] = cvtDate2SQL(utf8_decode($data2G->sheets[1]['cells'][$i][9]));
			$requete[$j][9] = utf8_decode($data2G->sheets[1]['cells'][$i][10]);
			$requete[$j][10] = utf8_decode($data2G->sheets[1]['cells'][$i][11]);
			$requete[$j][11] = utf8_decode($data2G->sheets[1]['cells'][$i][12]);			
			$requete[$j][12] = utf8_decode($data2G->sheets[1]['cells'][$i][13]);
			$requete[$j][13] = utf8_decode($data2G->sheets[1]['cells'][$i][14]);
			$requete[$j][14] = utf8_decode($data2G->sheets[1]['cells'][$i][15]);
			$requete[$j][15] = utf8_decode($data2G->sheets[1]['cells'][$i][16]);
			$requete[$j][16] = utf8_decode($data2G->sheets[1]['cells'][$i][17]);
			$requete[$j][17] = utf8_decode($data2G->sheets[1]['cells'][$i][18]);
			$requete[$j][18] = cvtDate2SQL(utf8_decode($data2G->sheets[1]['cells'][$i][19]));
			$requete[$j][19] = utf8_decode($data2G->sheets[1]['cells'][$i][20]);
			$requete[$j][20] = utf8_decode($data2G->sheets[1]['cells'][$i][21]);
			$requete[$j][21] = utf8_decode($data2G->sheets[1]['cells'][$i][22]);
			$requete[$j][22] = utf8_decode($data2G->sheets[1]['cells'][$i][23]);
			$requete[$j][23] = utf8_decode($data2G->sheets[1]['cells'][$i][24]);
			$requete[$j][24] = utf8_decode($data2G->sheets[1]['cells'][$i][25]);
			$j++;	
}
foreach($requete as $value) 
{
		$num++;
		$tache[$num]['Region'] = $value[0];
		$tache[$num]['Cluster'] = $value[1];
		$tache[$num]['ZA'] = $value[2];
		$tache[$num]['NIDT'] = $value[3];
		$tache[$num]['NomSite'] = $value[4];
		$tache[$num]['Techno'] = $value[5];
		$tache[$num]['DatedeSwap'] = $value[6];
		$tache[$num]['Semainedeswap'] = $value[7];
		$tache[$num]['Datevalidation'] = $value[8];
		$tache[$num]['semaineproposee'] = $value[9];
		$tache[$num]['nbdejoursproposes'] = $value[10];
		$tache[$num]['Process48hE'] = $value[11];
		$tache[$num]['Etat'] = $value[12];
		$tache[$num]['Validation'] = $value[13];
		$tache[$num]['TOC'] = $value[14];
		$tache[$num]['Commentaire'] = $value[15];
		$tache[$num]['Responsable'] = $value[16];
		$tache[$num]['Impact'] = $value[17];
		$tache[$num]['ValidationOFR'] = $value[18];
		$tache[$num]['Semainedevalidation'] = $value[19];
		$tache[$num]['Nbdejourouvre48hOK'] = $value[20];
		$tache[$num]['Process48h'] = $value[21];
		$tache[$num]['CommentairesOFR'] = $value[22];
		$tache[$num]['DEMANDEssv'] = $value[23];
		$tache[$num]['KPI'] = $value[24];	
}