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.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
thanksHi Padmini,Try below samples. <apex:outputText escape="false" lang="en-US" value="test"></apex:outputText>
(OR)
Best Regards,Mithun.<apex:outputText escape="true" lang="en-US" value="test"></apex:outputText>