search

jrowen / rhandsontable

A htmlwidgets implementation of Handsontable.js
http://jrowen.github.io/rhandsontable/
Other
385 stars 148 forks source link

multiple pages for very big data #401

Open ShinyFabio opened 2 years ago

ShinyFabio commented 2 years ago

Hi, I have a very big excel file with 11 columns and more than 10k rows. When I want to edit, the shiny app freezes because rhandsontable is trying to print all my 10k rows. So I searched some rhandsontable and handsontable options and I found a maxRows argument and now I can restrict the number of rows to be shown. But if for example I set maxRows to 100, I can see just the first 100 rows. Is there a way to split the table into multiple pages like in {DT} package so I can see all rows?

hjia222 commented 2 years ago

You set the height and sliders will show up, I guess rhandsontable does not support pagination.

ShinyFabio commented 2 years ago

I already have a slider, the problem is that if I don't set maxRows, rhandsontable prints all rows. I can for sure use the slider, but I have to wait that all the rows are rendered and in my case it takes a lot. I think the only solution is pagination.

NOTE: I've just noticed that I didn't specify that I'm using this package on a Shiny App. That's why I made the comparison with DT package.

hjia222 commented 2 years ago

I see. Pagination in DT does not speed up the rendering, but there is a 'deferRender' option for DT table to speed up rendering. Not sure if rhandsontable has the option.