1
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<html:html>
<HEAD>
<%@ page contentType="application/msexcel" %>
<%
response.addHeader("Content-Disposition","inline; filename="+ "CONTRACTSAMENDMENTHISTORYEXCEL.xls" + ";" );
%>
<BODY topmargin="0" leftmargin="0">
<form >
<TABLE id="tblList" width="190%" border="1" cellspacing="0" >
<TR>
<logic:equal name="transportReportForm" property="forSatSun" value="true">
<TD align="center" width="70%" colspan="11"><b>CONTRACT AMENDMENT HISTORY<b></TD>
</logic:equal>
<logic:notEqual name="transportReportForm" property="forSatSun" value="true">
<TD align="center" width="70%" colspan="9"><b>CONTRACT AMENDMENT HISTORY<b></TD>
</logic:notEqual>
</TR>
<%int iCount = 0;%>
<tr>
<td colspan="2">
<TR class="hdrftr" valign="top">
<TD align="left" width="10%"><b>Contract No.</b></TD>
<TD align="left" width="15%"><b>Company</b></TD>
<TD align="left" width="8%"><b>Amended </b></TD>
<TD align="left" width="15%"><b>Reason</b></TD>
<TD align="left" width="6%"><b>Mon(£)</b></TD>
<TD align="left" width="6%"><b>Tue(£)</b></TD>
<TD align="left" width="6%"><b>Wed(£)</b></TD>
<TD align="left" width="6%"><b>Thu(£)</b></TD>
<TD align="left" width="5%"><b>Fri(£)</b></TD>
<logic:equal name="transportReportForm" property="forSatSun" value="true">
<TD align="left" width="6%"><b>Sat(£)</b></TD>
<TD align="left" width="6%"><b>Sun(£)</b></TD>
</logic:equal>
</TR>
<logic:notEmpty name="transportReportForm" property="contractAmendmentHistoryList">
<logic:equal name="transportReportForm" property="forSatSun" value="true">
<logic:iterate id="tblList" name="transportReportForm"
property="contractAmendmentHistoryList">
<logic:notEqual name="tblList" property="contractNo" value="">
<%iCount++;%>
</logic:notEqual>
<TR valign=top class="odd<%=iCount%2%>">
<TD align="left" width="10%"><bean:write name="tblList" property="contractNo" /></TD>
<TD align="left" width="15%"><bean:write name="tblList" property="company" /></TD>
<TD align="left" width="8%"><bean:write name="tblList" property="dateAmended" /></TD>
<TD align="left" width="15%"><bean:write name="tblList" property="reason" /></TD>
<TD width="100"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="monCost" /> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="tueCost" /> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="wedCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="thuCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="friCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="satCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="sunCost" /> " ></input></TD>
</TR>
</logic:iterate>
</logic:equal>
<logic:notEqual name="transportReportForm" property="forSatSun" value="true">
<logic:iterate id="tblList" name="transportReportForm"
property="contractAmendmentHistoryList">
<logic:notEqual name="tblList" property="contractNo" value="">
<%iCount++;%>
</logic:notEqual>
<TR valign=top class="odd<%=iCount%2%>">
<TD align="left" width="10%"><bean:write name="tblList" property="contractNo" /></TD>
<TD align="left" width="15%"><bean:write name="tblList" property="company" /></TD>
<TD align="left" width="8%"><bean:write name="tblList" property="dateAmended" /></TD>
<TD align="left" width="15%"><bean:write name="tblList" property="reason" /></TD>
<TD width="6%" align="right"> <input type="text" value="<bean:write name="tblList" property="monCost"/> " align="right"></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="tueCost" /> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="wedCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="thuCost"/> " ></input></TD>
<TD width="6%"> <input type="text" style="text-align: right;" value="<bean:write name="tblList" property="friCost"/> " ></input></TD>
</TR>
</logic:iterate>
</logic:notEqual>
</logic:notEmpty>
<logic:empty name="transportReportForm" property="contractAmendmentHistoryList">
<TR valign="top">
<TD align="center" colspan="10" width="5%"><b>No Records to Display</b></TD>
</TR>
</logic:empty>
</td>
</tr>
</TABLE>
</td>
</tr>
</td>
</TR>
</table>
</form>
</div>
</BODY>
</html:html>
when i opened this page in excel the data in input tag cant not be assigned to right
