|
averyLabel()
|
Generate labels for avery products |
|
checkAlias()
|
Get index id by name. |
|
createBarcode()
|
Create labels with barcode |
|
dbAddDesigns()
|
Add design for a trial |
|
dbAddFertilization()
|
Insert or Update fertilization into expDB |
|
dbAddGene()
|
Add gene information into database |
|
dbAddGeneAllele()
|
Add gene allele information into database |
|
dbAddGenotype()
|
Add genotypes into expDB |
|
dbAddIrrigatons()
|
Insert or Update irrigation into expDB |
|
dbAddLog()
|
Add log from expDB |
|
dbAddMethods()
|
Insert or Update methods into expDB |
|
dbAddMets()
|
Insert and update met into expDB |
|
dbAddNodes()
|
Add nodes into expDB |
|
dbAddPhenotype()
|
Add design for a trial |
|
dbAddResearcher()
|
Insert and update researcher into expDB |
|
dbAddSites()
|
Insert or update site into expDB |
|
dbAddSource()
|
Insert and update source into expDB |
|
dbAddTraits()
|
Insert or update trait into expDB |
|
dbAddTrialSoil()
|
Add soil for a trial |
|
dbAddTrials()
|
Insert or Update trial into expDB |
|
dbAddWeather()
|
Add weather records into expDB |
|
dbAppendTable()
|
Append a table into db and check the column name |
|
dbExportMet()
|
Export trials weather records to met file |
|
dbGenotypeCheckName()
|
Check genotype names |
|
dbGetDBName()
|
Get the database file name |
|
dbGetDryWeightPerStem()
|
Get the dry weight per stem |
|
dbGetFertilization()
|
Get fertilization from database |
|
dbGetFieldMaturity()
|
Estimation of maturity |
|
dbGetFieldPopulation()
|
Estimation of plant populations |
|
dbGetFieldStemNumber()
|
Estimation of stem number per unit area |
|
dbGetFieldTillerNumber()
|
Estimation of tiller number per unit area |
|
dbGetGene()
|
Get the gene information |
|
dbGetGenotype()
|
Get the genotype information |
|
dbGetIrrigation()
|
Get irrigation from database |
|
dbGetLog()
|
Get log from expDB |
|
dbGetMetInfo()
|
Get met information |
|
dbGetOrganFinalLeafNumber()
|
Get the final leaf number |
|
dbGetOrganHaunIndex()
|
Get Haun Index |
|
dbGetPhenotype()
|
Get phenotype values through a group of conditions |
|
dbGetPhenotype_()
|
Get phenotype values through a group of conditions |
|
dbGetPlantFlowering()
|
Estimation of flowering time |
|
dbGetPlantHeading()
|
Estimation of heading time |
|
dbGetPlantStemElongation()
|
Estimation of stem elongation |
|
dbGetPlantStemNumber()
|
Estimation of stem number per plant |
|
dbGetPlantTillerNumber()
|
Estimation of tiller number per plant |
|
dbGetSites()
|
Get site into expDB |
|
dbGetSource()
|
Get source from expDB |
|
dbGetStemTillerNumber()
|
Estimation of stem/tiller number per unit area or plant |
|
dbGetTraits()
|
Get trait list |
|
dbGetTreatmentColumns()
|
Get the unique columns for a treatment |
|
dbGetTrials()
|
Get trials by a groups of conditions. |
|
dbGetWeather()
|
Get weather records from expDB |
|
dbGetZadoksStage()
|
Obtain the key phenology stage |
|
dbImportXLSX()
|
Import data from excel file |
|
dbInsertUpdateByRow()
|
Insert new rows or update existing rows to a specific table according to a specific column (unique) by each row |
|
dbListTrials()
|
List all trials |
|
defaultMeasurement()
|
Import a normal measurement |
|
expdbConnect()
|
Connect to expDB |
|
expdbCreateDB()
|
create to expDB |
|
expdbDisconnect()
|
Didconnect to expDB |
|
generateName()
|
Generate unique name with digest method |
|
getAlias()
|
Alias of column names |
|
getIdByUniqueIndex()
|
Get index id by unique_columns. |
|
harvestQuadratDetail()
|
Process quadrat (detail) harvestQuadratDetail |
|
measurementLeafSize()
|
Import the measurement of leaf size |
|
sqlIn()
|
Paste a vector to format used for SQL in |
|
system_file()
|
#' Write tables into xlsx files
#'
#' @param file The xlsx file
#' @param ... Pairs of table and values
#' @export
write2Xlsx <- function(file, ...)
tbls <- list(...)
sheet_name <- names(tbls)
newWB <- XLConnect::loadWorkbook(filename = file, create = TRUE)
for(i in seq(along = tbls))
XLConnect::createSheet(newWB, name = sheet_name[i])
writeWorksheet(
newWB,
data = as.data.frame(tbls[[i]]),
sheet = sheet_name[i],
header = TRUE,
rownames = NULL)
saveWorkbook(newWB)
System based file path |
|
xlsxToR()
|
Read xlsx files |
|
yearDay2Date()
|
Convert year and day of year to date |