public String export() throws Exception {
int i=12;
int j=1;
if ("per".equals(ddlCustClassId)) {
status = 1;
} else if ("com".equals(ddlCustClassId)) {
status = 0;
} else {
status = 2;
}
List exportList = withdrowAuditBiz.getexportList(userName, status); //获得List数据
if(null!=exportList&&exportList.size()>0){
response.setHeader("Content-Disposition",
"attachment;filename=%e6%8f%90%e7%8e%b0%e5%ae%a1%e6%a0%b8%e8%a1%a8.xls");
response.setContentType("application/ vnd.ms-excel;charset=utf-8");// 设置导出类型为excel
response.setCharacterEncoding("utf-8");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("sheet1");
sheet1.setColumnWidth(0, 3000);
sheet1.setColumnWidth(1, 4000);
sheet1.setColumnWidth(2, 4000);
sheet1.setColumnWidth(3, 10000);
sheet1.setColumnWidth(4, 4000);
sheet1.setColumnWidth(5, 10000);
sheet1.setColumnWidth(6, 4000);
sheet1.setColumnWidth(7, 4000);
sheet1.setColumnWidth(8, 4000);
sheet1.setColumnWidth(9, 4000);
sheet1.setColumnWidth(10, 6000);
sheet1.setColumnWidth(11, 3000);
// 创建字体样式
HSSFFont font = wb.createFont();
font.setFontName("Verdana");
font.setBoldweight((short) 100);
font.setFontHeight((short) 300);
font.setColor(HSSFColor.BLUE.index);
// 创建单元格样式
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
style.setFillForegroundColor(HSSFColor.LIGHT_TURQUOISE.index);
// style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style.setFont(font);// 设置字体
// 创建Excel的sheet的一行
HSSFRow row = sheet1.createRow(0);
row.setHeight((short) 500);// 设定行的高度
// 创建一个Excel的单元格
HSSFCell cell = row.createCell((short) 0);
// 给Excel的单元格设置样式和赋值
cell.setCellStyle(style);
cell.setCellValue("序号");
HSSFCell cell1 = row.createCell((short) 1);
cell1.setCellStyle(style);
cell1.setCellValue("客户名称");
HSSFCell cell2 = row.createCell((short) 2);
cell2.setCellStyle(style);
cell2.setCellValue("真实名称");
HSSFCell cell3 = row.createCell((short) 3);
cell3.setCellStyle(style);
cell3.setCellValue("提现账号");
HSSFCell cell4 = row.createCell((short) 4);
cell4.setCellStyle(style);
cell4.setCellValue("提现银行");
HSSFCell cell5 = row.createCell((short) 5);
cell5.setCellStyle(style);
cell5.setCellValue("支行");
HSSFCell cell6 = row.createCell((short) 6);
cell6.setCellStyle(style);
cell6.setCellValue("提现总额");
HSSFCell cell7 = row.createCell((short) 7);
// 给Excel的单元格设置样式和赋值
cell7.setCellStyle(style);
cell7.setCellValue("到账金额");
HSSFCell cell8 = row.createCell((short) 8);
cell8.setCellStyle(style);
cell8.setCellValue("手续费");
HSSFCell cell9 = row.createCell((short) 9);
cell9.setCellStyle(style);
cell9.setCellValue("红包抵扣");
HSSFCell cell10 = row.createCell((short) 10);
cell10.setCellStyle(style);
cell10.setCellValue("提现时间");
HSSFCell cell11 = row.createCell((short) 11);
cell11.setCellStyle(style);
cell11.setCellValue("状态");
Iterator iterator = exportList.iterator();
while(iterator.hasNext()) {
Object [] objects=(Object[])iterator.next();
UUserInfo uUserInfo =(UUserInfo) objects[0];
UWithdrawCash uWithdrowCash = (UWithdrawCash) objects[1];
UBankAccount uBankAccount = (UBankAccount) objects[2];
style.setFillForegroundColor(HSSFColor.WHITE.index);
HSSFRow rows = sheet1.createRow(j);
rows.setHeight((short) 500);// 设定行的高度
HSSFCell a = rows.createCell((short) 0);
a.setCellStyle(style);
a.setCellValue(j);
j++;
if(null!=uUserInfo.getUserName()){
HSSFCell cells2 = rows.createCell((short) 1);
cells2.setCellStyle(style);
cells2.setCellValue(uUserInfo.getUserName());
}else{
HSSFCell cells2 = rows.createCell((short) 1);
cells2.setCellStyle(style);
cells2.setCellValue("");
}
if(null!=uUserInfo.getRealName()){
HSSFCell cells3 = rows.createCell((short) 2);
cells3.setCellStyle(style);
cells3.setCellValue(uUserInfo.getRealName());
}else{
HSSFCell cells3 = rows.createCell((short) 2);
cells3.setCellStyle(style);
cells3.setCellValue("");
}
if(null!=uBankAccount.getBankAccount()){
HSSFCell cells4 = rows.createCell((short) 3);
cells4.setCellStyle(style);
cells4.setCellValue(uBankAccount.getBankAccount());
}else{
HSSFCell cells4 = rows.createCell((short) 3);
cells4.setCellStyle(style);
cells4.setCellValue("");
}
if(null!=uBankAccount.getOpenBank()){
HSSFCell cells5 = rows.createCell((short) 4);
cells5.setCellStyle(style);
cells5.setCellValue(uBankAccount.getOpenBank());
}else{
HSSFCell cells5 = rows.createCell((short) 4);
cells5.setCellStyle(style);
cells5.setCellValue("");
}
if(null!=uBankAccount.getOpenBankName()){
HSSFCell cells6 = rows.createCell((short) 5);
cells6.setCellStyle(style);
cells6.setCellValue(uBankAccount.getOpenBankName());
}else{
HSSFCell cells6 = rows.createCell((short) 5);
cells6.setCellStyle(style);
cells6.setCellValue("");
}
if(null!=uWithdrowCash.getWithdrawTotal()){
HSSFCell cells7 = rows.createCell((short) 6);
cells7.setCellStyle(style);
cells7.setCellValue(uWithdrowCash.getWithdrawTotal());
}else{
HSSFCell cells7 = rows.createCell((short) 6);
cells7.setCellStyle(style);
cells7.setCellValue("");
}
if(null!=uWithdrowCash.getToAccountMoney()){
HSSFCell cells8 = rows.createCell((short) 7);
cells8.setCellStyle(style);
cells8.setCellValue(uWithdrowCash.getToAccountMoney());
}else{
HSSFCell cells8 = rows.createCell((short) 7);
cells8.setCellStyle(style);
cells8.setCellValue("");
}
if(null!=uWithdrowCash.getPoundageFee()){
HSSFCell cells9 = rows.createCell((short) 8);
cells9.setCellStyle(style);
cells9.setCellValue(uWithdrowCash.getPoundageFee());
}else{
HSSFCell cells9 = rows.createCell((short) 8);
cells9.setCellStyle(style);
cells9.setCellValue("");
}
if(null!=uWithdrowCash.getRedDeduction()){
HSSFCell cells10 = rows.createCell((short) 9);
cells10.setCellStyle(style);
cells10.setCellValue(uWithdrowCash.getRedDeduction());
}else{
HSSFCell cells10 = rows.createCell((short) 9);
cells10.setCellStyle(style);
cells10.setCellValue("");
}
if(null!=uWithdrowCash.getWithdrawTime()){
HSSFCell cells11 = rows.createCell((short) 10);
cells11.setCellStyle(style);
cells11.setCellValue(uWithdrowCash.getWithdrawTime());
}else{
HSSFCell cells11 = rows.createCell((short) 10);
cells11.setCellStyle(style);
cells11.setCellValue("");
}
if(null!=uWithdrowCash.getStatus()){
if(uWithdrowCash.getStatus()==1){
HSSFCell cells12 = rows.createCell((short) 11);
cells12.setCellStyle(style);
cells12.setCellValue("通过");
}else{
HSSFCell cells12 = rows.createCell((short) 11);
cells12.setCellStyle(style);
cells12.setCellValue("未通过");
}
}else{
HSSFCell cells12 = rows.createCell((short) 11);
cells12.setCellStyle(style);
cells12.setCellValue("");
}
}
try {
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
} catch (IOException e) {
e.printStackTrace();
System.out.println("Output is closed ");
}
}
return null; //此处一定要return null!!
}