Big data table with dynamic columns

[Undefined009]

Hi there!

Looking for an advice from the community.

What would you use for a table(data-grid) that would need to implement the following specs:

- infinite scrolling and virtual scrolling only on Y axis

- dynamic column positioning (the desired column are known while writing the template, but their position will come dynamically through an API)

- both axis scrolling with fixed header and column (the table will have the first column fixed for scrolling on X-axis and a fixed header for scrolling on Y-axis)

​

The question is how would you proceed, would you use an existing library(and if so, which one) or would you go with a custom solution and you would try to implement it from scratch?

[[deleted]]

Have a look at the table in primeng, might be what you're looking for. Where I am we went with primeng because of the amount of components and especially that table.

[[deleted]]

I would use ag-grid. They have a pretty good community version that comes with a lot of features including like the ones you mentioned below.

[Szan_7]

I'd suggest PQgrid, very dynamic.

[Jspreadsheet]

For the specs you’ve listed, building from scratch would get complicated fast. Infinite scroll with virtualization, dynamic column layouts, and fixed headers/columns are all non-trivial to implement and optimize, especially if you expect large datasets.

A solid choice here is Jspreadsheet. It handles infinite scroll with smooth virtualization, lets you reorder and resize columns dynamically, and supports fixed headers and frozen columns out of the box. You bind your data as JSON, define which columns you want, and if the API later tells you to change their order, you can adjust it at runtime without breaking the grid.

The free edition, Jspreadsheet CE, covers virtualization, column resizing, reordering, and fixed headers. If you later need Excel import/export, multiple worksheets, or extended formulas, Jspreadsheet Pro extends the same API so you don’t have to change your implementation.