Insertion de donnée-php-mysql-excel
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:D.
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:
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];
} |
