Is it possible to do a CSV export with pure JavaScript? Close, but you still need the help of a server-side script to tell the browser what type of content is coming it's way.<\/p>\n
To start, we can build on a simple jQuery plugin called table2CSV. The plugin essentially converts an HTML table to a CSV string, which you can use in your export script.<\/p>\n
With table2CSV as a base, you could add the following jQuery snippet, which tacks an Export icon into each table caption, along with a form to post the CSV string to your processing script.<\/p>\n
In PHP, your CSV export script might look like:<\/p>\n In Python, you might use:<\/p>\n Is it possible to do a CSV export with pure JavaScript? Close, but you still need the help of a server-side script to tell the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[5],"tags":[86,113],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/340"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$('#content table caption').each(function() {
\n\t d = new Date();
\n\t filename = $(this).html().replace(\/ \/g, '-') + d.getMonth()
\n\t + '-' + d.getDate() + '-' + d.getFullYear() + '.csv';
\n\t html = '<form action="\/csvExport.php" method="post">';
\n\t html += '<input type="hidden" name="filename"
\n\t value="' + filename + '" \/>';
\n\t html += '<input type="hidden" name="csv_text"
\n\t value="" class="csv_text" \/>';
\n\t html += '<input type="image" src="\/xls.png"
\n\t alt="Export" \/>';
\n\t html += '<\/form>';
\n\t $(this).append(html);
\n\t $(this).find('.csv_text').val(
\n\t $(this).parent().table2CSV({delivery:'value'}));
\n\t});
\n\t<\/code><\/p>\n<?php\r\nheader("Content-type: application\/octet-stream");\r\nheader("Content-Disposition: attachment; filename=\\"' . $_REQUEST['filename'] . '\\"");\r\n$data=stripcslashes($_REQUEST['csv_text']);\r\necho $data; \r\n?><\/code><\/pre>\ncsv = context.REQUEST.get('csv_text')
\n\tfilename = context.REQUEST.get('filename')
\n\tcontext.REQUEST.RESPONSE.setHeader('Content-type','application\/msexcel')
\n\tcontext.REQUEST.RESPONSE.setHeader('Content-disposition','inline; filename="' + filename + '"')
\n\treturn csv
\n\t<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"