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());
} |
Partager