xlsx_exp: Exporting data into .xlsx files

Description Usage Arguments Value Examples

View source: R/xlsx_exp.R

Description

Exporting one or multiple tables into a .xlsx file. If there are multiple tables, each one will be stored in the same file in different sheets.

Usage

1
2
3
4
5
6
7
8
9
xlsx_exp(
  data,
  sheetnames = NULL,
  filename,
  path,
  keepNA = F,
  colnames = T,
  rownames = F
)

Arguments

data

data frame or list of data frames

sheetnames

character vector used to name each file sheet

filename

character to name the exported file

path

path where to store the file inside the working directory

keepNA

logical, indicating if missing values should be displayed or not. If TRUE, are displayed. Default set to FALSE. Note: if keepNA = TRUE, and the column is numeric, it would turn into character.

colnames

logical, indicating if column names should be in the output. If true, column names are in the first row. Default set to TRUE.

rownames

logical, indicating if row names should be in the output. If true, row names are in the first column. Default set to TRUE.

Value

.xlsx file exported in the indicated path.

Examples

1
xlsx_exp(data = mtcars, filename = "prueba", rownames = TRUE)

cristhianlarrahondo/cristhiansPackage documentation built on Dec. 19, 2021, 6:20 p.m.