The pipesheet package is a free and open source software package in R that provides functions for editing Excel data within R. It allows users to write data to Excel, open it for editing, and then read the edited data back into R. This package is useful for quickly updating data in Excel and integrating it with R workflows.
You can install the pipesheet package from GitHub using the remotes
package:
# Install remotes package if not already installed
install.packages("remotes")
# Install the pipesheet package from GitHub
remotes::install_github("catbru/pipesheet")
Once the pipesheet package is installed, you can load it into your R session using the library()
function:
library(pipesheet)
The main functions provided by the pipesheet package are:
-
edit(data)
: Writes data to a temporary Excel file, opens it for editing in Excel, and reads the edited data back into R as a tibble. -
view(data, row.names = FALSE)
: Writes data to a temporary Excel file and opens it for viewing in Excel. Therow.names
argument allows you to specify whether to include row names in the Excel file.
Here are some examples of how to use the pipesheet package:
# Load the pipesheet package
library(pipesheet)
# Create a sample data frame
data <- data.frame(
ID = c(1, 2, 3),
Name = c("John", "Alice", "Bob"),
Age = c(25, 30, 35))
# Edit the data in Excel
edited_data <- edit(data)
# View the data in Excel
view(data)
If you would like to contribute to the pipesheet package, please follow the guidelines in the CONTRIBUTING.md file in the GitHub repository. We welcome contributions, bug reports, and feedback to improve the package.
This package is free and open source software, licensed under GPL-3. Please see the LICENSE.md file for more information.
For any questions, issues, or feedback, please contact Roger Sanjaume at [email protected].