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
| StringBuffer cellValue = new StringBuffer();
try {
//FileOutputStream fos = new FileOutputStream(outputFile);
FileWriter fw = new FileWriter(outputFile);
BufferedWriter fos = new BufferedWriter(fw);
// Get the workbook instance for XLSX file
XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(inputFile));
// Get first sheet from the workbook
XSSFSheet sheet = wb.getSheetAt(0);
Row row;
Cell cell;
// 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:
cellValue.append(cell.getBooleanCellValue() + ";");
break;
/*case Cell.CELL_TYPE_NUMERIC:
cellValue.append(cell.getNumericCellValue() + ";");
break;*/
case Cell.CELL_TYPE_STRING:
cellValue.append(cell.getStringCellValue() + ";");
break;
case Cell.CELL_TYPE_BLANK:
cellValue.append("" + ";");
break;
default:
cellValue.append(cell + ";");
}
}
cellValue.append("\r\n"); // test add 2016_04_13__17:22
cellIterator = null;
}
fos.write(cellValue.toString());
fos.close();
} catch (Exception e) {
System.err.println("Exception :" + e.getMessage());
} |
SDK SAP BO 4.1 export CSV différent du rapport
Répondre avec citation
Partager