| Next changeset 1:aa5f65234ff4 (2018-12-04) |
|
Commit message:
Uploaded |
|
added:
xlsx2tab.xml |
| b |
| diff -r 000000000000 -r 0f3606757c24 xlsx2tab.xml --- /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> |