Skip to content

Swechhya/excelR

Repository files navigation

excelR

version CRAN_Download_Badge Travis-CI Build Status AppVeyor Build Status codecov R Build and Checks

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)

excelTable

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