jsp页面上查询结果导入到EXCEL表里_jsp从数据库中查询数据导入到excel-优快云博客

本文介绍了一个使用Java jxl库进行Excel文件创建的具体实例。该示例代码展示了如何设置Excel表格标题，填充数据行，并调整字体样式等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

File filefullname = new File(path);
   jxl.write.WritableWorkbook wwb;
   wwb = Workbook.createWorkbook(filefullname);
   jxl.write.WritableSheet ws = wwb.createSheet("sheet1", 10);
   int index = title.length;// title的长度
   for (int i = 0; i < index; i++) {
    ws.addCell(new jxl.write.Label(i, 0, title[i]));
   }
   BASE_BILL[] BASE_BILL = new BASE_BILL[arraylist.size()];
   for (int k = 0; k < arraylist.size(); k++) {
    BASE_BILL[k] = (BASE_BILL) arraylist.get(k);
    ws.addCell(new jxl.write.Label(0, k + 1, String.valueOf(BASE_BILL[k].getSid())));
    ws.addCell(new jxl.write.Label(1, k + 1, BASE_BILL[k].getBill_code_parent()));
    ws.addCell(new jxl.write.Label(2, k + 1, BASE_BILL[k].getBill_code()));
    ws.addCell(new jxl.write.Label(3, k + 1, BASE_BILL[k].getTaggroup_id()));
    ws.addCell(new jxl.write.Label(4, k + 1, BASE_BILL[k].getTpe_status_dspname()));
    ws.addCell(new jxl.write.Label(5, k + 1, BASE_BILL[k].getStarttime()));
    ws.addCell(new jxl.write.Label(6, k + 1, BASE_BILL[k].getEndtime()));

   }
   jxl.write.WritableFont wfc = new jxl.write.WritableFont(
     WritableFont.ARIAL, 255, WritableFont.BOLD, false,
     UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
   jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(
     wfc);
   wwb.write();
   // 关闭Excel工作薄对象
   wwb.close();