java导出excel表格
import jxl.Workbook
import jxl.write.Label
import jxl.write.WritableCellFormat
import jxl.write.WritableFont
import jxl.write.WritableSheet
import jxl.write.WritableWorkbook
import jxl.write.Number
public void test(){
try {
WritableWorkbook book = Workbook.createWorkbook(new File("D://test.xls"))
WritableSheet sheet = book.createSheet("六科成绩", 0)
sheet.mergeCells(0, 0, 5, 0)
WritableFont bold = new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD)
WritableCellFormat titleFormate = new WritableCellFormat(bold)
titleFormate.setAlignment(jxl.format.Alignment.CENTRE)
titleFormate.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE)
Label title = new Label(0,0,"成绩说明",titleFormate)
sheet.setRowView(0, 600, false)
sheet.addCell(title)
int col = 0
int row = 1
sheet.addCell(new Label(col++, row, "语文"))
sheet.addCell(new Label(col++, row, "数学"))
sheet.addCell(new Label(col++, row, "英语"))
sheet.addCell(new Label(col++, row, "物理"))
sheet.addCell(new Label(col++, row, "化学"))
sheet.addCell(new Label(col++, row, "生物"))
for(row = 2
col = 0
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
sheet.addCell(new Number(col++, row, (int)(Math.random()*100)))
row++
}
book.write()
book.close()
} catch (Exception e) {
e.printStackTrace()
}
}
结果如下图