{"id":26107,"date":"2010-01-12T18:54:20","date_gmt":"2010-01-12T22:54:20","guid":{"rendered":"https:\/\/www.bu.edu\/tech\/?page_id=26107"},"modified":"2011-04-12T17:57:38","modified_gmt":"2011-04-12T21:57:38","slug":"spreadsheet","status":"publish","type":"page","link":"https:\/\/www.bu.edu\/tech\/services\/cccs\/websites\/www\/non-wordpress\/marconi\/how-to\/spreadsheet\/","title":{"rendered":"How to Output to a Spreadsheet"},"content":{"rendered":"<p>On this page:<\/p>\n<ul>\n<li><a href=\"#csv\">Output to a Spreadsheet (CSV format)<\/a><\/li>\n<li><a href=\"#tab\">Output to a Spreadsheet (tab-delimited format)<\/a><\/li>\n<\/ul>\n<p><a name=\"csv\"><\/a><\/p>\n<h3>Output to a Spreadsheet (CSV format)<\/h3>\n<ol>\n<li><code>Add this line of code to your Telegraph configuration file:<br \/>\n&lt;directive action=\"file\" filename=\"<strong>filename-relative-to-form<\/strong>\" format=\"csv\" fields=\"<strong>field-names-separated-by-commas<\/strong>\" <span style=\"font-weight: normal;\"> \/&gt;<\/span><\/code><\/li>\n<li>Replace <strong>filename-relative-to-form<\/strong> with the name of your output file (including any relative path information) and <strong>field-names-separated-by-commas<\/strong> with any field(s) which will be output to the spreadsheet file.\n<ul>\n<li>Example:<br \/>\n<code>&lt;directive action=\"file\" filename=\"output\/military.csv\" format=\"csv\" fields=\"name,rank,serial-number\" \/&gt;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><a name=\"tab\"><\/a><\/p>\n<h3>Output to a Spreadsheet (tab-delimited format)<\/h3>\n<ol>\n<li>Add this line of code to your Telegraph configuration file:<br \/>\n<code>&lt;directive action=\"file\" filename=\"<strong>filename-relative-to-form<\/strong>\" format=\"tab-delimited\" fields=\"<strong>field-names-separated-by-commas<\/strong>\" \/&gt;<\/code><\/li>\n<li><span style=\"font-weight: normal;\">Replace <strong>filename-relative-to-form<\/strong> with the name of your output file (including any relative path information) and <strong>field-names-separated-by-commas<\/strong> with any field(s) which will be output to the spreadsheet file.<\/span>\n<ul>\n<li>Example:<br \/>\n<code>&lt;directive action=\"file\" filename=\"output\/military.xls\" format=\"tab-delimited\" fields=\"name,rank,serial-number\" \/&gt;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>On this page: Output to a Spreadsheet (CSV format) Output to a Spreadsheet (tab-delimited format) Output to a Spreadsheet (CSV format) Add this line of code to your Telegraph configuration file: &lt;directive action=&#8221;file&#8221; filename=&#8221;filename-relative-to-form&#8221; format=&#8221;csv&#8221; fields=&#8221;field-names-separated-by-commas&#8221; \/&gt; Replace filename-relative-to-form with the name of your output file (including any relative path information) and field-names-separated-by-commas with any&#8230;<\/p>\n","protected":false},"author":1282,"featured_media":0,"parent":26082,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/26107"}],"collection":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/users\/1282"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/comments?post=26107"}],"version-history":[{"count":16,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/26107\/revisions"}],"predecessor-version":[{"id":44802,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/26107\/revisions\/44802"}],"up":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/26082"}],"wp:attachment":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/media?parent=26107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}