import_excel: Import data from an excel file

Description Usage Arguments Examples

View source: R/transfer_data.R

Description

Import data from an excel file

Usage

1
2
import_excel(file_path, sheet_number, sheet_name = "Sheet1", row_start,
  row_stop, col_start, col_stop, rownames = FALSE, colnames = FALSE)

Arguments

file_path

Name of excel file

sheet_number

Index of sheet in provided excel file

sheet_name

Name of the excel sheet to be imported (default: "Sheet1")

row_start

Number of first row to import

row_stop

Number of last row to iomport

col_start

Number of first column to import

col_stop

Number of last column to import

rownames

Boolean indicating whther first column should become row names (default: FALSE)

colnames

Boolean indicating whether first row should become column names (default: FALSE)

Examples

1
2
3
4
import_excel(file_path = "C:/Users/adamc/Desktop/Fincher_muscle.xlsx",
            sheet_number = 2, sheet_name = "LatMuscle", row_start = 1,
            row_stop = 3250, col_start = 5, col_stop = 55, rownames = TRUE,
            colnames = TRUE)

adamnc2/simpleSCDE documentation built on May 7, 2019, 7:40 a.m.