Home Messages Index
[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index

Re: seeking suggestion for posting spreadsheet data on web

  • Subject: Re: seeking suggestion for posting spreadsheet data on web
  • From: Roy Schestowitz <newsgroups@xxxxxxxxxxxxxxx>
  • Date: Mon, 22 Aug 2005 16:07:14 +0100
  • Newsgroups: alt.html
  • Organization: schestowitz.com / Manchester University
  • References: <debg7h$fhk$1@justice.itsc.cuhk.edu.hk>
  • Reply-to: newsgroups@xxxxxxxxxxxxxxx
  • User-agent: KNode/0.7.2
On Monday 22 August 2005 04:20, Ross wrote:

> dear all, i have the following table of data to post on web,
> 
> name    size    length    0min    3min    10min    chart
> A        3        5        1        10       3     figA.gif
> B        5        2        2        4        3     figB.gif
> C        4        3        3        9        6     figC.gif
> ...
> 
> I am seeking your advice on the programming language for such an action. i
> prefer a web table capable of sorting by size, length and so on, therefore
> built-in function for sorting is appreciated.

Hi Ross,

I always prefer to think in terms of comma-separated values when handling
spreadsheets. Let us say that you use PHP and then pick one token at a time
with the intention of feeding it in to the database.

Thereafter, all you ought to do is create a database with tuples that
correspond to the columns of the table above. You should create some
meaningful functions (abstraction) to fetch column (value) given field
(row) and then work deeper to get more complex operations working. There
must be something like this lying around publicly, so don't re-invent the
wheel if possible. Do your homework before implementing anything.

To output the data, it would sensible in this particular case to place
everything in tables (Look ma! No divs!), e.g.

<table>
<tbody>
<tr>
<td>
A
</td>
<td>
3
</td>
<td>
6
</td>
<td>
1
</td>
<td>
10
</td>
<td>
3
</td>
<td>
<img src="figA.gif" alt="figA" />
</td>
</tr>
</tbody>
</table>


Hope it helps,

Roy

-- 
Roy S. Schestowitz        Useless fact: Florida is bigger than England
http://Schestowitz.com

[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index