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
| WritableWorkbook workbookCopy = null;
WritableSheet sheet = null;
Workbook workbookIN = null;
workbookIN = Workbook.getWorkbook(new File("input.xls"));
workbookCopy = Workbook.createWorkbook(new File("output.xls"), workbookIN);
workbookCopy.copy(workbookIN);
workbookCopy.write();
// workbookCpy.close();
sheet = workbookCopy.getSheet(0);
String CodeLigne = "";
Number montCellule;
double mntValeur = 0.0D;
for (int i = 10; i < sheet.getRows(); i++) {
CodeLigne = sheet.getCell(0,i).getContents().toString();
if (CodeLigne != null && !CodeLigne.equals("")
&& mapValeur.containsKey(CodeLigne.trim())) {
System.out.println(CodeLigne + " : " + mapValeur.get(CodeLigne.trim()));
mntValeur = mapValeur.get(CodeLigne.trim());
montCellule = new Number(i, 3, mntValeur);
sheet.addCell(new Label(i, 3, mntValeur));
// sheet.
}
}
workbookCpy.write();
workbookCpy.close(); |
Partager