Writes an R object – usually tabular data like a dataframe or tibble – to a temporary spreadsheet and subsequently opens that
spreadsheet in the system's default application using xopen::xopen(). The latter is usually equivalent to double-clicking on the file in a file browser.
Usage
open_as_tmp_spreadsheet(x, format = c("csv", "xlsx"), ..., quiet = TRUE)Arguments
- x
A dataframe or something coercible to.
- format
The spreadsheet format to use. One of
"csv"for a comma-separated values file written usingreadr::write_csv(). The default."xlsx"for an Office Open XML file commonly used by Microsoft Excel 2007+, written usingwritexl::write_xlsx().
- ...
Further arguments passed on to
readr::write_csv()orwritexl::write_xlsx(), depending onformat.- quiet
Whether or not to echo the command to open the temporary spreadsheet on the console before running it.
See also
Other data frame / tibble functions:
show_diff()