annotate xlsx2tab.R @ 8:0dc610053f6d draft

Uploaded
author ylebras
date Tue, 04 Dec 2018 20:26:44 -0500
parents 25b2fb62d16a
children 74d5dc8f7465
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
1 #!/usr/bin/env Rscript
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
2 #Read Xlsx sheets - return tabular
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
3 library(readxl)
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
4
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
5 args = commandArgs(trailingOnly=TRUE)
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
6
7
25b2fb62d16a Uploaded
ylebras
parents: 6
diff changeset
7 newname<-paste(args[1], "xlsx", sep=".")
8
0dc610053f6d Uploaded
ylebras
parents: 7
diff changeset
8 file.copy(args[1],newname, overwrite=TRUE)
6
aa529f924b86 Uploaded
ylebras
parents: 4
diff changeset
9 sheet<-read_excel(newname,sheet=args[2])
1
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
10 write.table(sheet,"out.tabular",sep="\t",row.names=FALSE)
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
11
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
12 }
aa5f65234ff4 Uploaded
ylebras
parents:
diff changeset
13