Can javascript sort, filter, and render a very large table?

xyliu00 picture xyliu00 · Sep 21, 2012 · Viewed 8.3k times · Source

First of all, I have no idea of Javascript's capability on this. But would like to know if it is possible:

  1. To read from a text file and display a very large table (a couple dozens of columns and a few hundred thousands of rows), in sections;
  2. Not all columns will displayed in the same time. columns are in groups. a group of columns needs to toggle between hidden or show;
  3. rows can be filtered based on certain columns.

The reason to do this is to make a report that displays data analysis results and also provides basic filter, sorting functions for the user. They most likely to have some sort of web browser. So HTML would be an ideal format.

Is it possible with Javascript?

Thanks!

Answer

Justin Ethier picture Justin Ethier · Sep 21, 2012

You might be able to do this by using a grid plugin. For example, have at look at the answers to this question: JavaScript data grid for millions of rows