jsp页面中如果存在多张table表,导出的文件不规整时需要调整 td的colspan属性即可
<body class="no-skin">
<%
String exportToExcel = request.getParameter("exportToExcel");
if (exportToExcel != null
&& exportToExcel.toString().equalsIgnoreCase("YES")) {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "inline; filename="
+ "KGBAL.xls");
}
%>
<%
if (exportToExcel == null) {
%>
</form>
<a href="<%=basePath%>qms_iqcqualityrec/goAdd2.do?exportToExcel=YES&ID=${pd.ID}" class="btn btn-mini btn-primary">导出Excel</a>
<%
}
%>
<table id="" border="1" style="margin-top:2%;width: 98%;">
<tr>
<td style="width:75px;text-align: center;padding-top: 8px;">供应商名称:</td>
<td style="width:35px;text-align: center;padding-top: 8px;" colspan="2">${pd.SUPPLIER_NAMECN}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">型号:</td>
<td style="width:75px;text-align: center;padding-top: 8px;" colspan="2">${pd.PRODUCT_NO}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">收货数量:</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.RECVQTY}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">抽检百分比:</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.SAMPLINGRATE}%</td>
</tr>
<tr>
<td style="width:75px;text-align: center;padding-top: 8px;">采购合同号:</td>
<td style="width:35px;text-align: center;padding-top: 8px;" colspan="2">${pd.PURCHASEORDERNO}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">采购数量:</td>
<td style="width:75px;text-align: center;padding-top: 8px;"colspan="2"></td>
<td style="width:75px;text-align: center;padding-top: 8px;">抽检数量:</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.SAMPLINGQTY}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">检验员:</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.WORKERNAME_CHECK}</td>
</tr>
<tr>
<td style="width:75px;text-align: center;padding-top: 8px;">入库单号:</td>
<td style="width:35px;text-align: center;padding-top: 8px;" colspan="2">${pd.MMSI_INPUTNO}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">批次号:</td>
<td style="width:75px;text-align: center;padding-top: 8px;"colspan="2">${pd.BATCH_NO}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">检验单号:</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.CHECK_NO}</td>
<td style="width:75px;text-align: center;padding-top: 8px;">收货日期</td>
<td style="width:75px;text-align: center;padding-top: 8px;">${pd.mmsi_inputdate}</td>
</tr>
</table>
</body>