1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/readData.R
\name{read.xls.idframe}
\alias{read.xls.idframe}
\title{Read the contents of a worksheet into a idframe object}
\usage{
read.xls.idframe(file, sheetName, header = TRUE, ninputs = 0, Ts = 1,
unit = c("seconds", "minutes", "hours", "days")[1], ...)
}
\arguments{
\item{file}{the path to the file to read}
\item{sheetName}{a character string with the sheet name}
\item{header}{a logical value indicating whether the first row corresponding to
the first element of the rowIndex vector contains the names of the variables.}
\item{ninputs}{the number of input columns. (Default: 0)}
\item{Ts}{sampling interval (Default: 1)}
\item{unit}{Time Unit (Default: "seconds")}
\item{...}{additional arguments to be passed to the \code{\link[xlsx]{read.xlsx2}} function}
}
\value{
an idframe object
}
\description{
Read the contents of an excel worksheet into a \code{idframe} object.
}
\details{
The \code{read.xlsx.idframe} function uses the \code{\link[xlsx]{read.xlsx2}} function,
provided by the \pkg{xlsx} package, to read data from an excel file and then calls the
\code{\link{read.idframe}} function to read the data into a idframe object
The function requires the java runtime to be installed on the system (Requirement of
the \pkg{xlsx} package).
}
\examples{
library(xlsx)
dataMatrix <- data.frame(matrix(rnorm(1000),ncol=5))
colnames(dataMatrix) <- c("u1","u2","y1","y2","y3")
write.xlsx2(dataMatrix,file="test.xlsx",row.names=FALSE)
data <- read.xls.idframe("test.xlsx","Sheet1",ninputs=2,unit="minutes")
}
\seealso{
\code{\link[xlsx]{read.xlsx2}}
}
|
