Advertisement
nguyenvanquan7826

read and write excel

Nov 23rd, 2014
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.52 KB | None | 0 0
  1. // create and write new file *.xls
  2.     private void writeFileExcel(String filePath, Object[][] data) {
  3.         WritableWorkbook workbook;
  4.         // create workbook
  5.         try {
  6.             workbook = Workbook.createWorkbook(new File(filePath));
  7.  
  8.             // create sheet
  9.             WritableSheet sheet1 = workbook.createSheet("KTPM K10B", 0);
  10.  
  11.             // create Label and add to sheet
  12.             sheet1.addCell(new Label(0, 0, "DANH SÁCH SINH VIÊN TIÊU BIỂU"));
  13.  
  14.             // row begin write data
  15.             int rowBegin = 2;
  16.             int colBegin = 0;
  17.  
  18.             for (int row = rowBegin, i = 0; row < data.length + rowBegin; row++, i++) {
  19.                 for (int col = colBegin, j = 0; col < data[0].length + colBegin; col++, j++) {
  20.  
  21.                     Object obj = data[i][j];
  22.                     // write a string to cell
  23.                     if (obj instanceof String)
  24.                         sheet1.addCell(new Label(col, row, (String) data[i][j]));
  25.                     // write a integer number to cell
  26.                     else if (obj instanceof Integer)
  27.                         sheet1.addCell(new Number(col, row,
  28.                                 (Integer) data[i][j]));
  29.                     // write a double number to cell
  30.                     else if (obj instanceof Double)
  31.                         sheet1.addCell(new Number(col, row, (Double) data[i][j]));
  32.                 }
  33.             }
  34.             // write file
  35.             workbook.write();
  36.  
  37.             // close
  38.             workbook.close();
  39.         } catch (IOException e) {
  40.             System.out.println("Error create file\n" + e.toString());
  41.         } catch (RowsExceededException e) {
  42.             System.out.println("Error write file\n" + e.toString());
  43.         } catch (WriteException e) {
  44.             System.out.println("Error write file\n" + e.toString());
  45.         }
  46.         System.out.println("create and write success");
  47.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement