excel_names

ncol_to_excel

excel_to_ncol

excel_col

<code>ncol_to_excel</code> returns excel column name from a position number. <code>excel_to_ncol</code> returns excel column position number from a column name. <code>excel_col</code> returns all excel column name.

Some tools for cleaning up messy 'Excel' files to be suitable
for R. People who have been working with 'Excel' for years built more
or less complicated sheets with names, characters, formats that are
not homogeneous. To be able to use them in R nowadays, we built a set
of functions that will avoid the majority of importation problems and
keep all the data at best.

vincent guyader

thinkr

Tools for Cleaning Up Messy Files

Vincent Guyader

Sébastien Rochette

ThinkR 

excel_names function

<dl><dt>n</dt>
<dd>the column position</dd>
<dt>col_name</dt>
<dd>the culumn name</dd></dl>

Arguments

Get position or excel name of column — excel_names

<dl>

<dt>n</dt>
<dd>the column position</dd>


<dt>col_name</dt>
<dd>the culumn name</dd>

</dl>

excel_names: Get position or excel name of column

Description

Usage

Arguments

Examples