Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // create and write new file *.xls
- private void writeFileExcel(String filePath, Object[][] data) {
- WritableWorkbook workbook;
- // create workbook
- try {
- workbook = Workbook.createWorkbook(new File(filePath));
- // create sheet
- WritableSheet sheet1 = workbook.createSheet("KTPM K10B", 0);
- // create Label and add to sheet
- sheet1.addCell(new Label(0, 0, "DANH SÁCH SINH VIÊN TIÊU BIỂU"));
- // row begin write data
- int rowBegin = 2;
- int colBegin = 0;
- for (int row = rowBegin, i = 0; row < data.length + rowBegin; row++, i++) {
- for (int col = colBegin, j = 0; col < data[0].length + colBegin; col++, j++) {
- Object obj = data[i][j];
- // write a string to cell
- if (obj instanceof String)
- sheet1.addCell(new Label(col, row, (String) data[i][j]));
- // write a integer number to cell
- else if (obj instanceof Integer)
- sheet1.addCell(new Number(col, row,
- (Integer) data[i][j]));
- // write a double number to cell
- else if (obj instanceof Double)
- sheet1.addCell(new Number(col, row, (Double) data[i][j]));
- }
- }
- // write file
- workbook.write();
- // close
- workbook.close();
- } catch (IOException e) {
- System.out.println("Error create file\n" + e.toString());
- } catch (RowsExceededException e) {
- System.out.println("Error write file\n" + e.toString());
- } catch (WriteException e) {
- System.out.println("Error write file\n" + e.toString());
- }
- System.out.println("create and write success");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement