Used for warning and error messages. Returns a printable string with the information where to find these missing, invalid, ... values in the XLSX file.
Arguments
- x
integer or logical, see 'Details'.
- n
integer, defaults to
5. Number of rows to be explicitly listed (if any).- offset
integer, number of additional header lines in the XLSX sheet to correct the row indicator (defaults to
1).- prefix
character or
NULL, default" Row".
Value
Character string with the information where suspicious values have been
found in the XLSX file. If there are no suspicious rows, FALSE is returned.
Details
If the input is of class integer it is assumed that the values correspond to the
observations in a data.frame. I.e, 1 is the first observation in the
data.frame.
If the input is a logical vector it is assumed that all entries being TRUE
are suspicious, and that the order corresponds to the observations in a data.frame.
The return value will point to these suspicous rows but in the context of an XLSX file
which typically has one additional header line (thus the default offset = 1L).