plugin:csv [DokuWiki]

<!DOCTYPE html> <html lang="en" dir="ltr" class="no-js"> <head> <meta charset="utf-8" /> <title>plugin:csv [DokuWiki]</title> <meta name="generator" content="DokuWiki"/> <meta name="theme-color" content="#008800"/> <meta name="robots" content="index,follow"/> <meta name="keywords" content="plugin,csv"/> <link rel="search" type="application/opensearchdescription+xml" href="/lib/exe/opensearch.php" title="DokuWiki"/> <link rel="start" href="/"/> <link rel="contents" href="/plugin:csv?do=index" title="Sitemap"/> <link rel="manifest" href="/lib/exe/manifest.php"/> <link rel="alternate" type="application/rss+xml" title="Recent Changes" href="/feed.php"/> <link rel="alternate" type="application/rss+xml" title="Current namespace" href="/feed.php?mode=list&ns=plugin"/> <link rel="edit" title="Edit this page" href="/plugin:csv?do=edit"/> <link rel="alternate" type="text/html" title="Plain HTML" href="/_export/xhtml/plugin:csv"/> <link rel="alternate" type="text/plain" title="Wiki Markup" href="/_export/raw/plugin:csv"/> <link rel="canonical" href="https://www.dokuwiki.org/plugin:csv"/> <link rel="stylesheet" href="/lib/exe/css.php?t=dokuwiki&tseed=f1005bad3d81fc9c803c7f93d32a390e"/> <script >var NS='plugin';var JSINFO = {"plugins":{"edittable":{"default columnwidth":""}},"id":"plugin:csv","namespace":"plugin","ACT":"show","useHeadingNavigation":0,"useHeadingContent":0};(function(H){H.className=H.className.replace(/\bno-js\b/,'js')})(document.documentElement);</script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.4/jquery.min.js" defer="defer"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.13.2/jquery-ui.min.js" defer="defer"></script> <script src="/lib/exe/js.php?t=dokuwiki&tseed=f1005bad3d81fc9c803c7f93d32a390e&lang=en" defer="defer"></script> <meta name="viewport" content="width=device-width,initial-scale=1" /> <link rel="shortcut icon" href="/lib/tpl/dokuwiki/images/favicon.ico" /> <link rel="apple-touch-icon" href="/lib/tpl/dokuwiki/images/apple-touch-icon.png" /> <meta name="verify-v1" content="OVxl3gsCv2MhZqh1cBQyl0JytWXSwXMjyvwc+4w3WtA=" /> <meta name="google-site-verification" content="YhTVK69hW94ZXUtc2zSLPxTkZKbZIn0zK67mz5WQB-E" />  <script async src="https://www.googletagmanager.com/gtag/js?id=UA-83791-1"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-83791-1', { 'anonymize_ip': true }); </script> </head> <body> <div id="dokuwiki__site"><div id="dokuwiki__top" class="site dokuwiki mode_show tpl_dokuwiki showSidebar hasSidebar">  <header id="dokuwiki__header"><div class="pad group"> <div class="headings group"> <ul class="a11y skip"> <li><a href="#dokuwiki__content">skip to content</a></li> </ul> <h1 class="logo"><a href="/start" accesskey="h" title="Home [h]"><img src="/lib/tpl/dokuwiki/images/logo.png" width="64" height="64" alt="" /><span>DokuWiki</span></a></h1> <p class="claim">It's better when it's simple</p> </div> <div class="tools group">  <div id="dokuwiki__usertools"> <h3 class="a11y">User Tools</h3> <ul> <li class="action login"><a href="/plugin:csv?do=login&sectok=" title="Log In" rel="nofollow"><span>Log In</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M10 17.25V14H3v-4h7V6.75L15.25 12 10 17.25M8 2h9a2 2 0 0 1 2 2v16a2 2 0 0 1-2 2H8a2 2 0 0 1-2-2v-4h2v4h9V4H8v4H6V4a2 2 0 0 1 2-2z"/></svg></a></li> </ul> </div>  <div id="dokuwiki__sitetools"> <h3 class="a11y">Site Tools</h3> <form action="/start" method="get" role="search" class="search doku_form" id="dw__search" accept-charset="utf-8"><input type="hidden" name="do" value="search" /><input type="hidden" name="id" value="plugin:csv" /><div class="no"><input name="q" type="text" class="edit" title="[F]" accesskey="f" placeholder="Search" autocomplete="on" id="qsearch__in" value="" /><button value="1" type="submit" title="Search">Search</button><div id="qsearch__out" class="ajax_qsearch JSpopup"></div></div></form> <div class="mobileTools"> <form action="/doku.php" method="get" accept-charset="utf-8"><div class="no"><input type="hidden" name="id" value="plugin:csv" /><select name="do" class="edit quickselect" title="Tools"><option value="">Tools</option><optgroup label="Page Tools"><option value="edit">Edit this page</option><option value="revisions">Old revisions</option><option value="backlink">Backlinks</option></optgroup><optgroup label="Site Tools"><option value="recent">Recent Changes</option><option value="media">Media Manager</option><option value="index">Sitemap</option></optgroup><optgroup label="User Tools"><option value="login">Log In</option></optgroup></select><button type="submit">></button></div></form> </div> <ul> <li class="action recent"><a href="/plugin:csv?do=recent" title="Recent Changes [r]" rel="nofollow" accesskey="r">Recent Changes</a></li><li class="action media"><a href="/plugin:csv?do=media&ns=plugin" title="Media Manager" rel="nofollow">Media Manager</a></li><li class="action index"><a href="/plugin:csv?do=index" title="Sitemap [x]" rel="nofollow" accesskey="x">Sitemap</a></li> </ul> </div> </div>  <div class="breadcrumbs"> <div class="trace"><span class="bchead">Trace:</span> <span class="bcsep">•</span> <span class="curid"><bdi><a href="/plugin:csv" class="breadcrumbs" title="plugin:csv">csv</a></bdi></span></div> </div> <hr class="a11y" /> </div></header> <div class="wrapper group">  <nav id="dokuwiki__aside" aria-label="Sidebar"><div class="pad aside include group"> <h3 class="toggle">Sidebar</h3> <div class="content"><div class="group"> <p> <strong>Learn about DokuWiki</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/features" class="wikilink1" title="features" data-wiki-id="features">Features</a> & <a href="/blogroll" class="wikilink1" title="blogroll" data-wiki-id="blogroll">reviews</a> </div> </li> <li class="level1"><div class="li"> <a href="/install" class="wikilink1" title="install" data-wiki-id="install">Installation guide</a></div> </li> <li class="level1"><div class="li"> <a href="/manual" class="wikilink1" title="manual" data-wiki-id="manual">User manual</a> & <a href="/wiki:syntax" class="wikilink1" title="wiki:syntax" data-wiki-id="wiki:syntax">syntax</a></div> </li> <li class="level1"><div class="li"> <a href="/changes" class="wikilink1" title="changes" data-wiki-id="changes">Release notes</a></div> </li> <li class="level1"><div class="li"> <a href="/faq" class="wikilink1" title="faq" data-wiki-id="faq">FAQ</a></div> </li> </ul> <p> <strong>Advanced Use</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/extensions" class="wikilink1" title="extensions" data-wiki-id="extensions">Extensions</a></div> </li> <li class="level1"><div class="li"> <a href="/development" class="wikilink1" title="development" data-wiki-id="development">Development manual</a></div> </li> </ul> <p> <strong>Corporate Use</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/faq:support" class="wikilink1" title="faq:support" data-wiki-id="faq:support">Get support</a></div> </li> <li class="level1"><div class="li"> <a href="/donate" class="wikilink1" title="donate" data-wiki-id="donate">Donations</a></div> </li> </ul> <p> <strong>Our Community</strong> </p> <ul> <li class="level1"><div class="li"> <a href="/teams:getting_involved" class="wikilink1" title="teams:getting_involved" data-wiki-id="teams:getting_involved">Get involved</a></div> </li> <li class="level1"><div class="li"> <a href="/dokuinstall" class="wikilink1" title="dokuinstall" data-wiki-id="dokuinstall">Users</a></div> </li> <li class="level1"><div class="li"> <a href="http://forum.dokuwiki.org" class="urlextern" title="http://forum.dokuwiki.org">User forum</a></div> </li> <li class="level1"><div class="li"> <a href="/mailinglist" class="wikilink1" title="mailinglist" data-wiki-id="mailinglist">Development mailinglist</a></div> </li> </ul> <hr /> <p> Follow us on <a href="https://phpc.social/@dokuwiki" class="urlextern" title="https://phpc.social/@dokuwiki">Mastodon</a> and other <a href="/social" class="wikilink1" title="social" data-wiki-id="social">social networks</a>. </p> <p> <a href="/privacy" class="wikilink1" title="privacy" data-wiki-id="privacy">Our Privacy Policy</a> </p> </div></div> </div></nav>  <main id="dokuwiki__content"><div class="pad group"> <div class="pageId"><span>plugin:csv</span></div> <div class="page group">   <div id="dw__toc" class="dw__toc"> <h3 class="toggle">Table of Contents</h3> <div> <ul class="toc"> <li class="level1"><div class="li"><a href="#csv_plugin">CSV Plugin</a></div> <ul class="toc"> <li class="level2"><div class="li"><a href="#description">Description</a></div></li> <li class="level2"><div class="li"><a href="#download">Download</a></div> <ul class="toc"> <li class="level3"><div class="li"><a href="#changes">Changes</a></div></li> <li class="level3"><div class="li"><a href="#enhancement_considerations">Enhancement Considerations</a></div></li> <li class="level3"><div class="li"><a href="#use_with_a_google_docs_spreadsheet">Use with a Google Docs Spreadsheet</a></div></li> </ul></li> </ul></li> </ul> </div> </div>  <h1 class="sectionedit1" id="csv_plugin">CSV Plugin</h1> <div class="level1"> <div class="pluginrepo_entry"><div class="usageInfo"><div class="compatibility"><p class="label">Compatible with DokuWiki</p><div class="versions"><ul><li class="yes">2024-02-06 "Kaos" <strong><span>yes</span></strong></li><li class="yes">2023-04-04 "Jack Jackrum" <strong><span>yes</span></strong></li><li class="yes">2022-07-31 "Igor" <strong><span>yes</span></strong></li><li class="yes">2020-07-29 "Hogfather" <strong><span>yes</span></strong></li></ul></div></div><ul class="actions"><li><a class="download" href="https://github.com/cosmocode/csv/zipball/master">Download</a></li><li><a class="bugs" href="https://github.com/cosmocode/csv/issues">Report bugs</a></li></ul><div class="clearer"></div></div><div class="mainInfo"><p class="description"><a class="media" href="/plugins"><img alt="plugin" class="medialeft" src="/lib/plugins/pluginrepo/images/dwplugin.png" width="60" height="60" /></a> Display CSV as table</p></div><div class="metaInfo"><dl><dt>Last updated on</dt><dd>2022-01-03</dd><dt>Provides</dt><dd><a href="/plugins?plugintype=1#extension__table" class="wikilink1" title="List all Syntax plugins">Syntax</a></dd><dt>Repository</dt><dd><a class="urlextern" href="https://github.com/cosmocode/csv">Source</a></dd></dl></div><div class="moreInfo"><p class="tags">Tagged with <a href="/plugins?plugintag=csv#extension__table" class="wikilink1" title="List all plugins with this tag">csv</a>, <a href="/plugins?plugintag=file#extension__table" class="wikilink1" title="List all plugins with this tag">file</a>, <a href="/plugins?plugintag=tables#extension__table" class="wikilink1" title="List all plugins with this tag">tables</a></p></div><div class="authorInfo"><strong>By <a href="mailto:dokuwiki%20%5Bat%5D%20cosmocode%20%5Bdot%5D%20de" class="mail" title="dokuwiki [at] cosmocode [dot] de">Andreas Gohr</a></strong><ul><li><a href="/plugin:clearhistory" class="wikilink1" title="plugin:clearhistory" data-wiki-id="plugin:clearhistory">clearhistory</a></li> <li><a href="/plugin:preview" class="wikilink1" title="plugin:preview" data-wiki-id="plugin:preview">preview</a></li> <li><a href="/plugin:explain" class="wikilink1" title="plugin:explain" data-wiki-id="plugin:explain">explain</a></li> <li><a href="/plugin:logstats" class="wikilink1" title="plugin:logstats" data-wiki-id="plugin:logstats">logstats</a></li> <li><a href="/plugin:oiddelegate" class="wikilink1" title="plugin:oiddelegate" data-wiki-id="plugin:oiddelegate">oiddelegate</a></li> <li><a href="/plugin:labeled" class="wikilink1" title="plugin:labeled" data-wiki-id="plugin:labeled">labeled</a></li> <li><a href="/plugin:slider" class="wikilink1" title="plugin:slider" data-wiki-id="plugin:slider">slider</a></li> <li><a href="/plugin:groupusers" class="wikilink1" title="plugin:groupusers" data-wiki-id="plugin:groupusers">groupusers</a></li> <li><a href="/plugin:navi" class="wikilink1" title="plugin:navi" data-wiki-id="plugin:navi">navi</a></li> <li><a href="/plugin:aclinfo" class="wikilink1" title="plugin:aclinfo" data-wiki-id="plugin:aclinfo">aclinfo</a></li> <li>and 127 more</li></ul></div></div> <p> This plugin was originally written by <a href="mailto:steven%20%5Bdash%5D%20danz%20%5Bat%5D%20kc%20%5Bdot%5D%20rr%20%5Bdot%5D%20com" class="mail" title="steven [dash] danz [at] kc [dot] rr [dot] com">Steven Danz</a>. The current version fixes security bugs and incorporates several patches by other contributors. </p> </div> <div class="secedit editbutton_section editbutton_1"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[CSV Plugin] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="csv_plugin" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="1-725" /><button type="submit" title="CSV Plugin">Edit</button></div></form></div> <h2 class="sectionedit2" id="description">Description</h2> <div class="level2"> <p> <a href="http://www.cosmocode.de/en/open-source/dokuwiki-plugins/" class="media" title="http://www.cosmocode.de/en/open-source/dokuwiki-plugins/"><img src="/lib/exe/fetch.php?cache=recache&tok=a307b5&media=https%3A%2F%2Fwww.cosmocode.de%2Fstatic%2Fimg%2Fdokuwiki%2Fdwplugins.png" class="mediaright" loading="lazy" title="A CosmoCode Plugin" alt="A CosmoCode Plugin" /></a> </p> <p> This is a simple plugin that will display CSV data in table form. The data can either be inline between <code><csv></code> and <code></csv></code> </p> <pre class="code"><csv> Number,Name,Details 1,Power Man,Blue 2,Red Book,"Yellow, but blue" </csv></pre> <p> or be read from a file in the media area using </p> <pre class="code"><csv namespace:test.csv></csv></pre> <p> You can also give an HTTP <abbr title="Uniform Resource Locator">URL</abbr> to a CSV file instead of an uploaded media file. </p> <p> If you are planning to use csv files in the media area, you will most likely need to include the .csv file extension in <a href="/mime" class="wikilink1" title="mime" data-wiki-id="mime">mime.local.conf</a> so you can upload .csv files. Something like this should get you started: </p> <dl class="code"> <dt><a href="/_export/code/plugin:csv?codeblock=2" title="Download Snippet" class="mediafile mf_conf">mime.local.conf</a></dt> <dd><pre class="code">csv text/csv</pre> </dd></dl> <p> The <code><csv></code> tag allows for additional options to be specified as well as a file reference. </p> <div class="table sectionedit3"><table class="inline"> <thead> <tr class="row0"> <th class="col0 leftalign"> Option </th><th class="col1 leftalign"> Description </th><th class="col2 leftalign"> Default value </th> </tr> </thead> <tr class="row1"> <td class="col0 leftalign"> <code>file=<filename></code> </td><td class="col1 leftalign"> where <code><filename></code> can be any <code><namespace:file.csv></code> or <code><http url></code>. The <code>file=</code> prefix is optional. Any option without a name is assumed to be the file name </td><td class="col2 centeralign"> <code></code> </td> </tr> <tr class="row2"> <td class="col0 leftalign"> <code>hdr_rows=<em><n></em></code> </td><td class="col1 leftalign"> Format the first <em><n></em> rows of data from the CSV as column headers </td><td class="col2 centeralign"> <code>1</code> </td> </tr> <tr class="row3"> <td class="col0 leftalign"> <code>hdr_cols=<em><n></em></code> </td><td class="col1 leftalign"> Format the first <em><n></em> columns of each row as column headers </td><td class="col2 centeralign"> <code>0</code> </td> </tr> <tr class="row4"> <td class="col0 leftalign"> <code>span_empty_cols=<em>[01]</em></code> </td><td class="col1 leftalign"> Create colspans for each empty (two adjacent commas) cell following a cell with content </td><td class="col2 centeralign"> <code>0</code> </td> </tr> <tr class="row5"> <td class="col0 leftalign"> <code>delim=<em><char></em></code> </td><td class="col1 leftalign"> The delimiter used between cells. Specify <code>tab</code> for a tab separated file. </td><td class="col2 centeralign"> <code>,</code> </td> </tr> <tr class="row6"> <td class="col0 leftalign"> <code>maxlines=<em><n></em></code> </td><td class="col1 leftalign"> limiting the result set to a certain number of rows </td><td class="col2 centeralign"> <code>0</code> </td> </tr> <tr class="row7"> <td class="col0 leftalign"> <code>offset=<em><n></em></code> </td><td class="col1 leftalign"> skipping the given number of rows before output </td><td class="col2 centeralign"> <code>0</code> </td> </tr> <tr class="row8"> <td class="col0 leftalign"> <code>filter[<em><n></em>][<em>t</em>]="<em><text></em>"</code> </td><td class="col1 leftalign"> Allows you to filter the rows.<br/> <br/> <em><n></em> is the column number you want to filter on. The first column is 1.<br/> <br/> <em>t</em> can either be an <code>g</code> for globbing or an <code>r</code> for regexp. Use simple <code>*</code> in the globbing mode to find partial texts. </td><td class="col2 leftalign"> </td> </tr> </table></div> <div class="secedit editbutton_table editbutton_3"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Table] " /><input type="hidden" name="target" value="table" /><input type="hidden" name="hid" value="table" /><input type="hidden" name="range" value="1685-4448" /><button type="submit" title="Table">Edit</button></div></form></div> <p> Cells that include a comma as part of the data are expected to be contained between double quotes, which is the typical behaviour of most systems when exporting .csv files. </p> <p> Empty lines in the csv file or data are displayed as horizontal separators in the table. </p> <p> Example for a table using a filter. This will look for values beginning with “P” in the third column. It will show the second line. </p> <pre class="code"><csv hdr_rows=0 filter[3][g]="P*"> ABC,DEF,GHI JKL,MNO,PQR </csv></pre> <p> There is a second syntax mode to grab a <strong>single value</strong> from a CSV. This mode does not support inline CSV data! </p> <pre class="code"><csvval some.csv output=3,1></pre> <p> In addition to all the options supported in the <code><csv></code> syntax, you have to specify which column and (optionally) which row you want to output. </p> </div> <div class="secedit editbutton_section editbutton_2"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Description] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="description" /><input type="hidden" name="codeblockOffset" value="0" /><input type="hidden" name="range" value="726-5233" /><button type="submit" title="Description">Edit</button></div></form></div> <h2 class="sectionedit4" id="download">Download</h2> <div class="level2"> <p> Search and install the plugin using the <a href="/plugin:extension" class="wikilink1" title="plugin:extension" data-wiki-id="plugin:extension">Extension Manager</a>. Refer to <a href="/plugins" class="wikilink1" title="plugins" data-wiki-id="plugins">Plugins</a> on how to install plugins manually. </p> <ul> <li class="level1"><div class="li"> <a href="https://github.com/cosmocode/csv/archive/master.zip" class="urlextern" title="https://github.com/cosmocode/csv/archive/master.zip">https://github.com/cosmocode/csv/archive/master.zip</a></div> </li> </ul> </div> <div class="secedit editbutton_section editbutton_4"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Download] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="download" /><input type="hidden" name="codeblockOffset" value="5" /><input type="hidden" name="range" value="5234-5451" /><button type="submit" title="Download">Edit</button></div></form></div> <h3 class="sectionedit5" id="changes">Changes</h3> <div class="level3"> <ul class="rss"><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/04fa173229cdc1caca63eed5d272c1b9147cb0c0" class="urlextern" title="https://github.com/cosmocode/csv/commit/04fa173229cdc1caca63eed5d272c1b9147cb0c0">Version upped</a> (2022-01-03 23:50)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/57057fc9eabf23a3615bb00b1f77fd422e23f925" class="urlextern" title="https://github.com/cosmocode/csv/commit/57057fc9eabf23a3615bb00b1f77fd422e23f925">code style cleanup</a> (2022-01-03 16:51)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/604ddcfae9bb49a17eddbaf338eee26c67968757" class="urlextern" title="https://github.com/cosmocode/csv/commit/604ddcfae9bb49a17eddbaf338eee26c67968757">test cleanup and PHP8 fixes</a> (2022-01-03 16:41)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/58ec2d571c421b06bc95afc52196fee16071511d" class="urlextern" title="https://github.com/cosmocode/csv/commit/58ec2d571c421b06bc95afc52196fee16071511d">wrap contents in thead and tbody tags</a> (2021-11-12 03:08)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/14b79c4546138003b3ebb67e7f4a80323486299d" class="urlextern" title="https://github.com/cosmocode/csv/commit/14b79c4546138003b3ebb67e7f4a80323486299d">Version upped</a> (2021-02-18 23:50)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/648ee3b5d04a9f4811ecdd6be04b2df5646200ac" class="urlextern" title="https://github.com/cosmocode/csv/commit/648ee3b5d04a9f4811ecdd6be04b2df5646200ac">Merge pull request #21 from alex-krippner/issue_plugin-csv-#19</a> (2021-02-18 16:53)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/1d5d721f98a5208e8033458afcffce107d5b48d9" class="urlextern" title="https://github.com/cosmocode/csv/commit/1d5d721f98a5208e8033458afcffce107d5b48d9">edited error message #19</a> (2021-02-18 14:39)</div></li><li><div class="li"><a href="https://github.com/cosmocode/csv/commit/030da14315b3303d460a582d45817b5fcf3824d2" class="urlextern" title="https://github.com/cosmocode/csv/commit/030da14315b3303d460a582d45817b5fcf3824d2">added error message when no filter results</a> (2021-02-17 13:47)</div></li></ul> </div> <div class="secedit editbutton_section editbutton_5"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Changes] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="changes" /><input type="hidden" name="codeblockOffset" value="5" /><input type="hidden" name="range" value="5452-5537" /><button type="submit" title="Changes">Edit</button></div></form></div> <h3 class="sectionedit6" id="enhancement_considerations">Enhancement Considerations</h3> <div class="level3"> <ul> <li class="level1"><div class="li"> is it possible to add a download-button so that the csv-file could be directly downloaded (especially for inline-data)</div> </li> <li class="level1"><div class="li"> might be nice to be able to have gridlines</div> </li> <li class="level1"><div class="li"> <del>Is it possible to put internal DokuWiki links in table cells to make them clickable?</del> see <a href="https://github.com/cosmocode/csv/issues/10" class="urlextern" title="https://github.com/cosmocode/csv/issues/10">Issue #10</a></div> </li> <li class="level1"><div class="li"> <del>External links within table cells</del> see <a href="https://github.com/cosmocode/csv/issues/10" class="urlextern" title="https://github.com/cosmocode/csv/issues/10">Issue #10</a></div> </li> <li class="level1"><div class="li"> <del>Other DokuWiki formatting (<strong>bold</strong>, <em>italic</em>, <em class="u">ul</em>, <a href="https://en.wikipedia.org/wiki/Interwiki links" class="interwiki iw_wp" title="https://en.wikipedia.org/wiki/Interwiki links">Interwiki links</a>) would be nice</del> see <a href="https://github.com/cosmocode/csv/issues/10" class="urlextern" title="https://github.com/cosmocode/csv/issues/10">Issue #10</a></div> </li> <li class="level1"><div class="li"> Selection of rows and columns would be great e.g. rows=1,5,6,7 <a href="https://github.com/cosmocode/csv/issues/1" class="urlextern" title="https://github.com/cosmocode/csv/issues/1">Issue #1</a></div> </li> <li class="level1"><div class="li"> Setting of column width would be great</div> </li> <li class="level1"><div class="li"> Justify right/align right</div> </li> <li class="level1"><div class="li"> Integration with the bootstrap theme → header is not in the right colour. Global style of the table looks different than if you use the default syntax.</div> </li> <li class="level1"><div class="li"> <del>Use of smileys (for example traffic light based on values)</del> see <a href="https://github.com/cosmocode/csv/issues/10" class="urlextern" title="https://github.com/cosmocode/csv/issues/10">Issue #10</a></div> </li> <li class="level1"><div class="li"> read data from a csv-file stored at Windows Shares like <a href="/wiki:syntax#windows_shares" class="wikilink1" title="wiki:syntax" data-wiki-id="wiki:syntax">windows_shares</a></div> </li> <li class="level1"><div class="li"> Add row/column header via parameter</div> </li> <li class="level1"><div class="li"> Make table sortable by different columns</div> </li> </ul> </div> <div class="secedit editbutton_section editbutton_6"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Enhancement Considerations] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="enhancement_considerations" /><input type="hidden" name="codeblockOffset" value="5" /><input type="hidden" name="range" value="5538-6851" /><button type="submit" title="Enhancement Considerations">Edit</button></div></form></div> <h3 class="sectionedit7" id="use_with_a_google_docs_spreadsheet">Use with a Google Docs Spreadsheet</h3> <div class="level3"> <p> The HTTP <abbr title="Uniform Resource Locator">URL</abbr> can be a shared Google Docs Spreadsheet. The following explains how to export a spreadsheet in CSV format via a <abbr title="Uniform Resource Locator">URL</abbr>. </p> <p> To link to a Google spreadsheet: </p> <ul> <li class="level1"><div class="li"> Open your spreadsheet in Google Docs.</div> </li> <li class="level1"><div class="li"> Click the “Share” botton in the toolbar, and choose “Anyone with the link” for Visibility. </div> </li> <li class="level1"><div class="li"> Open your spreadsheet in Google Docs.</div> </li> <li class="level1"><div class="li"> From the spreadsheet menu select: File | Publish as a Web Page</div> </li> <li class="level1"><div class="li"> Sheets to Publish: “All Sheets”, and check the box “Automatically republish when changes are made” to ensure your data is auto updated.</div> </li> <li class="level1"><div class="li"> Click “Start Publishing”. This will activate the options in the box “Get a link to the published data”, below.</div> </li> <li class="level1"><div class="li"> Change the export type from “Web Page” to “CSV (comma-separated values)”.</div> </li> <li class="level1"><div class="li"> Change “All sheets” to “Sheet1” (or select the sheet you want to export)</div> </li> <li class="level1"><div class="li"> Change “All Cells” to the specific range you want to export, beginning with the header row. Use Excel-style notation, like “A1:C6” for the first 3 columns and the first 6 rows.</div> </li> <li class="level1"><div class="li"> Click “Republish now”</div> </li> <li class="level1"><div class="li"> Copy the link (check it ends with output=csv) and paste it into your dokuwiki CSV table using the file= attribute described above.</div> </li> </ul> <p> Outline of steps adapted from: </p> <ul> <li class="level1"><div class="li"> <a href="http://blog.revolutionanalytics.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html" class="urlextern" title="http://blog.revolutionanalytics.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html">http://blog.revolutionanalytics.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html</a></div> </li> </ul> </div> <div class="secedit editbutton_section editbutton_7"><form class="button btn_secedit" method="post" action="/plugin:csv"><div class="no"><input type="hidden" name="do" value="edit" /><input type="hidden" name="rev" value="1732126495" /><input type="hidden" name="summary" value="[Use with a Google Docs Spreadsheet] " /><input type="hidden" name="target" value="section" /><input type="hidden" name="hid" value="use_with_a_google_docs_spreadsheet" /><input type="hidden" name="codeblockOffset" value="5" /><input type="hidden" name="range" value="6852-" /><button type="submit" title="Use with a Google Docs Spreadsheet">Edit</button></div></form></div>  </div> <div class="docInfo"><bdi>plugin/csv.txt</bdi> · Last modified: <time datetime="2024-11-20T19:14:55+0100">2024-11-20 19:14</time> by <bdi>tom45</bdi></div> <hr class="a11y" /> </div></main>  <nav id="dokuwiki__pagetools" aria-labelledby="dokuwiki__pagetools__heading"> <h3 class="a11y" id="dokuwiki__pagetools__heading">Page Tools</h3> <div class="tools"> <ul> <li class="edit"><a href="/plugin:csv?do=edit" title="Edit this page [e]" rel="nofollow" accesskey="e"><span>Edit this page</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M20.71 7.04c.39-.39.39-1.04 0-1.41l-2.34-2.34c-.37-.39-1.02-.39-1.41 0l-1.84 1.83 3.75 3.75M3 17.25V21h3.75L17.81 9.93l-3.75-3.75L3 17.25z"/></svg></a></li><li class="revs"><a href="/plugin:csv?do=revisions" title="Old revisions [o]" rel="nofollow" accesskey="o"><span>Old revisions</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M11 7v5.11l4.71 2.79.79-1.28-4-2.37V7m0-5C8.97 2 5.91 3.92 4.27 6.77L2 4.5V11h6.5L5.75 8.25C6.96 5.73 9.5 4 12.5 4a7.5 7.5 0 0 1 7.5 7.5 7.5 7.5 0 0 1-7.5 7.5c-3.27 0-6.03-2.09-7.06-5h-2.1c1.1 4.03 4.77 7 9.16 7 5.24 0 9.5-4.25 9.5-9.5A9.5 9.5 0 0 0 12.5 2z"/></svg></a></li><li class="backlink"><a href="/plugin:csv?do=backlink" title="Backlinks" rel="nofollow"><span>Backlinks</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M10.59 13.41c.41.39.41 1.03 0 1.42-.39.39-1.03.39-1.42 0a5.003 5.003 0 0 1 0-7.07l3.54-3.54a5.003 5.003 0 0 1 7.07 0 5.003 5.003 0 0 1 0 7.07l-1.49 1.49c.01-.82-.12-1.64-.4-2.42l.47-.48a2.982 2.982 0 0 0 0-4.24 2.982 2.982 0 0 0-4.24 0l-3.53 3.53a2.982 2.982 0 0 0 0 4.24m2.82-4.24c.39-.39 1.03-.39 1.42 0a5.003 5.003 0 0 1 0 7.07l-3.54 3.54a5.003 5.003 0 0 1-7.07 0 5.003 5.003 0 0 1 0-7.07l1.49-1.49c-.01.82.12 1.64.4 2.43l-.47.47a2.982 2.982 0 0 0 0 4.24 2.982 2.982 0 0 0 4.24 0l3.53-3.53a2.982 2.982 0 0 0 0-4.24.973.973 0 0 1 0-1.42z"/></svg></a></li><li class="top"><a href="#dokuwiki__top" title="Back to top [t]" rel="nofollow" accesskey="t"><span>Back to top</span><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path d="M13 20h-2V8l-5.5 5.5-1.42-1.42L12 4.16l7.92 7.92-1.42 1.42L13 8v12z"/></svg></a></li> </ul> </div> </nav> </div>  <footer id="dokuwiki__footer"><div class="pad"> <div class="license">Except where otherwise noted, content on this wiki is licensed under the following license: <bdi><a href="https://creativecommons.org/licenses/by-sa/4.0/deed.en" rel="license" class="urlextern">CC Attribution-Share Alike 4.0 International</a></bdi></div> <div class="buttons"> <a href="https://creativecommons.org/licenses/by-sa/4.0/deed.en" rel="license"><img src="/lib/images/license/button/cc-by-sa.png" alt="CC Attribution-Share Alike 4.0 International" /></a> <a href="https://www.dokuwiki.org/donate" title="Donate" ><img src="/lib/tpl/dokuwiki/images/button-donate.gif" width="80" height="15" alt="Donate" /></a> <a href="https://php.net" title="Powered by PHP" ><img src="/lib/tpl/dokuwiki/images/button-php.gif" width="80" height="15" alt="Powered by PHP" /></a> <a href="//validator.w3.org/check/referer" title="Valid HTML5" ><img src="/lib/tpl/dokuwiki/images/button-html5.png" width="80" height="15" alt="Valid HTML5" /></a> <a href="//jigsaw.w3.org/css-validator/check/referer?profile=css3" title="Valid CSS" ><img src="/lib/tpl/dokuwiki/images/button-css.png" width="80" height="15" alt="Valid CSS" /></a> <a href="https://dokuwiki.org/" title="Driven by DokuWiki" ><img src="/lib/tpl/dokuwiki/images/button-dw.png" width="80" height="15" alt="Driven by DokuWiki" /></a> </div> <div style="margin-top: 2em; font-size:90%" class="dokuwiki"><div style="float:right"><a href="http://www.splitbrain.org/personal#imprint" style="float:right; text-decoration: none; color:#333">Imprint</a></div></div> <style type="text/css"> @media screen { body { padding-top: 30px; } #global__header { position: absolute; top: 0; left: 0; text-align: left; vertical-align: middle; line-height: 1.5; background-color: #333; box-shadow: 0 0 8px rgba(0,0,0,0.5); width: 100%; margin: 0; padding: 5px 20px; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; white-space: nowrap; overflow: hidden; } #global__header h2 { position: absolute; left: -99999em; top: 0; overflow: hidden; display: inline; } #global__header ul, #global__header li { margin: 0; padding: 0; list-style: none; display: inline; line-height: 1.5; } #global__header a { color: #bbb; text-decoration: none; margin-right: 20px; font-size: 14px; font-weight: normal; } #global__header a:hover, #global__header a:active, #global__header a:focus { color: #fff; text-decoration: underline; } #global__header form { float: right; margin: 0 0 0 20px; } #global__header input { background-color: #333; background-image: none; border: 1px solid #bbb; color: #fff; box-shadow: none; border-radius: 2px; margin: 0; line-height: normal; padding: 1px 0 1px 0; height: auto; } #global__header input.button { border: none; color: #bbb; } #global__header input.button:hover, #global__header input.button:active, #global__header input.button:focus { color: #fff; text-decoration: underline; } } /* /@media */ @media only screen and (min-width: 601px) { /* changes specific for www.dokuwiki.org */ #dokuwiki__header { padding-top: 3em; } #dokuwiki__usertools { top: 3em; } /* changes specific for bugs.dokuwiki.org */ div#container div#showtask { top: 40px; } } /* /@media */ @media only screen and (max-width: 600px) { body { padding-top: 0; } #global__header { position: static; white-space: normal; overflow: auto; } #global__header form { float: none; display: block; margin: 0 0 .4em; } } /* /@media */ @media print { #global__header { display: none; } } /* /@media */ </style> <div id="global__header"> <h2>Global DokuWiki Links</h2> <form method="get" action="https://search.dokuwiki.org/" target="_top"> <input type="text" name="q" title="Search all DokuWiki sites at once" class="input" /> <input type="submit" title="Search all DokuWiki sites at once" value="Search" class="button" /> </form> <ul> <li><a href="https://download.dokuwiki.org" title="Download the latest release" target="_top">Download</a></li> <li><a href="https://www.dokuwiki.org" title="Read the DokuWiki documentation" target="_top">Wiki</a></li> <li><a href="https://forum.dokuwiki.org" title="Ask questions in the DokuWiki forum" target="_top">Forum</a></li> <li><a href="https://irc.dokuwiki.org" title="Check IRC chat logs or join the chat" target="_top">IRC</a></li> <li><a href="https://github.com/splitbrain/dokuwiki/issues" title="Report and track bugs" target="_top">Bugs</a></li> <li><a href="https://translate.dokuwiki.org/" title="Help translating the DokuWiki interface" target="_top">Translate</a></li> <li><a href="https://github.com/splitbrain/dokuwiki" title="Access the most recent git commits" target="_top">Git</a></li> <li><a href="https://xref.dokuwiki.org/reference/dokuwiki/" title="Cross-Reference of the DokuWiki source code" target="_top">XRef</a></li> <li><a href="https://codesearch.dokuwiki.org/" title="Search through the sources of DokuWiki, plugins and templates" target="_top">Code Search</a></li> </ul> </div>  </div></footer> </div></div> <div class="no"><img src="/lib/exe/taskrunner.php?id=plugin%3Acsv&1744225621" width="2" height="1" alt="" /></div> <div id="screen__mode" class="no"></div></body> </html>

CINXE.COM

plugin:csv [DokuWiki]