java导出excel表格

最新推荐文章于 2024-04-17 14:52:54 发布

bpqdwo

最新推荐文章于 2024-04-17 14:52:54 发布

阅读量209

点赞数

分类专栏： excel表格文章标签： java excel

本文链接：https://blog.csdn.net/bpqdwo/article/details/79031735

版权

excel表格专栏收录该内容

0 篇文章 0 订阅

订阅专栏

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);//设置字体种类和黑体显示,字体为Arial,字号大小为10,采用黑体显示
                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;row < 10;){
                    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();
            }
     }