Mercurial > repos > ylebras > xls2tabular

changeset 0:0f3606757c24 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author ylebras
date Tue, 04 Dec 2018 19:29:21 -0500
parents
children aa5f65234ff4
files xlsx2tab.xml
diffstat 1 files changed, 61 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/xlsx2tab.xml	Tue Dec 04 19:29:21 2018 -0500
@@ -0,0 +1,61 @@
+<tool id="xlsx2tab_R" name="XLSX sheet to Tabular" version="0.1">
+    <requirements>
+        <requirement type="package" version="3.2.1">R</requirement>
+		<requirement type="package" version="1.1.0">r-readxl</requirement>
+    </requirements>
+    <command detect_errors="exit_code"><![CDATA[
+        Rscript '$__tool_directory__/xlsx2tab.R' '$input1' '$sheet' '$output' ]]>
+    </command>
+    <inputs>
+        <param format="xlsx" name="input1" type="data" label="XLSX file"/>
+        <param name="sheet" type="text" label="Excel sheet name" value="biodiv_data">
+            <sanitizer sanitize="False"/>
+        </param>
+
+    </inputs>
+
+    <outputs>
+        <data format="tabular" name="output" from_work_dir="out.tabular" />
+    </outputs>
+    
+    <tests>
+        <test>
+            <param name="input1" value="example_csv.csv"/>
+            <param name="sheet" value=","/>
+            <output name="output" file="out.tabular"/>
+        </test>
+    </tests>
+
+    <help>
+**What it does**
+
+Extract a sheet from XLSX file to a tabular file.
+
+
+------
+
+**Example**
+
+Input XLSX sheet
+
+
+
+Output tabular :
+
+	"John"	"Smith"	"2 mySteet, myCity"
+
+	"François"	"LeFrançais"	"1 rue du Général, Paris"
+
+	"Other"	"Random"	"Stuff, stuff, stuff"
+
+------
+
+**Arguments**
+
+Input : xlsx file.
+
+
+
+
+    </help>
+</tool>