XploRe Help : readxls

Keywords - Function groups - @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Library:	xplore
See also:	readxlsm readm writem readcsv readcsvm writecsv readascii read write

Quantlet:		readxls
Description:		reads numerical data from a MS Excel file

Usage:	`z=readxls(filename{,rrow,rcol})`
Input:
	`filename`	string, name of the file
	`rrow`	(optional) p1 x 2 matrix (if you enter a scalar, it will be ignored); specifies, which rows should be read. Every row consists of two numbers, r1 and r2: 1) if both numbers are positive, they specify that rows with indices {r1,...,r2} should be read in; 2) if both number are negative, they specify that rows with indices {\|r1\|,...,\|r2\|} should be excluded from reading; 3) it is not possible to mix inclusion and exclusion conditions. If the parameter is omitted or is a scalar, all rows are read.
	`rcol`	(optional) p2 x 2 matrix (if you enter a scalar, it will be ignored); specifies, which columns should be read. Every column consists of two numbers, r1 and r2: 1) if both numbers are positive, they specify that columns with indices {r1,...,r2} should be read in; 2) if both number are negative, they specify that columns with indices {\|r1\|,...,\|r2\|} should be excluded from reading; 3) it is not possible to mix inclusion and exclusion conditions. If the parameter is omitted or is a scalar, all columns are read.
Output:
	`z`	matrix, contains the numerical elements of the first sheet of the MS Excel file

Note:

The columns and rows specified by matrices rcol and rrow are read and output in the same order as they are in the file, i.e., as if the entries of rcol and rrow are sorted.

Redistributions of any form whatsoever must retain the following acknowledgment: This product includes software developed by David Giffin <david@giffin.org>.

Example:

library("xplore") readxls("excsv.xls")

Result:

Contents of string
[1,] "readm: Found    4 line(s) and    3 column(s)"

Contents of z
[1,]        2        3     +NAN
[2,]        3     +NAN        7
[3,]        4        4        8
[4,]        5        5        9

Example:

library("xplore") readxls("excsv.xls", -1~-1)

Result:

The same example as before is used, but now the first
row is omitted. Notice that the separator is an empty
string, so that the default separators are used.

Contents of string
[1,] "readm: Found    3 line(s) and    3 column(s)"

Contents of z
[1,]        3     +NAN        7
[2,]        4        4        8
[3,]        5        5        9

Author: P. Cizek, 20021220 license MD*Tech