Mercurial > repos > ylebras > xls2tabular
changeset 18:cba112c87a55 draft
Deleted selected files
| author | ylebras |
|---|---|
| date | Wed, 05 Dec 2018 16:03:09 -0500 |
| parents | cb2493afd265 |
| children | 09ebc5a5cdc3 |
| files | xlsx2tab.R xlsx2tab.xml |
| diffstat | 2 files changed, 0 insertions(+), 63 deletions(-) [+] |
line wrap: on
line diff
--- a/xlsx2tab.R Wed Dec 05 16:02:11 2018 -0500 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,8 +0,0 @@ -#!/usr/bin/env Rscript -#Read xls sheets - return tabular -library(readxl) - -args = commandArgs(trailingOnly=TRUE) - -sheet<-read_excel(args[1],sheet=args[2]) -write.table(sheet,"out.tabular",sep="\t",row.names=FALSE) \ No newline at end of file
--- a/xlsx2tab.xml Wed Dec 05 16:02:11 2018 -0500 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,55 +0,0 @@ -<tool id="xls2tab_R" name="XLS 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="excel.xls" name="input1" type="data" label="XLS 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 XLS file to a tabular file. - - ------- - -**Example** - -Input XLS with a sheet named 'données in situ' - -Output tabular - - ------- - -**Arguments** - -Input: xls file. -Excel sheet name: données in situ - - - - - </help> -</tool>