rhandsontable

A htmlwidgets implementation of Handsontable.js

https://github.com/jrowen/rhandsontable

Science Score: 23.0%

This score indicates how likely this project is to be science-related based on various indicators:

○
CITATION.cff file
✓
codemeta.json file
Found codemeta.json file
○
.zenodo.json file
○
DOI references
○
Academic publication links
✓
Committers with academic emails
1 of 21 committers (4.8%) from academic institutions
○
Institutional organization owner
○
JOSS paper metadata
○
Scientific vocabulary similarity
Low similarity (13.8%) to scientific vocabulary

Keywords

handsontable htmlwidgets javascript r shiny sparkline

Last synced: 6 months ago · JSON representation

Repository

A htmlwidgets implementation of Handsontable.js

Basic Info

Host: GitHub
Owner: jrowen
License: other
Language: HTML
Default Branch: master
Homepage: http://jrowen.github.io/rhandsontable/
Size: 112 MB

Statistics

Stars: 390
Watchers: 33
Forks: 149
Open Issues: 166
Releases: 11

Topics

handsontable htmlwidgets javascript r shiny sparkline

Created almost 11 years ago · Last pushed over 1 year ago

Metadata Files

Readme Changelog License

README.md

See the project website for more details and live examples, and see below for important details on use in shiny apps.

An htmlwidgets implementation of Handsontable.js. Per the website:

Handsontable is a minimalist Excel-like data grid editor for HTML & JavaScript

This library was inspired by the shinyTable package. Most of the original functionality was preserved, and the htmlwidgets framework made it possible to leverage even more of the Handsontable.js functionality.

Note: With v7, handsontable went to a more restrictive license for commercial use. To avoid license violations for existing users, rhandsontable will not update handsontable beyond v6.2.2. This may change in the future if a way is found to manage multiple handsontable versions.

See the vignette for detailed examples and links to shiny apps.

To install from CRAN use R install.packages("rhandsontable") For the latest development version use R devtools::install_github("jrowen/rhandsontable")

A simple example ```R library(rhandsontable)

DF = data.frame(int = 1:10, numeric = rnorm(10), logical = TRUE, character = LETTERS[1:10], fact = factor(letters[1:10]), date = seq(from = Sys.Date(), by = "days", length.out = 10), stringsAsFactors = FALSE)

add a sparkline chart

DF$chart = sapply(1:10, function(x) jsonlite::toJSON(list(values=rnorm(10))))

rhandsontable(DF, rowHeaders = NULL) %>% hot_col("chart", renderer = htmlwidgets::JS("renderSparkline")) ``` alt tag

A more involved shiny example R shiny::runGitHub("rhandsontable", "jrowen", subdir = "inst/examples/rhandsontable_corr")

Important note on shiny use: The htmlwidgets package creates widgets as shiny output bindings. The rhandsontable package also attempts to expose the table as a pseudo shiny input binding using handsontable change events (see here for the supported events). This means the table (e.g. hot) can be accessed in shiny using either input$hot or output$hot, but these values may not be in-sync. The timing of updates will depend on the particular reactive path followed by your shiny application.

Since the widget is not currently able to use the standard shiny input binding functionality, you will need to explicitly call the hot_to_r function to convert the handsontable data to an R object.

Two additional inputs are also enabled, input$hot_select and input$hot_comment, which will fire when a cell selection or a comment changes, respectively (if you would like to see more options, please post an issue or create a PR).

This functionality is still evolving, so please don't hesitate to share suggestions and PRs.

Owner

Name: Jonathan Owen
Login: jrowen
Kind: user
Location: Minneapolis

Repositories: 15
Profile: https://github.com/jrowen

GitHub Events

Total

Issues event: 1
Watch event: 11
Issue comment event: 5
Fork event: 4

Last Year

Issues event: 1
Watch event: 11
Issue comment event: 5
Fork event: 4

Committers

Last synced: about 2 years ago

All Time

Total Commits: 453
Total Committers: 21
Avg Commits per committer: 21.571
Development Distribution Score (DDS): 0.121

Past Year

Commits: 0
Committers: 0
Avg Commits per committer: 0.0
Development Distribution Score (DDS): 0.0

Top Committers

Name	Email	Commits
Jonathan Owen	j**o@g**m	398
Dillon Hammill	D**l@a**u	16
Yihui Xie	x**e@y**e	9
Jonathan Owen	j**o@g**m	5
Tomas	x**k@g**m	3
Paul	3**n@u**m	3
Dillon	d**1@l**u	2
Enzo	e**o@s**m	2
marciz	m**a@g**m	2
Ryan	r**n@1**t	2
Carsten Moldenhauer	c**r@h**m	1
Joe	r**j@u**m	1
Paul-A-Kavan	p**a@g**m	1
Stéphane Le Hénanff	s**H@u**m	1
Tim Jones	t**1@a**k	1
Xianying Tan	s**n@1**m	1
jrowen	j**n@g**m	1
Tadeas Palusga	t**a@v**m	1
kelly hondula	k**a@s**g	1
VL	v**k@g**m	1
timelyportfolio	k**l@t**m	1

Committer Domains (Top 20 + Academic)

timelyportfolio.com: 1 sesync.org: 1 vendavo.com: 1 126.com: 1 amey.co.uk: 1 horvath-partners.com: 1 10-209-107-21.cloud.opsource.net: 1 smartinsightsfromdata.com: 1 live.com.au: 1 yihui.name: 1 anu.edu.au: 1

Issues and Pull Requests

Last synced: 7 months ago

All Time

Total issues: 102
Total pull requests: 12
Average time to close issues: 5 months
Average time to close pull requests: about 1 year
Total issue authors: 92
Total pull request authors: 11
Average comments per issue: 2.58
Average comments per pull request: 2.33
Merged pull requests: 3
Bot issues: 0
Bot pull requests: 0

Past Year

Issues: 1
Pull requests: 1
Average time to close issues: N/A
Average time to close pull requests: N/A
Issue authors: 1
Pull request authors: 1
Average comments per issue: 1.0
Average comments per pull request: 0.0
Merged pull requests: 0
Bot issues: 0
Bot pull requests: 0

View more stats

Top Authors

Issue Authors

pnacht (3)
nick-youngblut (2)
DillonHammill (2)
thomasthomasth (2)
zburch (2)
Alik-V (2)
stla (2)
RajBalakrishnan (2)
mviertel (1)
thevoiceofdoom (1)
priyankagagneja (1)
Logan-Borders (1)
YsoSirius (1)
frederikvp (1)
abbatidanilo (1)

Pull Request Authors

nick-youngblut (2)
DillonHammill (2)
stla (2)
shosaco (1)
msaltieri (1)
timelyportfolio (1)
JohnCoene (1)
marciz (1)
ericnewkirk (1)
trshafer (1)
klin333 (1)

Top Labels

Issue Labels

question (4) bug (3) more info needed (3) external library (2) enhancement (1) help wanted (1)

Pull Request Labels

Packages

Total packages: 3
Total downloads:
- cran 6,004 last-month
Total docker downloads: 50,180

Total dependent packages: 55
(may contain duplicates)
Total dependent repositories: 97
(may contain duplicates)
Total versions: 25
Total maintainers: 1

cran.r-project.org: rhandsontable

Interface to the 'Handsontable.js' Library

Homepage: http://jrowen.github.io/rhandsontable/
Documentation: http://cran.r-project.org/web/packages/rhandsontable/rhandsontable.pdf
License: MIT + file LICENSE
Latest release: 0.3.8
published over 4 years ago

Versions: 13
Dependent Packages: 52
Dependent Repositories: 96
Downloads: 6,004 Last month
Docker Downloads: 50,180

Rankings

Forks count: 0.4%

Stargazers count: 1.0%

Dependent packages count: 1.7%

Average: 2.1%

Dependent repos count: 2.3%

Docker downloads count: 2.5%

Downloads: 4.8%

Maintainers (1)

jonathanro@gmail.com

Last synced: 6 months ago

proxy.golang.org: github.com/jrowen/rhandsontable

Documentation: https://pkg.go.dev/github.com/jrowen/rhandsontable#section-documentation
License: other
Latest release: v0.3.8
published over 4 years ago

Versions: 9
Dependent Packages: 0
Dependent Repositories: 0

Rankings

Dependent packages count: 5.4%

Average: 5.6%

Dependent repos count: 5.8%

Last synced: 6 months ago

conda-forge.org: r-rhandsontable

Homepage: http://jrowen.github.io/rhandsontable/
License: MIT
Latest release: 0.3.8
published over 4 years ago

Versions: 3
Dependent Packages: 3
Dependent Repositories: 1

Rankings

Dependent packages count: 15.6%

Forks count: 15.7%

Average: 19.1%

Stargazers count: 20.5%

Dependent repos count: 24.4%

Last synced: 6 months ago

Dependencies

DESCRIPTION cran

htmlwidgets >= 0.3.3 imports
jsonlite * imports
magrittr * imports
methods * imports
utils * imports
htmltools * suggests
knitr * suggests
miniUI >= 0.1.1 suggests
rmarkdown * suggests
rstudioapi >= 0.6 suggests
shiny >= 0.13 suggests