I am creating a tabular report.I need to display the total values at the bottom of specific column.I used <apex:facet  name="footer">Total</apex:facet> tag within <apex:column> tag.It results properly at vf page but when i generate an xls file , the footer is not displaying in the file.

I also used <apex:outputpanel> like

<apex:column headerValue="Amount">
  <apex:outputField value="{!value.TotalTransactionAmount__c}"/>
    <apex:facet name="footer">
        <apex:outputPanel>
              TotalAmount:{!amountMap[i]}
        </apex:outputPanel>
        </apex:facet>
  </apex:column>


Kindly help me ,if anybody have any idea about this.

I am creating a tabular report.I need to display the total values at the bottom of specific column.I used <apex:facet  name="footer">Total</apex:facet> tag within <apex:column> tag.It results properly at vf page but when i generate an xls file , the footer is not displaying in the file.

I also used <apex:outputpanel> like

<apex:column headerValue="Amount">
  <apex:outputField value="{!value.TotalTransactionAmount__c}"/>
    <apex:facet name="footer">
        <apex:outputPanel>
              TotalAmount:{!amountMap[i]}
        </apex:outputPanel>
        </apex:facet>
  </apex:column>


Kindly help me ,if anybody have any idea about this.