excel problem

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • radhi
    New Member
    • Aug 2007
    • 1
    #1

    excel problem

    <%@ 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="ap plication/msexcel" %>
    <%
    response.addHea der("Content-Disposition","i nline; filename="+ "CONTRACTSAMEND MENTHISTORYEXCE L.xls" + ";" );

    %>


    <BODY topmargin="0" leftmargin="0">

    <form >
    <TABLE id="tblList" width="190%" border="1" cellspacing="0" >
    <TR>
    <logic:equal name="transport ReportForm" property="forSa tSun" value="true">
    <TD align="center" width="70%" colspan="11"><b >CONTRACT AMENDMENT HISTORY<b></TD>
    </logic:equal>
    <logic:notEqu al name="transport ReportForm" property="forSa tSun" 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>A mended </b></TD>
    <TD align="left" width="15%"><b> Reason</b></TD>
    <TD align="left" width="6%"><b>M on(&pound;)</b></TD>
    <TD align="left" width="6%"><b>T ue(&pound;)</b></TD>
    <TD align="left" width="6%"><b>W ed(&pound;)</b></TD>
    <TD align="left" width="6%"><b>T hu(&pound;)</b></TD>
    <TD align="left" width="5%"><b>F ri(&pound;)</b></TD>
    <logic:equal name="transport ReportForm" property="forSa tSun" value="true">
    <TD align="left" width="6%"><b>S at(&pound;)</b></TD>
    <TD align="left" width="6%"><b>S un(&pound;)</b></TD>
    </logic:equal>

    </TR>

    <logic:notEmp ty name="transport ReportForm" property="contr actAmendmentHis toryList">
    <logic:equal name="transport ReportForm" property="forSa tSun" value="true">
    <logic:iterat e id="tblList" name="transport ReportForm"
    property="contr actAmendmentHis toryList">
    <logic:notEqu al name="tblList" property="contr actNo" value="">
    <%iCount++;%>
    </logic:notEqual>
    <TR valign=top class="odd<%=iC ount%2%>">
    <TD align="left" width="10%"><be an:write name="tblList" property="contr actNo" /></TD>
    <TD align="left" width="15%"><be an:write name="tblList" property="compa ny" /></TD>
    <TD align="left" width="8%"><bea n:write name="tblList" property="dateA mended" /></TD>
    <TD align="left" width="15%"><be an:write name="tblList" property="reaso n" /></TD>
    <TD width="100"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="monCo st" /> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="tueCo st" /> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="wedCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="thuCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="friCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="satCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="sunCo st" /> " ></input></TD>

    </TR>


    </logic:iterate>
    </logic:equal>
    <logic:notEqu al name="transport ReportForm" property="forSa tSun" value="true">
    <logic:iterat e id="tblList" name="transport ReportForm"
    property="contr actAmendmentHis toryList">
    <logic:notEqu al name="tblList" property="contr actNo" value="">
    <%iCount++;%>
    </logic:notEqual>
    <TR valign=top class="odd<%=iC ount%2%>">
    <TD align="left" width="10%"><be an:write name="tblList" property="contr actNo" /></TD>
    <TD align="left" width="15%"><be an:write name="tblList" property="compa ny" /></TD>
    <TD align="left" width="8%"><bea n:write name="tblList" property="dateA mended" /></TD>
    <TD align="left" width="15%"><be an:write name="tblList" property="reaso n" /></TD>
    <TD width="6%" align="right"> <input type="text" value="<bean:wr ite name="tblList" property="monCo st"/> " align="right"></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="tueCo st" /> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="wedCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="thuCo st"/> " ></input></TD>
    <TD width="6%"> <input type="text" style="text-align: right;" value="<bean:wr ite name="tblList" property="friCo st"/> " ></input></TD>

    </TR>

    </logic:iterate>
    </logic:notEqual>

    </logic:notEmpty>

    <logic:empty name="transport ReportForm" property="contr actAmendmentHis toryList">
    <TR valign="top">
    <TD align="center" colspan="10" width="5%"><b>N o 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
    Tags: None
    Previous template Next
    Working...