Package 'rpxl'

Path to an Excel workbook file (either .xlsx, .xlsm, or .xlsb)

Workbook password

Output path for decrypted workbook

Name of Python environment to install within. Defaults to "r-rpxl".

Logical indicating whether to remove an existing virtual environment, if it has the name as envname, before creating the new virtual environment and installing the required Python packages.

Installation method. Defaults to "auto" to automatically find a method that will work in the local environment.

Additional arguments passed to reticulate::py_install

Path to the xlsb workbook

Workbook password

Name or index of the sheet to read. If the sheet name is specified as part of the range, this parameter is ignored

A named range or a string representing an excel range (of the form Sheet!A1:D10) or a cellranger object

TRUE uses the first row as the column name, FALSE sets names to column.#, or a character vector

NULL to imply type from spreadsheet or one of ignore/logical/numeric/date/string per column

Single string or array of strings to interpret as missing

Trim whitespace from strings

Number of rows to skip before reading data

Additional options. Pass debug = TRUE to return xlsb environment

Path to the xls/xlsx file.

Workbook password

Sheet to read. Either a string (the name of a sheet), or an integer (the position of the sheet). Ignored if the sheet is specified via range. If neither argument specifies the sheet, defaults to the first sheet.

A cell range to read from, as described in cell-specification. Includes typical Excel ranges like "B3:D87", possibly including the sheet name like "Budget!B2:G14", and more. Interpreted strictly, even if the range forces the inclusion of leading or trailing empty rows or columns. Takes precedence over skip, n_max and sheet.

TRUE to use the first row as column names, FALSE to get default names, or a character vector giving a name for each column. If user provides col_types as a vector, col_names can have one entry per column, i.e. have the same length as col_types, or one entry per unskipped column.

Either NULL to guess all from the spreadsheet or a character vector containing one entry per column from these options: "skip", "guess", "logical", "numeric", "date", "text" or "list". If exactly one col_type is specified, it will be recycled. The content of a cell in a skipped column is never read and that column will not appear in the data frame output. A list cell loads a column as a list of length 1 vectors, which are typed using the type guessing logic from col_types = NULL, but on a cell-by-cell basis.

Character vector of strings to interpret as missing values. By default, readxl treats blank cells as missing data.

Should leading and trailing whitespace be trimmed?

Minimum number of rows to skip before reading anything, be it column names or data. Leading empty rows are automatically skipped, so this is a lower bound. Ignored if range is given.

Maximum number of data rows to read. Trailing empty rows are automatically skipped, so this is an upper bound on the number of rows in the returned tibble. Ignored if range is given.

Maximum number of data rows to use for guessing column types.

Display a progress spinner? By default, the spinner appears only in an interactive session, outside the context of knitting a document, and when the call is likely to run for several seconds or more. See readxl_progress() for more details.

Handling of column names. Passed along to tibble::as_tibble(). readxl's default is '.name_repair = "unique", which ensures column names are not empty and are unique.