I have some fairly basic data, a few columns and about 100 rows.  From
time to time I might want to swap the columns or re-order the rows and
so it would be useful to hold the data in something like Excel.

However I don't want all the slush that comes from Excel when I output
to a table.

Is there any easy way around this?

Thanks


-- 
AnthonyL

<uk.net.web.authoring>
<AnthonyL>
<Mon, 22 Sep 2008 11:42:58 GMT>


> I have some fairly basic data, a few columns and about 100 rows.  From
> time to time I might want to swap the columns or re-order the rows and
> so it would be useful to hold the data in something like Excel.
> 
> However I don't want all the slush that comes from Excel when I output
> to a table.
> 
> Is there any easy way around this?
> 

Yes - buy a magic wand :-)


-- 
www.phpguestbook.co.uk/phpgb
(the best php guestbook on planet earth)

On Mon, 22 Sep 2008 11:42:58 GMT, nospam@please.invalid (AnthonyL)
wrote:

>I have some fairly basic data, a few columns and about 100 rows.  From
>time to time I might want to swap the columns or re-order the rows and
>so it would be useful to hold the data in something like Excel.
>
>However I don't want all the slush that comes from Excel when I output
>to a table.
>
>Is there any easy way around this?
>
>Thanks

Add blank columns either side of your data columns.
In col 1 put <tr><td> all the way down.
Col 2 has data.
Col 3 put </td><td> all the way down
Col 4 has data
etc etc
Last Col has </td></tr> all the way down

Copy spreadsheet as a txt doc and place in your HTML.


-- 
Jimmy

On 22 Sep, 14:03, Jimmy  wrote:
> On Mon, 22 Sep 2008 11:42:58 GMT, nos...@please.invalid (AnthonyL)
> wrote:
>
> >I have some fairly basic data, a few columns and about 100 rows.  From
> >time to time I might want to swap the columns or re-order the rows and
> >so it would be useful to hold the data in something like Excel.
>
> >However I don't want all the slush that comes from Excel when I output
> >to a table.
>
> >Is there any easy way around this?
>
> >Thanks
>
> Add blank columns either side of your data columns.
> In col 1 put <tr><td> all the way down.
> Col 2 has data.
> Col 3 put </td><td> all the way down
> Col 4 has data
> etc etc
> Last Col has </td></tr> all the way down
>
> Copy spreadsheet as a txt doc and place in your HTML.

Or better still if you're going to do this regularly, use formulae on
a second sheet for example ="<td>"&sheet1!A1&"</td>" (etc) and then
use Jimmy's copy and paste trick. This means you can update you data
on sheet1 and instantly get HTML output from sheet2 without fiddling
around with the data sheet.


Saul
www.notanant.com
Communities of websites

On Mon, 22 Sep 2008 11:42:58 GMT, nospam@please.invalid (AnthonyL)
wrote:

>I have some fairly basic data, a few columns and about 100 rows.  From
>time to time I might want to swap the columns or re-order the rows and
>so it would be useful to hold the data in something like Excel.
>
>However I don't want all the slush that comes from Excel when I output
>to a table.
>
>Is there any easy way around this?
>
>Thanks

export as .csv and read in and generate page dynamically with Perl/PHP
etc


-- 
Regards, Paul Herber, Sandrila Ltd. 
http://www.sandrila.co.uk/              http://www.pherber.com/

On Mon, 22 Sep 2008 09:39:00 -0700 (PDT), Saul
 wrote:

>On 22 Sep, 14:03, Jimmy  wrote:
>> On Mon, 22 Sep 2008 11:42:58 GMT, nos...@please.invalid (AnthonyL)
>> wrote:
>>
>> >I have some fairly basic data, a few columns and about 100 rows. =A0From
>> >time to time I might want to swap the columns or re-order the rows and
>> >so it would be useful to hold the data in something like Excel.
>>
>> >However I don't want all the slush that comes from Excel when I output
>> >to a table.
>>
>> >Is there any easy way around this?
>>
>> >Thanks
>>
>> Add blank columns either side of your data columns.
>> In col 1 put <tr><td> all the way down.
>> Col 2 has data.
>> Col 3 put </td><td> all the way down
>> Col 4 has data
>> etc etc
>> Last Col has </td></tr> all the way down
>>
>> Copy spreadsheet as a txt doc and place in your HTML.
>

Doh!  So easy - thanks very much.


>Or better still if you're going to do this regularly, use formulae on
>a second sheet for example =3D"<td>"&sheet1!A1&"</td>" (etc) and then
>use Jimmy's copy and paste trick. This means you can update you data
>on sheet1 and instantly get HTML output from sheet2 without fiddling
>around with the data sheet.
>

Yes, that sounds neat.  I'll give it a try.


-- 
AnthonyL