Skip to main content
Muzeeb Shaik (Wipro) a posé une question dans #Visualforce

Hi This is my Vf page :

<apex:page showHeader="false" Sidebar="FALSE" standardController="Order" cache="true"

extensions="SalesOrderReportGenerator" action="{!SalesOrderReportData}" contentType="Charset=UTF-8;text/octet-stream⌗Account.csv;">

<apex:dataTable value="{!sapRecordListFinal }" var="w" width="1" border="1">

<apex:column headerValue="SFDC SO No" >

<apex:outputText value="{!w.orderRecord.OrderNumber}"/>

</apex:column>

<apex:column headerValue="Order Type" >

<apex:outputText value="{!w.orderRecord.Type}"/>

</apex:column>

<apex:column headerValue="Sales Org " >

<apex:outputText value="{!w.orderRecord.Sales_Org__c}"/>

</apex:column>

</apex:datatable>

There are so many columns , i just showed only few columns.

While eporting to .CSV file am getting this output.

Generating To CSV file

Actual Problem is I exported as

contentType="application/csv⌗RenderAsTestFile.xls"

This is working fine, but our clint have problem with date fileds...like

Date format should be DD/MM/YYYY. But after extraction it is showing as single digit. for example if the date is 7/1/2015 the format should be 07/01/2015(The desired output should be like this). 

Also i want to know where i am doing the mistake , please help me, in this .CSCV file foramt, cuz i want to show the client in CSV format also 

thanks

 
5 réponses
  1. 9 janv. 2015, 11:18
    Hi Padmini,

    Try below samples.

     

    <apex:outputText escape="false" lang="en-US" value="test"></apex:outputText>

    (OR)

     

    <apex:outputText escape="true" lang="en-US" value="test"></apex:outputText>

    Best Regards,

    Mithun.
0/9000