关于Excel的处理问题-入门级别

来源：互联网发布：excel vb 编辑：程序博客网时间：2024/06/14 20:00
关于Excel的处理问题-入门级别
一、核心代码：
//第一步,创建一个webbook,对应一个Excel文件HSSFWorkbook wb = new HSSFWorkbook();//第二步,在webbook中添加一个sheet页,对应Excel文件中的sheetHSSFSheet sheet = wb.createSheet("Report");//第三部,在sheet中添加表头第一行HSSFRow row = sheet.createRow(0);//第四部,创建单元格风格,设置表头居中HSSFCellStyle style = wb.createCellStyle();style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//创建一个居中格式//第五步,获取需要填充的数据:Purchase p = getPurchase();HSSFCell c0_5 = row.createCell(5);           c0_5.setCellValue(new HSSFRichTextString("XXXXX"));                           //创建第二行单元格       HSSFRow row1 = sheet.createRow(1);          HSSFCell c1_5 = row1.createCell(5);     c1_5.setCellValue(new HSSFRichTextString("采购单"));       //创建第三行单元格        HSSFRow row2 = sheet.createRow(2);          HSSFCell c2_0 = row2.createCell(0);     c2_0.setCellValue(new HSSFRichTextString("采购主题:"));   HSSFCell c2_2 = row2.createCell(2);     c2_2.setCellValue(new HSSFRichTextString(p.getPurchaseTheme()));  HSSFCell c2_11 = row2.createCell(11);     c2_11.setCellValue(new HSSFRichTextString("采购编号:"));  HSSFCell c2_14 = row2.createCell(14);     c2_14.setCellValue(new HSSFRichTextString(p.getPurchaseCode()));    //创建第四行单元格        HSSFRow row3 = sheet.createRow(3);          HSSFCell c3_0 = row3.createCell(0);     c3_0.setCellValue(new HSSFRichTextString("收货人:"));   HSSFCell c3_2 = row3.createCell(2);     c3_2.setCellValue(new HSSFRichTextString(p.getConsignee()));  HSSFCell c3_5 = row3.createCell(5);     c3_5.setCellValue(new HSSFRichTextString("下单时间:"));   HSSFCell c3_8 = row3.createCell(8);     c3_8.setCellValue(new HSSFRichTextString(p.getOrderTime()+""));  HSSFCell c3_11 = row3.createCell(11);     c3_11.setCellValue(new HSSFRichTextString("采购人:"));  HSSFCell c3_14 = row3.createCell(14);     c3_14.setCellValue(new HSSFRichTextString(p.getPurchaser()));      //创建第五行单元格        HSSFRow row4 = sheet.createRow(4);          HSSFCell c4_0 = row4.createCell(0);     c4_0.setCellValue(new HSSFRichTextString("联系电话："));   HSSFCell c4_2 = row4.createCell(2);     c4_2.setCellValue(new HSSFRichTextString(p.getPhoneNumber()));  HSSFCell c4_5 = row4.createCell(5);  c4_5.setCellValue(new HSSFRichTextString("预到货日期："));   HSSFCell c4_8 = row4.createCell(8);     c4_8.setCellValue(new HSSFRichTextString(p.getPlanArriveTime()+""));  HSSFCell c4_11 = row4.createCell(11);     c4_11.setCellValue(new HSSFRichTextString("采购部门："));  HSSFCell c4_14 = row4.createCell(14);     c4_14.setCellValue(new HSSFRichTextString(p.getDepartment()));      //创建第六行单元格        HSSFRow row5 = sheet.createRow(5);          HSSFCell c5_0 = row5.createCell(0);     c5_0.setCellValue(new HSSFRichTextString("供应商："));   HSSFCell c5_2 = row5.createCell(2);     c5_2.setCellValue(new HSSFRichTextString(p.getSupplier()));  HSSFCell c5_5 = row5.createCell(5);  c5_5.setCellValue(new HSSFRichTextString("交货方式："));   HSSFCell c5_8 = row5.createCell(8);     c5_8.setCellValue(new HSSFRichTextString(p.getExchangeMethod()));  HSSFCell c5_11 = row5.createCell(11);     c5_11.setCellValue(new HSSFRichTextString("送货类型："));  HSSFCell c5_14 = row5.createCell(14);     c5_14.setCellValue(new HSSFRichTextString(p.getDeliveryType()));      //创建第七行单元格        HSSFRow row6 = sheet.createRow(6);          HSSFCell c6_0 = row6.createCell(0);     c6_0.setCellValue(new HSSFRichTextString("交货地址："));   HSSFCell c6_2 = row6.createCell(2);     c6_2.setCellValue(new HSSFRichTextString(p.getExchangeAddress()));      //创建第九行单元格        HSSFRow row8 = sheet.createRow(8);          HSSFCell c8_0 = row8.createCell(0);     c8_0.setCellValue(new HSSFRichTextString("采购明细："));       //创建第十行单元格        HSSFRow row9 = sheet.createRow(9);          HSSFCell c9_0 = row9.createCell(0);     c9_0.setCellValue(new HSSFRichTextString("物料名称："));  HSSFCell c9_1 = row9.createCell(1);     c9_1.setCellValue(new HSSFRichTextString("规格："));  HSSFCell c9_4 = row9.createCell(4);     c9_4.setCellValue(new HSSFRichTextString("下单数量："));  HSSFCell c9_6 = row9.createCell(6);     c9_6.setCellValue(new HSSFRichTextString("单位："));  HSSFCell c9_8 = row9.createCell(8);     c9_8.setCellValue(new HSSFRichTextString("订购编号："));  HSSFCell c9_10 = row9.createCell(10);     c9_10.setCellValue(new HSSFRichTextString("单价："));  HSSFCell c9_12 = row9.createCell(12);     c9_12.setCellValue(new HSSFRichTextString("合计："));  HSSFCell c9_15 = row9.createCell(15);     c9_15.setCellValue(new HSSFRichTextString("备注："));          //创建合并单元  Region region0 = new Region(0, (short)0, 1, (short)4);           Region region1 = new Region(0, (short)5, 0, (short)10);           Region region2 = new Region(0, (short)11, 1, (short)15);        Region region3 = new Region(1, (short)5, 1, (short)10);                  Region region4 = new Region(2, (short)0, 2, (short)1);           Region region5 = new Region(2, (short)2, 2, (short)4);           Region region6 = new Region(2, (short)5, 2, (short)10);           Region region7 = new Region(2, (short)11, 2, (short)13);           Region region8 = new Region(2, (short)14, 2, (short)15);                   Region region9 = new Region(3, (short)0, 3, (short)1);           Region region10 = new Region(3, (short)2, 3, (short)4);        Region region11 = new Region(3, (short)5, 3, (short)7);        Region region12 = new Region(3, (short)8, 3, (short)10);        Region region13 = new Region(3, (short)11, 3, (short)13);           Region region14 = new Region(3, (short)14, 3, (short)15);                 Region region15 = new Region(4, (short)0, 4, (short)1);           Region region16 = new Region(4, (short)2, 4, (short)4);        Region region17 = new Region(4, (short)5, 4, (short)7);        Region region18 = new Region(4, (short)8, 4, (short)10);        Region region19 = new Region(4, (short)11,4, (short)13);           Region region20 = new Region(4, (short)14,4, (short)15);                 Region region21 = new Region(5, (short)0, 5, (short)1);           Region region22 = new Region(5, (short)2, 5, (short)4);        Region region23 = new Region(5, (short)5, 5, (short)7);        Region region24 = new Region(5, (short)8, 5, (short)10);        Region region25 = new Region(5, (short)11,5, (short)13);           Region region26 = new Region(5, (short)14,5, (short)15);                 Region region27 = new Region(6, (short)0, 6, (short)1);           Region region28 = new Region(6, (short)2, 6, (short)7);        Region region29 = new Region(6, (short)8, 6, (short)10);        Region region30 = new Region(6, (short)11,6, (short)13);           Region region31 = new Region(6, (short)14,6, (short)15);                Region region32 = new Region(7, (short)0, 7, (short)1);           Region region33 = new Region(7, (short)2, 7, (short)4);        Region region34 = new Region(7, (short)5, 7, (short)7);        Region region35 = new Region(7, (short)8, 7, (short)10);        Region region36 = new Region(7, (short)11,7, (short)13);           Region region37 = new Region(7, (short)14,7, (short)15);                Region region38 = new Region(8, (short)0,8, (short)15);                Region region39 = new Region(9, (short)1, 9, (short)3);           Region region40 = new Region(9, (short)4, 9, (short)5);        Region region41 = new Region(9, (short)6, 9, (short)7);        Region region42 = new Region(9, (short)8, 9, (short)9);        Region region43 = new Region(9, (short)10,9, (short)11);           Region region44 = new Region(9, (short)12,9, (short)14);                //合并单元格(复合模式)        sheet.addMergedRegion(region0);          sheet.addMergedRegion(region1);          sheet.addMergedRegion(region2);        sheet.addMergedRegion(region3);          sheet.addMergedRegion(region4);          sheet.addMergedRegion(region5);          sheet.addMergedRegion(region6);          sheet.addMergedRegion(region7);          sheet.addMergedRegion(region8);          sheet.addMergedRegion(region9);          sheet.addMergedRegion(region10);          sheet.addMergedRegion(region11);          sheet.addMergedRegion(region12);          sheet.addMergedRegion(region13);          sheet.addMergedRegion(region14);          sheet.addMergedRegion(region15);          sheet.addMergedRegion(region16);          sheet.addMergedRegion(region17);          sheet.addMergedRegion(region18);          sheet.addMergedRegion(region19);          sheet.addMergedRegion(region20);        sheet.addMergedRegion(region21);        sheet.addMergedRegion(region22);        sheet.addMergedRegion(region23);        sheet.addMergedRegion(region24);        sheet.addMergedRegion(region25);        sheet.addMergedRegion(region26);        sheet.addMergedRegion(region27);        sheet.addMergedRegion(region28);        sheet.addMergedRegion(region29);        sheet.addMergedRegion(region30);        sheet.addMergedRegion(region31);        sheet.addMergedRegion(region32);        sheet.addMergedRegion(region33);        sheet.addMergedRegion(region34);        sheet.addMergedRegion(region35);        sheet.addMergedRegion(region36);        sheet.addMergedRegion(region37);        sheet.addMergedRegion(region38);        sheet.addMergedRegion(region39);        sheet.addMergedRegion(region40);        sheet.addMergedRegion(region41);        sheet.addMergedRegion(region42);        sheet.addMergedRegion(region43);        sheet.addMergedRegion(region44);//第六步,将文件存储到指定位置try{FileOutputStream fout = new FileOutputStream("c:/orders.xls");wb.write(fout);fout.close();}catch(Exception e){e.printStackTrace();}
二、核心jar：(见附属Jar包)
http://download.csdn.net/detail/u014344668/9725425
三、核心类解析：
(1)HSSFWorkbook创建Excel文件的类。
(2)HSSFSheet在Excel中创建一个Sheet页,带参构造函数内的内容即为Sheet页名字。
(3)HSSFRow在Excel中创建一行,并将这一行封装到整个对象中。
(4)HSSFCellStyle设置Excel的整体风格。
(5)HSSFCell设置每一个单元格内容的类
(6)Region合并单元格的类
学习Java的同学注意了！！！
学习过程中遇到什么问题或者想获取学习资源的话，欢迎加入Java学习交流群，群号码：543120397 我们一起学Java！
0 0