Java实现Excel表格数据导出教程

private byte[] dataToExcel(ResultSet rs,String taskId,String name,DBPool db) throws Exception {  
              
            ResultSetMetaData rsmd=rs.getMetaData();  
              
            try {  
              // 创建工作薄  
              ByteArrayOutputStream byteOut = new ByteArrayOutputStream();  
                
              WritableWorkbook wwb =Workbook.createWorkbook(byteOut);  
                
              int row = 1;                      //记录数  
              int sheetCount = 1;               //工作表数  
              // 创建工作表  
              while(true){  
                  WritableSheet ws = wwb.createSheet(name+sheetCount, sheetCount-1);  
      
                  int colCount = rsmd.getColumnCount();// 结果集中列的总数  
      
                  // 标题样式  
                  WritableFont font = new WritableFont(WritableFont.TAHOMA, 9, WritableFont.BOLD);// 定义字体  
                  font.setColour(Colour.BLACK);// 字体颜色  
                  WritableCellFormat wc = new WritableCellFormat(font);  
                  wc.setAlignment(Alignment.LEFT); // 设置左对齐  
                  wc.setBorder(Border.ALL, BorderLineStyle.THIN); // 设置边框线  
                  wc.setBackground(jxl.format.Colour.BLUE_GREY); // 设置单元格的背景颜色  
      
                  ws.setRowView(0, 250); // 设置第一行的行高  
                  for (int i = 1; i <= colCount; i++) {  
                      ws.setColumnView(i - 1, 20);// 设置列宽  
                      ws.addCell(new Label(i - 1, 0, rsmd.getColumnName(i), wc));