Voila je vous montre une partie simplifiée de mon programme cependant il y a une ou des erreurs que je n'arrive pas à voir ...
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
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 package tests; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.util.Iterator; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; public class CopyOfProgramme_final { public CopyOfProgramme_final() { super(); } public void findFiles(String directoryPath) throws FileNotFoundException, IOException { File directory = new File(directoryPath); File[] subfiles = directory.listFiles(); for(int i=0 ; i<subfiles.length; i++){ System.out.println(subfiles[i].getName()); POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("C:/test2/"+subfiles[i].getName())); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(1); for (Iterator<HSSFRow> rit = (Iterator<HSSFRow>)sheet.rowIterator(); rit.hasNext(); ) { HSSFRow row = rit.next(); HSSFCell cell = row.getCell((short)0); cell.getNumericCellValue(); HSSFCell cell2 = row.getCell((short)2); cell2.getStringCellValue(); HSSFCell cell3 = row.getCell((short)3); cell3.getStringCellValue(); HSSFCell cell4 = row.getCell((short)4); cell4.getStringCellValue(); HSSFCell cell5 = row.getCell((short)5); cell5.getStringCellValue(); HSSFCell cell6 = row.getCell((short)6); cell6.getStringCellValue(); HSSFCell cell7 = row.getCell((short)7); cell7.getStringCellValue(); HSSFCell cell8 = row.getCell((short)8); cell8.getDateCellValue(); HSSFCell cell9 = row.getCell((short)9); cell9.getStringCellValue(); HSSFCell cell10 = row.getCell((short)10); cell10.getStringCellValue(); HSSFCell cell11 = row.getCell((short)11); cell11.getStringCellValue(); HSSFCell cell12 = row.getCell((short)12); cell12.getStringCellValue(); HSSFCell cell13 = row.getCell((short)13); cell13.getStringCellValue(); HSSFCell cell14 = row.getCell((short)14); cell14.getStringCellValue(); HSSFCell cell15 = row.getCell((short)15); cell15.getStringCellValue(); HSSFCell cell16 = row.getCell((short)16); cell16.getStringCellValue(); HSSFCell cell17 = row.getCell((short)17); cell17.getStringCellValue(); HSSFCell cell18 = row.getCell((short)18); cell18.getStringCellValue(); HSSFCell cell19 = row.getCell((short)19); cell19.getStringCellValue(); HSSFCell cell20 = row.getCell((short)20); cell20.getDateCellValue(); HSSFCell cell21 = row.getCell((short)21); cell21.getDateCellValue(); HSSFCell cell22 = row.getCell((short)22); cell22.getStringCellValue(); HSSFCell cell23 = row.getCell((short)23); cell23.getDateCellValue(); HSSFCell cell24 = row.getCell((short)24); cell24.getStringCellValue(); HSSFCell cell25 = row.getCell((short)25); cell25.getStringCellValue(); HSSFCell cell26 = row.getCell((short)26); cell26.getStringCellValue(); System.out.println(cell); } HSSFSheet sheet2 = wb.getSheetAt(2); for (Iterator<HSSFRow> rit2 = (Iterator<HSSFRow>)sheet2.rowIterator(); rit2.hasNext(); ) { HSSFRow row2 = rit2.next(); HSSFCell nom_HDR = row2.getCell((short)1); nom_HDR.getStringCellValue(); HSSFCell prenom_HDR = row2.getCell((short)2); prenom_HDR.getStringCellValue(); //HSSFCell matricule_HDR = row.getCell((short)3); //matricule_HDR.getStringCellValue(); HSSFCell grade_HDR = row2.getCell((short)3); grade_HDR.getStringCellValue(); HSSFCell HDR_doctorat = row2.getCell((short)6); HDR_doctorat.getStringCellValue(); HSSFCell etablisement_delivrance = row2.getCell((short)7); etablisement_delivrance.getStringCellValue(); System.out.println(nom_HDR); } } } public static void main(String[] args) throws FileNotFoundException, IOException { CopyOfProgramme_final finder = new CopyOfProgramme_final(); finder.findFiles("C:/test2"); } }
L'erreur que me retourne Eclipse :
Exception in thread "main" java.lang.NullPointerException
at tests.CopyOfProgramme_final.findFiles(CopyOfProgramme_final.java:42)
at tests.CopyOfProgramme_final.main(CopyOfProgramme_final.java:118)
Sachant que la ligne 42 est celle ci :
cell.getNumericCellValue();
Sachant que la ligne 118 est celle ci :
finder.findFiles("C:/test2");
Merci de votre aide ...
Partager