java导出excel

    技术2022-07-13  82

    HSSFWorkbook wb = new HSSFWorkbook();

    HSSFSheet sheet = wb.createSheet("table"); 

    Object[][] datas = {{"标题1", "标题2", "标题3"}, {"数值1" , 2,  3}, {"数值4", 5, 6}};

    HSSFRow row;

    HSSFCell cell;

    for(int i = 0; i < datas.length; i++) {

        row = sheet.createRow(i);

        for(int j = 0; j < datas[i].length; j++) {

            cell = row.createCell(j);

            cell.setCellValue(String.valueOf(datas[i][j]));

        }

    }

    wb.write(new FileOutputStream("/Users/mike/table.xls"));  

    Processed: 0.151, SQL: 10