Mercurial > repos > ylebras > xls2tabular

changeset 26:ff26178d8dfe draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author ylebras
date Thu, 06 Dec 2018 12:37:58 -0500
parents f815b52e9bb6
children 847321a98092
files xls2tab.R
diffstat 1 files changed, 8 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/xls2tab.R	Thu Dec 06 12:37:58 2018 -0500
@@ -0,0 +1,8 @@
+#!/usr/bin/env Rscript
+#Read xls/xlsx 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