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
53
54
55
56
57
58
59
60
61
62
63
64
|
% Generated by roxygen2 (4.1.1): 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 = NULL,
type = c("time", "freq")[1], Ts = 1, freqData = FALSE, tUnit = "time",
...)
}
\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.
(Default: \code{TRUE})}
\item{ninputs}{the number of input columns. (Default: \code{NULL})}
\item{type}{indicates the domain of the data (Default:\code{"time"})}
\item{Ts}{sampling interval (Default: 1)}
\item{freqData}{a logical value indicating whether the file contains the list of
frequencies. If \code{TRUE}, they need to be present in the first column.
(Default: \code{idframe})}
\item{tUnit}{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
If \code{type="freq"} and \code{freqData = TRUE}, then the first column in the file
should contain the frequencies.
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,tUnit="min")
}
\seealso{
\code{\link[xlsx]{read.xlsx2}}
}
|
