Mercurial > repos > ylebras > xls2tabular
annotate xlsx2tab.R @ 6:aa529f924b86 draft
Uploaded
| author | ylebras |
|---|---|
| date | Tue, 04 Dec 2018 20:15:41 -0500 |
| parents | 97c4e2e4f07e |
| children | 25b2fb62d16a |
| 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 | |
| 6 | 7 newname<-args[1]+".xlsx" |
| 8 file.rename(args[1],newname) | |
| 9 sheet<-read_excel(newname,sheet=args[2]) | |
| 1 | 10 write.table(sheet,"out.tabular",sep="\t",row.names=FALSE) |
| 11 | |
| 12 } | |
| 13 |