readSEAxls: Read in SEA data from an Excel spreadsheet

In benharden27/sea: Process and plot data from the Sea Education Association's archive

Description

Function used commonly as much data entry and organization is acheived in this format

Usage

readSEAxls(filein, skip = 0, sheet = 1, rplcsv = FALSE)

Arguments

filein	.xls, .xlsm, .xlsx file to read from
skip	Number of rows to skip at the top of the xls file before reading
sheet	Number of the sheet in the file to be read
rplcsv	Function will create a csv file in the same directory as the xls file for quicker reading next time. rplcsv will override whether this function will overwrite that or look for it and read from it.

Details

Notes: Requires readxl package. readxl is slower than read.table so the function creates a .csv file of the output for quicker reading next time. Can be overridded using rplcsv.

Examples

# Read in an example neuston datasheet
df <- readSEAxls(system.file('extdata','S275_Neuston.xlsm',package='sea'))

benharden27/sea documentation built on May 14, 2019, 4:18 p.m.