*! version 1.22 25jan2013
help xls2row (Stas Kolenikov's webpage)

Title

xls2row -- Convert a range of cells of an Excel file
to ipfraking-compatible matrix

Syntax

xls2row matrix_name using filename
[, options]

cellrange() range of cells in Excel file, e.g., B2:D15

sheet() the name of the sheet in Excel file to take values from

over(varname) label the columns of the resulting row vector
with the values of varname

scale(#) scale the entries of the row vector so that they sum up
to the specified value

Description

xls2row is a utility program in ipfraking package that reads
the calibration totals from an Excel file and stores them in the matrix
matrix_name.
The name of the Excel file, the range of cells and the name of the sheet
to take the values from are required.
Mathematically speaking, xls2row performs a vec-transformation
of the matrix, i.e., stores the result by columns.
The rowname of the resulting matrix is the convention name _one.

CAUTION: xls2row relies on preserve as an intermediate
step. It is advisable to run xls2row upfront before loading potentially
large datasets that would otherwise be written to disk and restored back
a number of times.

Author

Stanislav Kolenikov

Senior Survey Statistician

Abt SRBI

skolenik at gmail dot com

Also see

import excel, matrix rownames, ipfraking if installed.