+ Start a Discussion
vineet.singh1.3909961514711633E12vineet.singh1.3909961514711633E12 

problem to generate a xls file from visualforce page.

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.
Abhi__SFDCAbhi__SFDC

Please share the content type which you are using.

You can refer the following sample code  to  Generate a VF page (Excel Doc)-:

contentType="application/vnd.ms-excel#PartnerDealReg.xls"
or
contentType="text/csv#U65_{!dtdisplay}.csv