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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
import java.io.FileInputStream;
import java.io.FileWriter;
import java.io.InputStream;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.stream.StreamSupport;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
public class Main {
public static void main(String[] args) throws Exception {
ReadXml fich= new ReadXml();
List <String> listenom = fich.extraire_nom("malab.xml");
List <String> listetemps = fich.extraire_intervalle("malab.xml");
List<String> listefunction=fich.extraire_function("malab.xml");
String path = "CallTraceinfo.xls";
List<String> ranapdl= new java.util.ArrayList<>();
List<String> ranapul= new java.util.ArrayList<>();
List<String> ranap= new java.util.ArrayList<>();
List<String> rnsapdl= new java.util.ArrayList<>();
List<String> rnsapul= new java.util.ArrayList<>();
List<String> rnsap= new java.util.ArrayList<>();
List<String> nbapdl= new java.util.ArrayList<>();
List<String> nbapul= new java.util.ArrayList<>();
List<String> nbap= new java.util.ArrayList<>();
List<String> rrcdl= new java.util.ArrayList<>();
List<String> rrcul= new java.util.ArrayList<>();
List<String> rrc= new java.util.ArrayList<>();
List<String> vide= new java.util.ArrayList<>();
excelreader ex=new excelreader("CallTraceinfo.xls",vide,ranapdl,ranapul,ranap,rnsapdl,rnsapul,rnsap,rrcdl,rrcul,rrc,nbapdl,nbapul,nbap);
List<String> videe=ex.getvide_list();
List<String> ranapdle=ex.getranapdl_list();
List<String> ranapule=ex.getranapul_list();
List<String> ranape=ex.getranap_list();
List<String> rnsapdle=ex.getrnsapdl_list();
List<String> rnsapule=ex.getrnsapul_list();
List<String> rnsape=ex.getrnsap_list();
List<String> rrcdle=ex.getrrcdl_list();
List<String> rrcule=ex.getrrcul_list();
List<String> rrce=ex.getrrc_list();
List<String> nbapdle=ex.getnbapdl_list();
List<String> nbapule=ex.getnbapul_list();
List<String> nbape=ex.getnbap_list();
FileWriter fichier = new FileWriter("monFichier.txt");
PrintWriter pw = new PrintWriter(fichier);
int j;
pw.println("============================================ CALL FLOW =============================================" + "\n");
pw.println("time UE NodeB DRNC SRNC CN"+ "\n" );
pw.println(" " +"| | | | | SnapshotCNode File Infos"+ "\n");
for (int i = 0 ;i<=listenom.size();i++){
String name=listenom.get(i).toString();
InputStream inputStream = new FileInputStream("CallTraceinfo.xls");
Workbook workbook = WorkbookFactory.create(inputStream);
Sheet sheet= workbook.getSheet("Call Trace");
StreamSupport.stream(sheet.spliterator(), false) // parcours des lignes
.skip(1) // on saute la ligne de titres
.map(row-> row.getCell(1)) // on prend la colonne 1 (name)
.forEach(cell-> {
switch(cell.getCellTypeEnum()) { // selon le type
case STRING: // si String, on lit comme String
Row r=cell.getRow();
String function=r.getCell(0).toString();
String ff=listefunction.get(i); ////c est ou le probleme
if (name.equalsIgnoreCase(cell.getStringCellValue().toString())&& function.equalsIgnoreCase(ff))
{
Row rr= cell.getRow();
String fulln= rr.getCell(3).toString();
if (true==videe.contains(fulln)){
pw.println(" " +"| | | | | "+ "\n");
}
else if (true==ranapdle.contains(fulln)){
pw.println(" " +"| | | |<----| "+ "\n");
}
else if (true==ranapule.contains(fulln)){
pw.println(" " +"| | | |---->| "+ "\n");
}
else if (true==ranape.contains(fulln)){
pw.println(" " +"| | | |-----| "+ "\n");
}
else if (true==rnsapdle.contains(fulln)){
pw.println(" " +"| | |<----| | "+ "\n");
}
else if (true==rnsapule.contains(fulln)){
pw.println(" " +"| | |---->| | "+ "\n");
}
else if (true==rnsape.contains(fulln)){
pw.println(" " +"| | |-----| | "+ "\n");
}
else if (true==rrcdle.contains(fulln)){
pw.println(" " +"|<----------| | | "+ "\n");
}
else if (true==rrcule.contains(fulln)){
pw.println(" " +"|---------->| | | "+ "\n");
}
else if (true==rrce.contains(fulln)){
pw.println(" " +"|-----------| | | "+ "\n");
}
else if (true==nbapdle.contains(fulln)){
pw.println(" " +"| |<----| | | "+ "\n");
}
else if (true==nbapule.contains(fulln)){
pw.println(" " +"| |---->| | | "+ "\n");
}
else if (true==nbape.contains(fulln)){
pw.println(" " +"| |-----| | | "+ "\n");
}
}
break;
case BLANK: // si vide on lit comme null
System.out.println("vide");
break;
default :
// do nothing
}
});
}}
} |
Erreur dans la récupération d'un élément d'une liste
Répondre avec citation
Partager