In my company we are just starting a new project where we would need a web-based, Excel-like user interface, where users need to maintain and correct long lists of data (i.e. up to 60,000 lines with 120 columns). Required features include "Formulas for cell calculation", "Data validation of entries", "Freezing of columuns and rows", "color-coding", "etc."
Since there is a lot of auomatic data wrangling happening before and after users work with these lists, I would prefere a complete R solution for this project.
This would mean that also this "Excel-User-Interface" would need to be realized in Shiny.
My question is now how to go about this and what packages to use?
I have looked into rhandsontable (which seems to fulfill the requirements) but when I look into github then I see that the last change is from 2021 (and for a new project I don't want to start using a package that might no longer be maintained).
Therefore three questions:
Is "rhandsontable" still under maintenance?
What is your experience with this package? Can you guys recommend it for professional usage in a corporate environment?
Or are there alternatives that you could suggest?
Thanks and Best!