read a sheet table in xlsx file as a ``dataframe`` object.

read.xlsx {xlsx}

R Documentation

read a sheet table in xlsx file as a ``dataframe`` object.

Description

Usage

read.xlsx(file,
    sheetIndex = "Sheet1",
    row.names = NULL,
    raw = FALSE,
    check.names = TRUE,
    check.modes = TRUE,
    comment.char = "#",
    skip.rows = -1);

Arguments

sheetIndex

the data sheet index or name for read data. the index value of parameter should be start from base 1 if the type is an integer index

check.modes

check the data type of each column in the dataframe? this options is working if the raw parameter is set to FALSE. [as boolean]

check.names

make valid R# symbol names of each column in the dataframe? this options is working if the raw parameter is set to FALSE. [as boolean]

row.names

A character vector for set row names of the generated dataframe, or a character name in the dataframe, or an integer value to indicate that which column should be used as the row names of the dataframe object. this options is working if the raw parameter is set to FALSE.

file

the file path of the target xlsx data file.

Authors

SMRUCC genomics

Value

this function returns data object in these one of the listed data types: dataframe, File.

clr value class

[Package xlsx version 6.0.0.3654 Index]