dbImportXLSX

A 'SQLite' database is designed to store all information
of experiment-based data including metadata, experiment design,
managements, phenotypic values and climate records. The dataset can be
imported from an 'Excel' file.

Bangyou Zheng

expDB

Database for Experiment Dataset

dbImportXLSX function

<dl><dt>con</dt>
<dd>a connection object as produced by dbConnect</dd>
<dt>xlsx</dt>
<dd>The path to excel file</dd>
<dt>ignore_genotype</dt>
<dd>Ignore genotype tables when importing</dd>
<dt>ignore_trait</dt>
<dd>Ignore trait table when importing</dd>
<dt>...</dt>
<dd>Other arguments. Supported arguments include<ul>
<li>extra_design: Extra columns in the experiment design.</li>
<li>tz: The time zone for the hourly climates.</li>
</ul></dd></dl>

Arguments

Import data from excel file — dbImportXLSX

<dl>

<dt>con</dt>
<dd>a connection object as produced by dbConnect</dd>


<dt>xlsx</dt>
<dd>The path to excel file</dd>


<dt>ignore_genotype</dt>
<dd>Ignore genotype tables when importing</dd>


<dt>ignore_trait</dt>
<dd>Ignore trait table when importing</dd>


<dt>...</dt>
<dd>Other arguments. Supported arguments include<ul>
<li>extra_design: Extra columns in the experiment design.</li>
<li>tz: The time zone for the hourly climates.</li>
</ul></dd>

</dl>

dbImportXLSX: Import data from excel file

Description

Usage

Value

Arguments