Read GenAlEx Files Directly from Excel

GenAlEx is a popular Excel macro for genetic analysis and the 'poppr' R package allows import of GenAlEx formatted CSV data for genetic data analysis in R. This package allows for the import of GenAlEx formatted Excel files, serving as a small 'poppr' add on for those who have trouble or simply do not want to export their data into CSV format.

On CRAN:

A small package that allows import of GenAlEx data directly into poppr from excel.

Setup is simple.

From CRAN:

install.packages("popprxl")

From GitHub:

install.packages("devtools")
install_github("zkamvar/popprxl", build_vignettes = TRUE)

popprxl has one function: read.genalexcel(). It can be used to read in GenAlEx data directly from excel:

library("popprxl")
#> Loading required package: adegenet
#> Loading required package: ade4
#> 
#>    /// adegenet 2.0.1 is loaded ////////////
#> 
#>    > overview: '?adegenet'
#>    > tutorials/doc/questions: 'adegenetWeb()' 
#>    > bug reports/feature requests: adegenetIssues()
#> This is poppr version 2.1.1. To get started, type package?poppr
#> OMP parallel support: unavailable
#> 
#> popprxl is loaded. Use read.genalexcel() to read in your data.
(nancyxlsx <- system.file("files/nancycats.xlsx", package = "popprxl"))
#> [1] "/Users/zhian/R/popprxl/files/nancycats.xlsx"
(nancy    <- read.genalexcel(nancyxlsx))
#> 
#> This is a genclone object
#> -------------------------
#> Genotype information:
#> 
#>    237 original multilocus genotypes 
#>    237 diploid individuals
#>      9 codominant loci
#> 
#> Population information:
#> 
#>      1 stratum - Pop
#>     17 populations defined - P01 P02 P03 ... P15 P16 P17