Mercurial > repos > ylebras > xls2tabular
annotate xlsx2tab.R @ 5:5251f7e929a6 draft
Uploaded
| author | ylebras |
|---|---|
| date | Tue, 04 Dec 2018 20:01:50 -0500 |
| parents | 97c4e2e4f07e |
| children | aa529f924b86 |
| rev | line source |
|---|---|
| 1 | 1 #!/usr/bin/env Rscript |
| 2 #Read Xlsx sheets - return tabular | |
| 3 library(readxl) | |
| 4 | |
| 5 args = commandArgs(trailingOnly=TRUE) | |
| 6 | |
| 4 | 7 file.rename(args[1],"input.xlsx") |
| 8 sheet<-read_excel("input.xlsx",sheet=args[2]) | |
| 1 | 9 write.table(sheet,"out.tabular",sep="\t",row.names=FALSE) |
| 10 | |
| 11 } | |
| 12 |