read_xlsb

path

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

sheet

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

range

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

col_names

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

col_types

Single string or array of strings to interpret as missing

trim_ws

Number of rows to skip before reading data

skip

Additional options. Pass debug = TRUE to return xlsb environment

Imports a region from an xlsb workbook

Import data from 'Excel' binary (.xlsb) workbooks into R.

Michael Allen

readxlsb

Read 'Excel' Binary (.xlsb) Workbooks

read_xlsb function

<dl><dt>path</dt>
<dd>Path to the xlsb workbook</dd>
<dt>sheet</dt>
<dd>Name or index of the sheet to read. If the sheet name is specified as part of the range, this parameter is ignored</dd>
<dt>range</dt>
<dd>A named range or a string representing an excel range (of the form Sheet!A1:D10) or a cellranger object</dd>
<dt>col_names</dt>
<dd>TRUE uses the first row as the column name, FALSE sets names to column.#, or a character vector</dd>
<dt>col_types</dt>
<dd>NULL to imply type from spreadsheet or one of ignore/logical/numeric/date/string per column</dd>
<dt>na</dt>
<dd>Single string or array of strings to interpret as missing</dd>
<dt>trim_ws</dt>
<dd>Trim whitespace from strings</dd>
<dt>skip</dt>
<dd>Number of rows to skip before reading data</dd>
<dt>...</dt>
<dd>Additional options. Pass debug = TRUE to return xlsb environment</dd></dl>

Arguments

Read xlsb workbook — read_xlsb

<dl>

<dt>path</dt>
<dd>Path to the xlsb workbook</dd>


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


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


<dt>col_names</dt>
<dd>TRUE uses the first row as the column name, FALSE sets names to column.#, or a character vector</dd>


<dt>col_types</dt>
<dd>NULL to imply type from spreadsheet or one of ignore/logical/numeric/date/string per column</dd>


<dt>na</dt>
<dd>Single string or array of strings to interpret as missing</dd>


<dt>trim_ws</dt>
<dd>Trim whitespace from strings</dd>


<dt>skip</dt>
<dd>Number of rows to skip before reading data</dd>


<dt>...</dt>
<dd>Additional options. Pass debug = TRUE to return xlsb environment</dd>

</dl>

read_xlsb: Read xlsb workbook

Description

Usage

Arguments

Examples