Hi All,

I want to know how to open SNP nexus output excel files with R? I tried ‘readxl’, ‘gdata’ and some other R package, all of them failed.

test dataset: https://github.com/Shicheng-Guo/biostars/blob/master/snpnexus_58242.xls

library(openxlsx)
data<-read_xlsx("snpnexus_58242.xls",sheet=1)
data<-read_excel("snpnexus_58242.xls",sheet=1)
data<-read_xls("snpnexus_58242.xls",sheet=1)

library("xlsx")
data<-read.xlsx("snpnexus_58242.xls",1)
data<-read.xlsx2("snpnexus_58242.xls",1)

All of the above are failed.

Okay. Done! Find the solution. When you save the result, don't save the excel, download each txt one by one.

Thanks.