Mercurial > repos > ylebras > xls2tabular
comparison xlsx2tab.R @ 4:97c4e2e4f07e draft
Uploaded
author | ylebras |
---|---|
date | Tue, 04 Dec 2018 20:01:34 -0500 |
parents | aa5f65234ff4 |
children | aa529f924b86 |
comparison
equal
deleted
inserted
replaced
3:f5bc9bda73b7 | 4:97c4e2e4f07e |
---|---|
2 #Read Xlsx sheets - return tabular | 2 #Read Xlsx sheets - return tabular |
3 library(readxl) | 3 library(readxl) |
4 | 4 |
5 args = commandArgs(trailingOnly=TRUE) | 5 args = commandArgs(trailingOnly=TRUE) |
6 | 6 |
7 sheet<-read_excel(args[1],sheet=args[2]) | 7 file.rename(args[1],"input.xlsx") |
8 sheet<-read_excel("input.xlsx",sheet=args[2]) | |
8 write.table(sheet,"out.tabular",sep="\t",row.names=FALSE) | 9 write.table(sheet,"out.tabular",sep="\t",row.names=FALSE) |
9 | 10 |
10 } | 11 } |
11 | 12 |