急急急，谁知道怎么用java生成excel报表？

[clapton]

如有现成的代码更好，多谢

在线等

[ihyinger]

从网上下载jxl组件。然后用下面的方法即可

//生成设备使用情况报表方法
private void PrintExcal(String result) {
try {
WritableWorkbook workbook = Workbook.createWorkbook(new File(result));
WritableSheet sheet = workbook.createSheet("First Sheet", 0);
// 定义18号字体
WritableFont arial18font = new WritableFont(WritableFont.ARIAL, 18);
WritableCellFormat arial18format = new WritableCellFormat(arial18font);
//定义14号字体
WritableFont arial14font = new WritableFont(WritableFont.ARIAL, 14);
WritableCellFormat arial14format = new WritableCellFormat(arial14font);

jxl.write.Label label = new jxl.write.Label(0, 1, "DCN设备使用情况月表",
arial18format);
try {
sheet.addCell(label);
label = new jxl.write.Label(0, 3,
MonthInputYear.getText() + "年" +
MonthInputMonth.getText() + "月",
arial14format);
sheet.addCell(label);
label = new jxl.write.Label(4, 3, "填表单位:" + EUSPDepName.getText(),
arial14format);
sheet.addCell(label);