java后台导出excel_Java后台Excel表导出

vnd.ms-excel.numberformat:@;

border:0.5pt solid #c5c5c5;

height:30px;

word-break:break-all;

word-wrap:break-word;

}

#tab_title td{background:#f5f5f5;}

String menu_id=request.getParameter("menu_id");

String cookie_menu=request.getParameter("cookie_menu");%>

系统充值明细
序号	昵称	手机号	充值金额	充值前金额	充值后金额	充值时间
${status.index+1}	${bk.a__name}	${bk.a__tel}	${bk.c__money}	${bk.c__balance}	${bk.c__after}	${bk.c__insert_date}
合计：共${t_amount} 个记录，充值总金额为 元。

private staticString AddExcelHead(){

StringBuffer sb= newStringBuffer();

sb.append("");

sb.append("

");

sb.append(" ");

sb.append(" ");

sb.append("

");returnsb.toString();

}private staticString AddExcelbottom(){

StringBuffer sb= newStringBuffer();

sb.append("");

sb.append("");returnsb.toString();

}%>