view xlsx2tab.R @ 8:0dc610053f6d draft

Uploaded
author ylebras
date Tue, 04 Dec 2018 20:26:44 -0500
parents 25b2fb62d16a
children 74d5dc8f7465
line wrap: on
line source

#!/usr/bin/env Rscript
#Read Xlsx sheets - return tabular
library(readxl)

args = commandArgs(trailingOnly=TRUE)

newname<-paste(args[1], "xlsx", sep=".")
file.copy(args[1],newname, overwrite=TRUE)
sheet<-read_excel(newname,sheet=args[2])
write.table(sheet,"out.tabular",sep="\t",row.names=FALSE)

}