簡単なjxlの例

private void export(HttpServletRequest request,HttpServletResponse response,
			List baobiao,
			String dateFrom,String dateTo){
		
		try {
			//  vnd.ms-excel      
			response.setContentType("application/vnd.ms-excel");
			//  OrderMess.xls         
			response.addHeader("Content-Disposition",
					"attachment;  filename=\""+dateFrom+"_to_"+dateTo+"_BAOBIAO.xls" + "\"");
			OutputStream os = response.getOutputStream();
			//        
			WritableWorkbook wwb = Workbook.createWorkbook(os);
			OrderAction ra = new OrderAction();
			//           
	        
			//      
			WritableSheet wsheet = wwb.createSheet(dateFrom+"   "+dateTo+"  ", 1);
			//     
			
			//       ，        
			if (baobiao != null && baobiao.size() > 0) {
				
                  //         
				Label label = new Label(0, 0, dateFrom+"   "+dateTo+"  ");
				wsheet.addCell(label);
				label = new Label(0, 1, "    ");
				wsheet.addCell(label);
				label = new Label(1, 1, "    ");
				wsheet.addCell(label);
				label = new Label(2, 1, "    ");
				wsheet.addCell(label);
				label = new Label(3, 1, "    ");
				wsheet.addCell(label);
				label = new Label(4, 1, "    ");
				wsheet.addCell(label);
				label = new Label(5, 1, "    ");
				wsheet.addCell(label);
				label = new Label(6, 1, "   ");
				wsheet.addCell(label);
				label = new Label(7, 1, "     ");
				wsheet.addCell(label);
				label = new Label(8, 1, "   ");
				wsheet.addCell(label);
				label = new Label(9, 1, "    ");
				wsheet.addCell(label);
				label = new Label(10, 1, "    ");
				wsheet.addCell(label);
				label = new Label(11, 1, "    ");
				wsheet.addCell(label);
				label = new Label(12, 1, "    ");
				wsheet.addCell(label);
				label = new Label(13, 1, "  （ ）");
				wsheet.addCell(label);
				label = new Label(14, 1, "    ");
				wsheet.addCell(label);
				label = new Label(15, 1, "    ");
				wsheet.addCell(label);
				label = new Label(16, 1, "    ");
				wsheet.addCell(label);
				label = new Label(17, 1, "    ");
				wsheet.addCell(label);
				label = new Label(18, 1, "    ");
				wsheet.addCell(label);
				
				int i=2;
				for(SIOrderBaoBiao oneBaobiaoRecord : baobiao){
					label = new Label(0, i , oneBaobiaoRecord.getLineName());
					wsheet.addCell(label);
					
					
					label = new Label(1, i, oneBaobiaoRecord.getLineBeginSite());
					wsheet.addCell(label);
					
					label = new Label(2, i, oneBaobiaoRecord.getLineEndSite());
					wsheet.addCell(label);
					
					label = new Label(3, i, oneBaobiaoRecord.getSeatDate()+" "+oneBaobiaoRecord.getSeatTime());
					wsheet.addCell(label);
					
					label = new Label(4, i, oneBaobiaoRecord.getGuestName());
					wsheet.addCell(label);
					
					label = new Label(5, i, oneBaobiaoRecord.getGuestPhone());
					wsheet.addCell(label);
					
					label = new Label(6, i, oneBaobiaoRecord.getGuestCard());
					wsheet.addCell(label);
					
					label = new Label(7, i, oneBaobiaoRecord.getETicketNo());
					wsheet.addCell(label);
					
					label = new Label(8, i,oneBaobiaoRecord.getSeat());
					wsheet.addCell(label);
					
					label = new Label(9, i, oneBaobiaoRecord.getLeftMsg());
					wsheet.addCell(label);
					
					label = new Label(10, i, oneBaobiaoRecord.getOrderTime());
					wsheet.addCell(label);
					
					//label = new Label(11, i, oneBaobiaoRecord.getBuyNums());
					label = new Label(11, i, "1");
					wsheet.addCell(label);
					
					//label = new Label(12, i, oneBaobiaoRecord.getRefundNums());
					label = new Label(12, i, oneBaobiaoRecord.getIsRefund());
					wsheet.addCell(label);
					
					//label = new Label(13, i, oneBaobiaoRecord.getTotalMoney());
					label = new Label(13, i, oneBaobiaoRecord.getPayCost());
					wsheet.addCell(label);
					
					label = new Label(14, i, descOrderUserType(oneBaobiaoRecord.getOrderUserType()));
					wsheet.addCell(label);
					
					label = new Label(15, i, descPayType(oneBaobiaoRecord.getPayType()));
					wsheet.addCell(label);
					
					label = new Label(16, i, descOrderStatus(oneBaobiaoRecord.getOrderState()));
					wsheet.addCell(label);
					
					label = new Label(17, i, descQRefund(oneBaobiaoRecord.getQRefund()));
					wsheet.addCell(label);
					
					label = new Label(18, i, oneBaobiaoRecord.getOrderBf());
					wsheet.addCell(label);
					
					i++;
					
				}
			} else {
				Label label = new Label(0, 0, dateFrom+"   "+dateTo+"  ");
				wsheet.addCell(label);
				label = new Label(0, 1, (String) "    ");
				wsheet.addCell(label);
			}
			          
			wwb.write();
			wwb.close();
			os.close();
			response.flushBuffer();
		} catch (Exception e) {
			System.out.println("     (Excel  )   ：");
			e.printStackTrace();
		}
		
	}