36
An R interface to jExcel library to create web-based interactive table
source link: https://www.tuicool.com/articles/EfEfUfa
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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
- Great data picker: dropdown, autocomplete, multiple, group options and icons
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK