excelR
An R interface to jExcel library to create web-based interactive tables and spreadsheets compatible with 'Excel' or any other spreadsheet software.
Installation
To install the stable CRAN version:
install.packages('excelR')To install the latest development version from GitHub:
library(devtools)
install_github('Swechhya/excelR')Simple example
library(excelR)
data = data.frame(Model = c('Mazda', 'Pegeout', 'Honda Fit', 'Honda CRV'),
Date=c('2006-01-01', '2005-01-01','2004-01-01', '2003-01-01' ),
Availability = c(TRUE, FALSE, TRUE, TRUE))
columns = data.frame(title=c('Model', 'Date', 'Availability'),
width= c(300, 300, 300),
type=c('text', 'calendar', 'checkbox'))
excelTable(data=data, columns = columns)
This package can be used in shiny
library(shiny)
library(excelR)
shinyApp(
ui = fluidPage(excelOutput("table")),
server = function(input, output, session) {
output$table <-
renderExcel(excelTable(data = head(iris)))
}
)
Features:
- Insert and delete rows and columns.
- Excel formulas integration
- Drag and drop columns
- Resizable rows and columns
- Merge rows and columns
- Search
- Pagination
- Lazy loading
- Native color picker
- Data picker dropdown with autocomplete, multiple, and icons feature
- Date picker