v2: opens data in spreadsheet program

In emilBeBri/dttools: Useful Tools Built Around Data.Table

Description

opens data in spreadsheet program2

Usage

v2(
  data,
  filter = TRUE,
  table = TRUE,
  n = 9000,
  all = FALSE,
  sample = FALSE,
  engine = "writexl"
)

Arguments

data	a data.frame
filter	should there be the autofilter function enabled in the spreadsheet?
table	as a table?
n	number of rows
all	should all rows be used? if TRUE, overrules the n argument.
sample	should the n rows be sampled of taken from the top down?
engine	which package should be used for convertion to xlsx? default is readxl. openxlsx has better setup of view options (such as using the excel-table function for autosorting), but in some rare cases it will fail on encoding of characters, deleting all information in the process, with no warning (that I can figure out). So it's not default for that reason, but will probably work fine most of the time. Just be careful about data loss when using it.

Value

This function opens a data.frame in a spreadsheet viewer. if asssigned to an object, the data.frame as well as manual changes in the spreadsheet will be saved to that object.

Examples

## Not run: 
dat2 <- vi(  dupstestdata)

## End(Not run)

emilBeBri/dttools documentation built on April 21, 2021, 5:44 a.m.