Bonjour,

j'arrive a effectuer la generation de mon fichier excel en fichier .csv mais le problème c'est que mon fichier excel est composé de 5 colonnes et j'aimerais seulement générer les deux premières colonnes.
Voici mon 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
 
 
public class XlsxtoCSV {
 
    static void xlsx(File inputFile, File outputFile) {
        // For storing data into CSV files
        StringBuffer data = new StringBuffer();
 
        try {
            FileOutputStream fos = new FileOutputStream(outputFile);
            // Get the workbook object for XLSX file
            XSSFWorkbook wBook = new XSSFWorkbook(new FileInputStream(inputFile));
            // Get first sheet from the workbook
            XSSFSheet sheet = wBook.getSheetAt(0);
            Row row;
            Cell cell = null;
 
            // Iterate through each rows from first sheet
            Iterator<Row> rowIterator = sheet.iterator();
 
            while (rowIterator.hasNext()) {
                row = rowIterator.next();
 
                // For each row, iterate through each columns
                Iterator<Cell> cellIterator = row.cellIterator();
                while (cellIterator.hasNext()) {
 
                	cell = cellIterator.next();
                	switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_BOOLEAN:
                            data.append(cell.getBooleanCellValue() + ",");
 
                            break;
                        case Cell.CELL_TYPE_NUMERIC:
                            data.append(cell.getNumericCellValue() + ",");
 
                            break;
                        case Cell.CELL_TYPE_STRING:
                            data.append(cell.getStringCellValue() + ",");
                            break;
 
                        case Cell.CELL_TYPE_BLANK:
                            data.append("" + ",");
                            break;
                        default:
                            data.append(cell + ",");
 
                    }
                }
            }
 
            fos.write(data.toString().getBytes());
            fos.close();
 
        } catch (Exception ioe) {
            ioe.printStackTrace();
        }
    }
    //testing the application 
 
    public static void main(String[] args) {
        //reading file from desktop
        File inputFile = new File("test.xlsx");
        //writing excel data to csv 
        File outputFile = new File("test1.csv");
        xlsx(inputFile, outputFile);
    }
}
merci