The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

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

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.