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
|
//pour la table critere ergonomique
public void parcoursCelluleFeuilleFichierExcel119(int numeroFeuille) {
// on obtient le nom du numero de la feuille du classeur a parcourir
String sheetName = wb.getSheetName(numeroFeuille);
System.out.println("\n\r\n\rSheet: " + sheetName);
// retourne la feuille de l'index spécifié
HSSFSheet sheet = wb.getSheetAt(numeroFeuille);
HSSFRow row;
HSSFRow row2;
//les lignes en dur a récuperer de la feuille excel
int[] colonnes = new int[]{2,3,4,5,6,8,9,10,11,14,15,16,17,18,20,21,22,23,24,25,
27,28,29,32,33,34,35,36,37,40,41,42,43,45,46,47,48,49,
50,52,53,55,56,57,59,60,61,62,63,64,65,66,67,68,69,
71,72,75,76,77,78,79,80,82,83,84,85,86,87,88,89,90,91,93,94,96,97,98,99,
102,103,104,105,108,109,111,112,115,116,117,118,120,121,122,123,125,126,128,131,132,133,
136,137,138,139,142,143,144,147,148,149,150,151,152,153,155,156,159,160,161,162,163,166,167,
168,169,171,172,173,174,175,177,178,181,182,183,184,185,186,187,188,189,190,193,194,195,198,199,200,
201,204,205,208,209,210,211,212,213,214,215,216,217,218,221,222,223,224,226,227,229,231,
232,233,234,235,236,237,238,239,240,241,243,244,246,247,248,249,250,251,252,253,254,255,
256,258,259,262,263,265,266,267,268,269,270,273,274,275,276,277,278,279,280,281,284,285,286,287,288
,290,291,293,294,295,297,298,301,302,303,304,306,307,308,309,310,311,312,313,314,315,316,
317,320,321,322,323,324,325,328,330,331,334,335,338,339,340,341,342,345,346,347,348,351,353,
354,356,357,360,361,362,363,364,365,368,369,370,373,374,375,376,378,379,382,383,386,388,389,391};
//pour recuperer les criteres
int[] colonnes1 = new int[]{3,5,6,9,10,11,15,16,18,21,22,23,24,25,
28,29,33,35,37,41,43,46,47,49,50,53,55,57,60,61,62,64,65,66,67,69,
72,76,78,80,82,83,85,87,89,90,94,96,98,99,
104,105,109,111,112,116,117,118,121,122,123,125,132,133,
137,138,143,144,148,150,151,153,155,156,160,161,162,163,167,
168,169,172,173,175,178,182,184,186,188,194,195,199,200,
204,205,209,210,211,213,215,216,218,222,223,224,226,227,231,
233,234,236,238,240,241,244,246,248,249,251,253,255,
256,263,266,267,269,270,274,276,277,279,281,285,287,288
,291,295,302,304,307,309,310,311,313,314,315,316,
317,321,323,325,328,335,339,340,342,347,348,353,
361,362,363,365,370,374,375,379,383,386};
//parcours premier tableau
for (int col : colonnes ) {
// recupere ligne j de la feuille(numeroFeuille)
row = sheet.getRow(col);
if (row != null ) {
// pour la ligne
System.out.print("\r\nRow " + col + ": ");
// recuperation de(s) colonne(s) souhaité pour la ligne i c'est a dire subscenarid et le commentaire
HSSFCell cell1 = row.getCell(0);//subid
HSSFCell cell3 = row.getCell(7);//commentaire
//affiche les cellules souhaités de la ligne i
System.out.print(ContenuCellule(cell1) + "\t"); //affiche
System.out.print(ContenuCellule(cell3)+"\t");
//pour convertir en int
double en = cell1.getNumericCellValue();
int n=(int)en;
//appelle la methode qui possede la table a inserer
db_connection.insertCritereErgonomique(n,cell3.getRichStringCellValue().toString());
}// fin if for row
}// fin for |
