{"id":2177,"date":"2010-04-06T15:12:18","date_gmt":"2010-04-06T10:12:18","guid":{"rendered":"http:\/\/www.chiragmehta.info\/chirag\/?p=2177"},"modified":"2010-04-06T15:16:54","modified_gmt":"2010-04-06T10:16:54","slug":"how-to-export-data-to-csv-filetext-file-using-apex","status":"publish","type":"post","link":"https:\/\/www.chiragmehta.info\/chirag\/2010\/04\/06\/how-to-export-data-to-csv-filetext-file-using-apex\/","title":{"rendered":"How to export data to CSV file\/text file using Apex"},"content":{"rendered":"<p><strong>Problem Statement<\/strong><br \/>\nI want to export list of object into CSV file using Apex<\/p>\n<p><strong>Solution<\/strong><\/p>\n<blockquote>\n<p><code>&lt;apex:page\u00a0controller=\"csvController\"\u00a0cache=\"true\"\u00a0<br \/>\ncontentType=\"text\/csv#filename.csv\"\u00a0language=\"en-US\"&gt;<br \/>\n\"Col\u00a0A\",\"Col\u00a0B\",\"Col\u00a0C\",\"Col\u00a0D\"<br \/>\n&lt;apex:repeat\u00a0value=\"{!myList}\"\u00a0var=\"a\"&gt;<br \/>\n\"{!a.ColA}\",\"{!a.ColB}\",\"{!a.ColC}\",\"{!a.ColD}\"<br \/>\n&lt;\/apex:repeat&gt;<br \/>\n&lt;\/apex:page&gt;<\/code><\/p>\n<\/blockquote>\n<p><strong>Please note that<\/strong><\/p>\n<ul>\n<li> With the #filename.csv, it prompts the user to save\/open the file. Otherwise, it loads into the browser as html<\/li>\n<li> You&#8217;ll also have to format the VF page as a clean csv text file, that means no pageblocktables or anything that might insert html formatting.<\/li>\n<li>if customer want to export data object to text file use <strong>contentType=&#8221;text\/plain&#8221; <\/strong><\/li>\n<\/ul>\n<p>Source : <a href=\"http:\/\/community.salesforce.com\/t5\/Apex-Code-Development\/How-to-export-data-to-CSV-file-using-Apex\/td-p\/166567\" target=\"_blank\" rel=\"noopener\">Salesforce Community<\/a><strong><br \/>\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Problem Statement I want to export list of object into CSV file using Apex Solution &lt;apex:page\u00a0controller=&#8221;csvController&#8221;\u00a0cache=&#8221;true&#8221;\u00a0 contentType=&#8221;text\/csv#filename.csv&#8221;\u00a0language=&#8221;en-US&#8221;&gt; &#8220;Col\u00a0A&#8221;,&#8221;Col\u00a0B&#8221;,&#8221;Col\u00a0C&#8221;,&#8221;Col\u00a0D&#8221; &lt;apex:repeat\u00a0value=&#8221;{!myList}&#8221;\u00a0var=&#8221;a&#8221;&gt; &#8220;{!a.ColA}&#8221;,&#8221;{!a.ColB}&#8221;,&#8221;{!a.ColC}&#8221;,&#8221;{!a.ColD}&#8221; &lt;\/apex:repeat&gt; &lt;\/apex:page&gt; Please note that With the #filename.csv, it prompts the user to save\/open the file. Otherwise, it loads into the browser as html You&#8217;ll also have to format the VF page as a clean [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[62,169],"class_list":["post-2177","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-apex-csv-export-data-text-salesforce-force","tag-salesforce","post-preview"],"_links":{"self":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/comments?post=2177"}],"version-history":[{"count":6,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2177\/revisions"}],"predecessor-version":[{"id":2183,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2177\/revisions\/2183"}],"wp:attachment":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/media?parent=2177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/categories?post=2177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/tags?post=2177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}