Click here to Skip to main content
15,904,023 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
HTML
<cfxml variable="xmlDataDump">
<?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">
    <Styles>
        <Style ss:ID="s25">
            <alignment ss:horizontal="Center" ss:vertical="Bottom" xmlns:ss="#unknown" />
            <borders>
                <border ss:removed="Bottom" ss:linestyle="Continuous" ss:weight="1" xmlns:ss="#unknown" />
            </borders>
            <font x:family="Swiss" ss:bold="1" xmlns:ss="#unknown" xmlns:x="#unknown" />
        </Style>
        <Style ss:ID="s27">
            <alignment ss:horizontal="Center" ss:vertical="Bottom" xmlns:ss="#unknown" />
            <borders>
                <border ss:removed="Bottom" ss:linestyle="Continuous" ss:weight="1" xmlns:ss="#unknown" />
            </borders>
            <font x:family="Swiss" ss:bold="1" xmlns:ss="#unknown" xmlns:x="#unknown" />
            <interior ss:color="#99CCFF" ss:pattern="Solid" xmlns:ss="#unknown" />
        </Style>
        <Style ss:ID="s28">
            <interior ss:color="#99CCFF" ss:pattern="Solid" xmlns:ss="#unknown" />
        </Style>
    </Styles>
    <worksheet ss:name="Sheet1" xmlns:ss="#unknown">
        <table ss:expandedcolumncount="6" ss:expandedrowcount="12" x:fullcolumns="1" x:fullrows="1" xmlns:x="#unknown">
            <column ss:width="93" />
            <row>
                <cell ss:styleid="s25"><data ss:type="String">Salesperson</data></cell>
                <cell ss:styleid="s25"><data ss:type="String">1Qtr</data></cell>
                <cell ss:styleid="s25"><data ss:type="String">2Qtr</data></cell>
                <cell ss:styleid="s25"><data ss:type="String">3Qtr</data></cell>
                <cell ss:styleid="s25"><data ss:type="String">4Qtr</data></cell>
                <cell ss:styleid="s27"><data ss:type="String">Year</data></cell>
           </row>
            <cfoutput>
            <cfloop query="qrySales">
            <row>
                <cell><data ss:type="String">#qrySales.SALESPERSON#</data></cell>
                <cell><data ss:type="Number">#qrySales.QTR1#</data></cell>
                <cell><data ss:type="Number">#qrySales.QTR2#</data></cell>
                <cell><data ss:type="Number">#qrySales.QTR3#</data></cell>
                <cell><data ss:type="Number">#qrySales.QTR4#</data></cell>
                <cell ss:styleid="s28" ss:formula="=SUM(RC[-4]:RC[-1])"></cell>
            </row>
            </cfloop>
            </cfoutput>
        </table>
    </worksheet>
</workbook>
</cfxml>


Read more: http://tutorial429.easycfm.com/#ixzz1mGcHxqYX
Posted
Updated 22-Apr-12 22:05pm
v2
Comments
Pandvi 23-Apr-12 1:59am    
hi, what are you trying to say?
Sandeep Mewara 23-Apr-12 2:03am    
This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.
Herman<T>.Instance 23-Apr-12 4:05am    
and next?

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900