read_excel: Read excel data into R

In DanielGardiner/HelperFunc: A collection of helpful functions

Description

A function to easily copy data into R from a spreadsheet. This should not be used within a reproducible work flow, instead it should only be used on an ad-hoc basis (note: I'm not aware of the original author of this function, it was taken directly from a stack overflow answer)

Usage

read_excel(header = TRUE, ...)

Arguments

header	a logical indicating if a header has been copied
...	other read.table options

Value

a data.frame consisting of data copied to clipboard

Examples

# first copy data to clipboard (i.e. highlight data in spreadsheet and press ctrl + c)

# apply function to read data from clipboard into R

data = read_excel()

DanielGardiner/HelperFunc documentation built on May 23, 2019, 2:42 p.m.