I am currently looking for ideas on ways to display potentially large
amounts of data in a spreadsheet format using Struts. The form is a
fairly simple maximum 30 column by maximum 5000 or so row table, which
needs to be dynamically filled with data. Most usages would probably
fall into the 8 by 30 range, but I need to plan for more in unusual
cases.
The array is only sparsely filled with data, so I currently plan to send
an ArrayList of ArrayLists for the row by column data: where each row
would have a list of column instances which skip over unused instances
(if data for a given cell doesn't exist, then I plant a "0" for the data
in that cell and move on). Another twist to this is that if a column
doesn't exist at all in the spreadsheet, I am supposed to collapse the
column altogether and not display it to save screen space.
A typical (small) display might look like this:
Xname
Yname x1 x2 x5 x6 x15 x24 Total
foo1 0 0 10 0 0 20 30
foo2 12 5 0 0 20 0 37
foo6 0 15 10 20 0 0 35
Anyway, I figured I'd probably use one logic:iterate tag to iterate over
each row, and another one to iterate over each row's column, and that
I'd proceed to dump all of this data one cell at a time (or not - for
those cells which are skipped). The fact that I need to check each
column item to see whether it is skipping, as well as the fact that not
all columns might even be displayed means that there will potentially be
a fair amount of additional [undesirable] scriptlet code I will need to
explain away at my code review.
It just seems like this is such a common thing to have to do that before
I go reinventing another wheel, I thought I ought to at least check to
see it there might be a more standardized way of doing this?
Thanks
Dave McLure
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
