一个excel导出模板

<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %><%@ include file="/WEB-INF/views/commons/taglibs.jsp" %><?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">  <Created>1996-12-17T01:32:42Z</Created>  <LastSaved>2010-12-20T07:17:03Z</LastSaved>  <Version>11.6568</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">  <RemovePersonalInformation/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">  <WindowHeight>4530</WindowHeight>  <WindowWidth>8505</WindowWidth>  <WindowTopX>480</WindowTopX>  <WindowTopY>120</WindowTopY>  <AcceptLabelsInFormulas/>  <ProtectStructure>False</ProtectStructure>  <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles>  <Style ss:ID="Default" ss:Name="Normal">   <Alignment ss:Vertical="Bottom"/>   <Borders/>   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>   <Interior/>   <NumberFormat/>   <Protection/>  </Style>  <Style ss:ID="m158682212">   <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>   <Borders>    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>   </Borders>   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/>  </Style>  <Style ss:ID="s21">   <Borders>    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>   </Borders>  </Style>  <Style ss:ID="s22">   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>   <Borders>    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>   </Borders>   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/>  </Style> </Styles> <Worksheet ss:Name="Sheet1">  <Table ss:ExpandedColumnCount="12"  x:FullColumns="1"   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">   <Column ss:Width="75.75"/>   <Column ss:Index="5" ss:Width="61.5"/>   <Column ss:Index="8" ss:Width="57"/>      <c:choose>   <c:when test="${not empty ImageFailedDetailList}">      <Row>    <Cell ss:StyleID="s22"><Data ss:Type="String">序号</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">次品单号</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">条码号</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">单证类型</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">重新扫描条码号</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">退回用户ID</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">退回时间</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">处理标志</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">处理时间</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">退回原因</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">业务退回描述</Data></Cell>    <Cell ss:StyleID="s22"><Data ss:Type="String">扫描机构</Data></Cell>   </Row>        <c:forEach var="item" items="${ImageFailedDetailList}" varStatus="status"> <Row>         <Cell ss:StyleID="s21"> <Data ss:Type="String">${status.index+1}</Data></Cell>       <Cell ss:StyleID="s21"><Data ss:Type="String">${item.imageFailedNo}</Data></Cell>    <Cell ss:StyleID="s21"><Data ss:Type="String">${item.barCode}</Data></Cell>       <Cell ss:StyleID="s21"><Data ss:Type="String">${item.imageName}</Data></Cell>       <Cell ss:StyleID="s21"><Data ss:Type="String">${item.documentId}</Data></Cell>    <Cell ss:StyleID="s21"><Data ss:Type="String">${item.returnUserId}</Data></Cell>    <Cell ss:StyleID="s21">    <Data ss:Type="String">      <fmt:formatDate value="${item.returnTime}" type="date" pattern="yyyy-MM-dd HH:mm:ss"/>     </Data>    </Cell>    <c:choose><c:when test="${item.dealFlag eq 'Y'}"><Cell ss:StyleID="s21"> <Data ss:Type="String">处理</Data></Cell></c:when><c:otherwise><Cell ss:StyleID="s21"> <Data ss:Type="String">未处理</Data></Cell></c:otherwise> </c:choose>    <Cell ss:StyleID="s21">   <Data ss:Type="String">       <fmt:formatDate value="${item.dealTime}" type="date" pattern="yyyy-MM-dd HH:mm:ss"/>   </Data>    </Cell>    <Cell ss:StyleID="s21"><Data ss:Type="String">${item.returnReasonDesc}</Data></Cell>    <Cell ss:StyleID="s21"><Data ss:Type="String">${item.businessRetrunDesc}</Data></Cell>    <Cell ss:StyleID="s21"><Data ss:Type="String">${item.branchName}</Data></Cell></Row></c:forEach>   </c:when><c:otherwise><Row>       <Cell ss:StyleID="s22"><Data ss:Type="String">无数据</Data></Cell>   </Row>  </c:otherwise>   </c:choose>  </Table>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">   <Print>    <ValidPrinterInfo/>    <PaperSizeIndex>9</PaperSizeIndex>    <HorizontalResolution>300</HorizontalResolution>    <VerticalResolution>300</VerticalResolution>   </Print>   <Selected/>   <Panes>    <Pane>     <Number>3</Number>     <ActiveRow>8</ActiveRow>     <ActiveCol>4</ActiveCol>    </Pane>   </Panes>   <ProtectObjects>False</ProtectObjects>   <ProtectScenarios>False</ProtectScenarios>  </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet2">  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"/>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">   <ProtectObjects>False</ProtectObjects>   <ProtectScenarios>False</ProtectScenarios>  </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet3">  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"/>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">   <ProtectObjects>False</ProtectObjects>   <ProtectScenarios>False</ProtectScenarios>  </WorksheetOptions> </Worksheet></Workbook>